Introductory SQL Training Manual Classroom in a Book PDF Download
Are you looking for read ebook online? Search for your book and save it on your Kindle device, PC, phones or tablets. Download Introductory SQL Training Manual Classroom in a Book PDF full book. Access full book title Introductory SQL Training Manual Classroom in a Book by TeachUcomp . Download full books in PDF and EPUB format.
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 84
Get Book Here
Book Description
Complete classroom training manual to learn Introductory SQL. 84 pages and 43 individual topics. Includes practice exercises and keyboard shortcuts. The goal of this course to give the student the knowledge of which SQL statement they will need to use to accomplish specific tasks within a database, as well as provide links to database-specific implementations of those core statements. Topics Covered: Introduction to Databases and SQL 1. Overview of a Database 2. The “Flat-File” Method of Data Storage 3. The Relational Model of Data Storage 4. Tips for Creating a Relational Database 5. What is SQL? 6. Using SQL in Access 2013 Data Definition Language 1. The CREATE Statement 2. The CREATE DATABASE Statement 3. The CREATE TABLE Statement 4. The CREATE INDEX Statement 5. SQL Constraints 6. The DROP Statement 7. The ALTER TABLE Statement 8. NULL Values in SQL 9. Data Types in SQL 10. Auto-Increment in SQL Data Manipulation Language 1. The INSERT Statement 2. The UPDATE Statement 3. The DELETE Statement 4. The SELECT Statement 5. The WHERE Clause 6. Criteria Notation and Wildcard Characters in the WHERE Clause 7. The ORDER BY Clause 8. The GROUP BY Clause and Aggregate Functions 9. The JOIN Clause 10. The UNION Operator 11. The SELECT INTO Statement 12. The INSERT INTO SELECT Statement 13. Subqueries Data Control Language 1. The CREATE USER and CREATE ROLE Statements 2. Privileges 3. The GRANT Statement 4. The REVOKE Statement 5. The ALTER USER and ALTER ROLE Statements 6. The DROP USER and DROP ROLE Statements Transaction Control Language 1. The TRANSACTION Statement SQL Functions and Aliases 1. Understanding SQL Functions 2. Calculated Fields and Column Aliases 3. Table Aliases Views 1. About Views 2. The CREATE VIEW Statement 3. The ALTER VIEW Statement 4. The DROP VIEW Statement
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 84
Get Book Here
Book Description
Complete classroom training manual to learn Introductory SQL. 84 pages and 43 individual topics. Includes practice exercises and keyboard shortcuts. The goal of this course to give the student the knowledge of which SQL statement they will need to use to accomplish specific tasks within a database, as well as provide links to database-specific implementations of those core statements. Topics Covered: Introduction to Databases and SQL 1. Overview of a Database 2. The “Flat-File” Method of Data Storage 3. The Relational Model of Data Storage 4. Tips for Creating a Relational Database 5. What is SQL? 6. Using SQL in Access 2013 Data Definition Language 1. The CREATE Statement 2. The CREATE DATABASE Statement 3. The CREATE TABLE Statement 4. The CREATE INDEX Statement 5. SQL Constraints 6. The DROP Statement 7. The ALTER TABLE Statement 8. NULL Values in SQL 9. Data Types in SQL 10. Auto-Increment in SQL Data Manipulation Language 1. The INSERT Statement 2. The UPDATE Statement 3. The DELETE Statement 4. The SELECT Statement 5. The WHERE Clause 6. Criteria Notation and Wildcard Characters in the WHERE Clause 7. The ORDER BY Clause 8. The GROUP BY Clause and Aggregate Functions 9. The JOIN Clause 10. The UNION Operator 11. The SELECT INTO Statement 12. The INSERT INTO SELECT Statement 13. Subqueries Data Control Language 1. The CREATE USER and CREATE ROLE Statements 2. Privileges 3. The GRANT Statement 4. The REVOKE Statement 5. The ALTER USER and ALTER ROLE Statements 6. The DROP USER and DROP ROLE Statements Transaction Control Language 1. The TRANSACTION Statement SQL Functions and Aliases 1. Understanding SQL Functions 2. Calculated Fields and Column Aliases 3. Table Aliases Views 1. About Views 2. The CREATE VIEW Statement 3. The ALTER VIEW Statement 4. The DROP VIEW Statement
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 226
Get Book Here
Book Description
Complete classroom training manuals for Crystal Reports. Two manuals (Introductory and Advanced) in one book. 226 pages and 118 individual topics. Includes practice exercises and keyboard shortcuts. You will learn all about how to establish data connections, create complex and detailed reports, advanced charting techniques and much more. Topics Covered: The Crystal Reports Environment 1. Starting Crystal Reports 2. The Menu Bar 3. Using Toolbars 4. The Design View Creating Data Connections 1. Creating a New Blank Report 2. The Database Expert 3. Access/Excel (DAO) 4. ADO.NET (XML) 5. Database Files 6. Java Beans Connectivity 7. JDBC (JNDI) 8. ODBC (RDO) 9. OLAP 10. OLE DB (ADO) 11. Salesforce.com 12. SAP BW MDX Query 13. SAP Info Sets 14. SAP Operational Data Source 15. SAP Table, Cluster, or Function 16. Universes 17. XML and Web Services 18. Repository 19. More Data Sources 20. Selecting Report Data and Tables 21. The Data Explorer Creating Basic Reports 1. Adding Data Fields to a Report 2. Browsing Field Data 3. Selecting, Moving, and Resizing Fields 4. Using the “Size” and “Align” Commands 5. Creating Text Objects 6. Saving a Report 7. Previewing a Report 8. Refreshing the Report Data Linking Tables in a Report 1. Basic Table Structures and Terms 2. Linking Multiple Tables 3. Table Joins 4. Enforcing Table Joins and Changing Link Types Basic Formatting Techniques 1. Formatting Report Objects 2. The “Common” Tab of the Format Editor 3. The “Number” Tab of the Format Editor 4. The “Font” Tab of the Format Editor 5. The “Border” Tab of the Format Editor 6. The “Date and Time” Tab of the Format Editor 7. The “Paragraph” Tab of the Format Editor 8. The “Picture” Tab of the Format Editor 9. The “Boolean” Tab of the Format Editor 10. The “Hyperlink” Tab of the Format Editor 11. The “Subreport” Tab of the Format Editor 12. Drawing Lines 13. Drawing Boxes 14. Format Painter 15. Formatting Part of a Text Object 16. The Template Expert 17. Inserting Pictures Record Selection 1. The Select Expert 2. Setting Multiple Filters 3. Editing the Selection Formula Sorting and Grouping Records 1. The Record Sort Expert 2. The Group Expert 3. Managing Groups 4. Summarizing Groups 5. Hierarchical Groupings 6. The Group Sort Expert Printing Reports 1. Inserting Special Fields 2. Page Setup 3. Printing Reports Using Formulas 1. Crystal Reports Formula Syntax 2. The Formula Workshop- Formula Editor Window 3. Creating Formula Fields 4. Crystal Syntax 5. Basic Syntax 6. Finding Function and Operator Assistance Advanced Formatting 1. The Highlighting Expert 2. The Section Expert 3. Conditionally Formatting a Section 4. Conditionally Formatting a Field 5. Manipulating Multiple Sections Summary Reports 1. Summarizing Report Data 2. Using the DrillDownGroupLevel Feature Charting 1. The Chart Expert 2. Editing Charts 3. Setting General Chart Options 4. Formatting Selected Chart Items 5. Formatting a Data Series 6. Formatting Chart Gridlines 7. Setting Chart Axes Options 8 . Adding Chart Trendlines 9 . Modifying a 3D Chart View 10. Using Chart Templates 11. Auto-Arranging Charts Advanced Reporting Tools 1. Using Running Totals 2. Creating Parameter Fields 3. Parameterized Record Selection 4. Creating Subreports 5. Report Alerts 6. Report Alert Functions Advanced Formula Creation 1. Evaluation Time Functions 2. Declaring Variables 3. Using and Displaying Variables 4. Using Array Values 5. Using “If… Then… Else…” Statements 6. Using the “Select/Case” Statement 7. Using “For” Loops 8. Using “Do… While” Loops 9. The IIF Function Advanced Reporting 1. Creating a Report Template 2. Exporting Report Results 3. Exporting as HTML 4. Setting Default Options 5. Setting Report Options Using Report Wizards 1. Using the Report Wizards 2. Report Wizard Types 3. Creating a Cross-Tab Report Advanced Database Concepts 1. Viewing the SQL Code 2. Using Table Aliases 3. Verifying the Database 4. Setting the Datasource Location 5. Mapping Fields
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 174
Get Book Here
Book Description
Complete classroom training manuals for Microsoft Access 2016. Three manuals (Introductory, Intermediate, Advanced) in one book. 174 pages and 105 individual topics. Includes practice exercises and keyboard shortcuts. You will learn all about relational databases, advanced queries, creating forms, reporting, macros and much more. Topics Covered: Getting Acquainted with Access 1. Creating a New Database 2. Overview of a Database 3. The Access Interface 4. Touch Mode 5. Viewing Database Objects in the Navigation Bar 6. Opening and Closing Databases Creating Relational Database Tables 1. The "Flat File" Method of Data Storage 2. The Relational Model of Data Storage 3. Tips for Creating a Relational Database 4. Creating Relational Database Tables 5. Assigning a Primary Key to a Table Using Tables 1. Using Datasheet View 2. Navigating in Datasheet View 3. Adding Records in Database View 4. Editing and Deleting Records in Datasheet View 5. Inserting New Fields 6. Renaming Fields 7. Deleting Fields Field Properties 1. Setting Field Properties 2. The 'Field Size' Property 3. The 'Format' Property for Date/Time Fields 4. The 'Format' Property for Logical Fields 5. Setting Default Values for Fields 6. Setting Input Masks 7. Setting Up Validation Rules and Responses 8. Requiring Field Input 9. Allowing Zero Length Entries Joining Tables in a Database 1. The Relationships Window 2. Enforcing Referential Integrity 3. Creating Lookup Fields Indexing Tables 1. Indexes 2. Creating Indexes 3. Deleting Indexes Queries 1. Using the Simple Query Wizard 2. Designing Queries 3. Joining Tables in a Query 4. Adding Criteria to the QBE Grid 5. Running A Query 6. How is Using the QBE Grid Writing SQL Code? 7. Sorting Query Results 8. Hiding Fields in a Query 9. Using Comparison Operators 10. Using 'AND' and 'OR' Conditions Advanced Queries 1. Using the 'BETWEEN...AND' Condition 2. Using Wildcard Characters in Criteria 3. Creating a Calculated Field 4. Creating 'Top Value' Queries 5. Function Queries 6. Parameter Queries Advanced Query Types 1. Make-Table Queries 2. Update Queries 3. Append Queries 4. Delete Queries 5. Crosstab Queries 6. The 'Find Duplicates' Query 7. The 'Find Unmatched' Query Creating Forms 1. Forms Overview 2. The Form Wizard 3. Creating AutoForms 4. Using Forms 5. Form and Report Layout View 6. Form and Report Design View 7. Viewing the Ruler and Gridlines 8. The 'Snap to Grid' Feature 9. Creating a Form in Design View 10. Modifying Form Selections in Design View Form & Report Controls 1. Selecting Controls 2. Deleting Controls 3. Moving and Resizing Controls 4. Sizing Controls 'To Fit' 5. 'Nudging' Controls 6. Aligning, Spacing and Sizing Controls 7. Formatting Controls 8. Viewing Control Properties Using Controls 1. The Controls Group 2. Adding Label Controls 3. Adding Logos and Image Controls 4. Adding Line and Rectangle Controls 5. Adding Combo Box Controls 6. Adding List Box Controls 7. Setting Tab Order Subforms 1. Creating Subforms 2. Using the Subform/Subreport Control Reports 1. Using the Report Wizard 2. Using Basic Reports 3. Creating a Report in Design View 4. Sorting and Grouping Data in Reports 5. Creating Calculated Fields Subreports 1. Creating Subreports Charting Data 1. Using Charts Macros 1. Creating a Standalone Macro 2. Assigning Macros to a Command Button 3. Using Program Flow with Macros 4. Creating Autoexec Macros 5. Creating Data Macros 6. Editing Named Data Macros 7. Renaming and Deleting Named Data Macros Switchboard and Navigation Forms 1. Creating a Switchboard Form 2. Creating a Navigation Form 3. Controlling Startup Behavior Advanced Features 1. Getting External Data 2. Exporting Data 3. Setting a Database Password Helping Yourself 1. Using Access Help 2 The Tell Me Bar- 2016 Only
Author: Ryan Stephens
Publisher: Sams Publishing
ISBN: 0132715120
Category : Computers
Languages : en
Pages : 540
Get Book Here
Book Description
In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up. Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL. Step-by-step instructions carefully walk you through the most common SQL tasks. Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge. Notes and Tips point out shortcuts and solutions. New terms are clearly defined and explained. Learn how to... Use SQL-2003, the latest standard for the Structured Query Language Design and deploy efficient, secure databases Build advanced queries for information retrieval Sort, group, and summarize information for best presentation Tune databases and queries for maximum performance Understand database administration and security techniques For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems. Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University–Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems. Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles. Category: Database Covers: ANSI SQL User Level: Beginning–Intermediate Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections as they become available.
Author: Graeme Simsion
Publisher: Elsevier
ISBN: 0080488676
Category : Computers
Languages : en
Pages : 561
Get Book Here
Book Description
Data Modeling Essentials, Third Edition, covers the basics of data modeling while focusing on developing a facility in techniques, rather than a simple familiarization with "the rules". In order to enable students to apply the basics of data modeling to real models, the book addresses the realities of developing systems in real-world situations by assessing the merits of a variety of possible solutions as well as using language and diagramming methods that represent industry practice. This revised edition has been given significantly expanded coverage and reorganized for greater reader comprehension even as it retains its distinctive hallmarks of readability and usefulness. Beginning with the basics, the book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management. It includes an entirely new section discussing the development of logical and physical modeling, along with new material describing a powerful technique for model verification. It also provides an excellent resource for additional lectures and exercises. This text is the ideal reference for data modelers, data architects, database designers, DBAs, and systems analysts, as well as undergraduate and graduate-level students looking for a real-world perspective. - Thorough coverage of the fundamentals and relevant theory - Recognition and support for the creative side of the process - Expanded coverage of applied data modeling includes new chapters on logical and physical database design - New material describing a powerful technique for model verification - Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 189
Get Book Here
Book Description
Complete classroom training manual for Microsoft Access 2019 and 365. Includes 189 pages and 108 individual topics. Includes practice exercises and keyboard shortcuts. You will learn about creating relational databases from scratch, using fields, field properties, joining and indexing tables, queries, forms, controls, subforms, reports, charting, macros, switchboard and navigation forms, and much more. Topics Covered: Getting Acquainted with Access 1. Creating a New Database 2. Overview of a Database 3. The Access Interface 4. Touch Mode 5. Viewing Database Objects in the Navigation Bar 6. Opening and Closing Databases Creating Relational Database Tables 1. The Flat-File Method of Data Storage 2. The Relational Model of Data Storage 3. Tips for Creating a Relational Database 4. Creating Relational Database Tables 5. Assigning a Primary Key to a Table Using Tables 1. Using Datasheet View 2. Navigating in Datasheet View 3. Adding Records in Database View 4. Editing and Deleting Records in Datasheet View 5. Inserting New Fields 6. Renaming Fields 7. Deleting Fields Field Properties 1. Setting Field Properties 2. The Field Size Property 3. The Format Property for Date/Time Fields 4. The Format Property for Logical Fields 5. Setting Default Values for Fields 6. Setting Input Masks 7. Setting Up Validation Rules and Responses 8. Requiring Field Input 9. Allowing Zero Length Entries Joining Tables 1. The Relationships Window 2. Enforcing Referential Integrity 3. Creating Lookup Fields Indexing Tables 1. Indexes 2. Creating Indexes 3. Deleting Indexes Queries 1. Using the Simple Query Wizard 2. Designing Queries 3. Joining Tables in a Query 4. Adding Criteria to the QBE Grid 5. Running a Query 6. SQL View 7. Sorting Query Results 8. Hiding Fields in a Result Set 9. Using Comparison Operators 10. Using AND and OR Conditions Advanced Queries 1. Using the Between… And Condition 2. Using Wildcard Characters in Queries 3. Creating a Calculated Field 4. Creating Top Value Queries 5. Aggregate Function Queries 6. Parameter Queries Advanced Query Types 1. Make Table Queries 2. Update Queries 3. Append Queries 4. Delete Queries 5. Crosstab Queries 6. The Find Duplicates Query 7. Removing Duplicate Records from a Table 8. The Find Unmatched Query Creating Forms 1. Forms Overview 2. The Form Wizard 3. Creating Forms 4. Using Forms 5. Form and Report Layout View 6. Form and Report Design View 7. Viewing the Ruler and Grid 8. The Snap to Grid Feature 9. Creating a Form in Design View 10. Modifying Form Sections in Design View Form & Report Controls 1. Selecting Controls 2. Deleting Controls 3. Moving and Resizing Controls 4. Sizing Controls to Fit 5. Nudging Controls 6. Aligning, Spacing, and Sizing Controls 7. Formatting Controls 8. Viewing Control Properties Using Controls 1. The Controls List 2. Adding Label Controls 3. Adding Logos and Image Controls 4. Adding Line and Rectangle Controls 5. Adding Combo Box Controls 6. Adding List Box Controls 7. Setting Tab Order Subforms 1. Creating Subforms 2. Using the Subform or Subreport Control Reports 1. Using the Report Wizard 2. Creating Basic Reports 3. Creating a Report in Design View 4. Sorting and Grouping Data in Reports 5. Creating Calculated Fields Subreports 1. Creating Subreports Charting Data 1. Using Charts 2. Insert a Modern Chart Macros 1. Creating a Standalone Macro 2. Assigning Macros to a Command Button 3. Assigning Macros to Events 4. Using Program Flow with Macros 5. Creating Autoexec Macros 6. Creating Data Macros 7. Editing Named Data Macros 8. Renaming and Deleting Named Data Macros Switchboard and Navigation Forms 1. Creating a Switchboard Form 2. Creating a Navigation Form 3. Controlling Startup Behavior Advanced Features 1. Getting External Data 2. Exporting Data 3. Setting a Database Password Helping Yourself 1. Using Access Help 2. The Tell Me Bar
Author: Joe Celko
Publisher: Morgan Kaufmann
ISBN: 008055752X
Category : Computers
Languages : en
Pages : 383
Get Book Here
Book Description
Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you'll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you'll be coding more quickly, writing more efficient code, and applying the full power of SQL - Filled with the insights of one of the world's leading SQL authorities - noted for his knowledge and his ability to teach what he knows - Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance) - Presents clear guidance for selecting and correctly applying the right table technique
Author: Cecelia L. Allison
Publisher: AuthorHouse
ISBN: 1410729737
Category : Computers
Languages : en
Pages : 216
Get Book Here
Book Description
SQL Simplified: Learn To Read and Write Structured Query Language focuses extensively on the implementation of Structured Query Language (SQL) rather than on database design or on the Database Management Systems (DBMSs) that implement SQL, like many SQL books. The easy to follow step-by-step chapters of this book will provide beginners with the practice necessary to develop the skills and knowledge required to program in SQL with ease. The concepts of SQL are simplified enabling anyone to quickly grasp the fundamentals of SQL. Each chapter introduces a new concept and includes examples, key notes and important key terms. This book also highlights many key differences in SQL script used in a number of different database management system platforms. Your comprehension of each chapter is tested through the use of quizzes and assignments. After completion of this book, you should feel confident using SQL in any relational database environment.
Author: Code Quickly
Publisher: Drip Digital
ISBN: 9781951791780
Category :
Languages : en
Pages : 194
Get Book Here
Book Description
You don't have to go back to school in order to get ahead in today's world... Do you have a burning desire to expand your skillset but don't have the time or care to go back to studying for the next 4+ years? Do you feel as if you are capable of so much more, and that you should be making a bigger contribution to the world? Are you ready to learn one of the most in-demand skills of the 21st century and set yourself up for outstanding success in your career -- success that will not only benefit you, but thousands, perhaps millions, of other people as well? Or, maybe you've already landed your dream job and now your boss needs you to fulfill the role as quickly as possible. Whatever the case may be, learning the ins and outs of the coding universe doesn't have to be some kind of big and complex ordeal. The internet might be abuzz with all kinds of confusing tutorials and partial playbooks making it seem like learning to code is harder than it really is, but rest assured, this is not true. Did you know that the average individual spends $20,000 on a course that is sometimes up to 24 weeks long just to learn the basics of coding? But this doesn't have to be you. No matter where you are in the coding journey, you can take the information provided and begin to apply it today. You can learn to code in the time it takes to read a book and skip all of the unnecessary schoolings, even if you've never coded anything before.
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 177
Get Book Here
Book Description
Complete classroom training manual for Microsoft Outlook 2019. 177 pages and 101 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create and manage contacts, use advanced email techniques, manage and use the calendar, use tasks, create groups, use the journal, and much more. Topics Covered: CHAPTER 1- GETTING ACQUAINTED WITH OUTLOOK 1.1- The Outlook Environment 1.2- The Title Bar 1.3- The Ribbon 1.4- The Quick Access Toolbar 1.5- Touch Mode 1.6- The Navigation Bar, Folder Pane, Reading Pane, and To-Do Bar CHAPTER 2- MAKING CONTACTS 2.1- The Contacts Folder 2.2- Customizing the Contacts Folder View 2.3- Creating Contacts 2.4- Basic Contact Management 2.5- Printing Contacts 2.6- Creating Contact Groups 2.7- Categorizing Contacts 2.8- Searching for Contacts 2.9- Calling Contacts 2.10- Mapping a Contact’s Address CHAPTER 3- EMAIL 3.1- Using the Inbox 3.2- Changing the Inbox View 3.3- Message Flags 3.4- Searching for Messages 3.5- Creating, Addressing, and Sending Messages 3.6- Checking Message Spelling 3.7- Setting Message Options 3.8- Formatting Messages 3.9- Using Signatures 3.10- Replying to Messages 3.11- Forwarding Messages 3.12- Sending Attachments 3.13- Opening Attachments 3.14- Ignoring Conversations CHAPTER 4- THE SENT ITEMS FOLDER 4.1- The Sent Items Folder 4.2- Resending Messages 4.3- Recalling Messages CHAPTER 5- The Outbox Folder 5.1- Using the Outbox 5.2- Using the Drafts Folder CHAPTER 6- USING THE CALENDAR 6.1- The Calendar Window 6.2- Switching the Calendar View 6.3- Navigating the Calendar 6.4- Appointments, Meetings, and Events 6.5- Manipulating Calendar Objects 6.6- Setting an Appointment 6.7- Scheduling a Meeting 6.8- Checking Meeting Attendance Status 6.9- Responding to Meeting Requests 6.10- Scheduling an Event 6.11- Setting Recurrence 6.12- Printing the Calendar 6.13- Teams Meetings in Outlook 6.14- Meeting Notes CHAPTER 7- Tasks 7.1- Using Tasks 7.2- Printing Tasks 7.3- Creating a Task 7.4- Setting Task Recurrence 7.5- Creating a Task Request 7.6- Responding to Task Requests 7.7- Sending Status Reports 7.8- Deleting Tasks CHAPTER 8- Deleted Items 8.1- The Deleted Items Folder 8.2- Permanently Deleting Items 8.3- Recovering Deleted Items 8.4- Recovering and Purging Permanently Deleted Items CHAPTER 9- GROUPS 9.1- Accessing Groups 9.2- Creating a New Group 9.3- Adding Members to Groups and Inviting Others 9.4- Contributing to Groups 9.5- Managing Files in Groups 9.6- Accessing the Group Calendar and Notebook 9.7- Following and Stop Following Groups 9.8- Leaving Groups 9.9- Editing, Managing and Deleting Groups CHAPTER 10- The Journal Folder 10.1- The Journal Folder 10.2- Switching the Journal View 10.3- Recording Journal Items 10.4- Opening Journal Entries and Documents 10.5- Deleting Journal Items CHAPTER 11- Public Folders 11.1- Creating Public Folders 11.2- Setting Permissions 11.3- Folder Rules 11.4- Copying Public Folders CHAPTER 12- Personal & Private Folders 12.1- Creating a Personal Folder 12.2- Setting AutoArchiving for Folders 12.3- Creating Private Folders 12.4- Creating Search Folders 12.5- One-Click Archiving CHAPTER 13- Notes 13.1- Creating and Using Notes CHAPTER 14- Advanced Mailbox Options 14.1- Creating Mailbox Rules 14.2- Creating Custom Mailbox Views 14.3- Handling Junk Mail 14.4- Color Categorizing 14.5- Advanced Find 14.6- Mailbox Cleanup CHAPTER 15- OUTLOOK OPTIONS 15.1- Using Shortcuts 15.2- Adding Additional Profiles 15.3- Adding Accounts 15.4- Outlook Options 15.5- Using Outlook Help CHAPTER 16- DELEGATES 16.1- Creating a Delegate 16.2- Acting as a Delegate 16.3- Deleting Delegates CHAPTER 17- SECURITY 17.1- Types of Email Encryption in Outlook 17.2- Sending Encrypted Email
