Access 2016: Up To Speed

Understanding Databases
Using Database Templates
The Access Environment
A Look at Tables, Forms, Queries and Reports
Creating a Blank Database
Setting Access Options
Creating a Table using Application Parts
Entering Data into a Table
Adding New Fields to a Table
Creating a Table from Scratch
Setting a Primary Key
Rearranging, Inserting and Deleting Fields
Changing Field Properties
Designing in Datasheet View
Setting Validation Rules
Formatting Fields
Indexing Fields
Requiring Data Entry
Creating an Input Mask
Creating a Lookup Field
Creating & Modifying a Value List
Creating Calculated Fields
Creating Multiple Primary Keys
Creating Multiple Field Values
Editing & Formatting Table Data
Importing Excel Data into an Existing Table
Importing a Text File into a New Table
Selecting, Sorting and Deleting Records
Finding and Replacing Data
Filtering Data by Selection & Form
Using Common Filters
Hiding/Unhiding Columns
Freezing & Rearranging Columns
Creating a Query in Design View
Adding Criteria to a Query
Sorting Data in a Query
Using the Query Wizard
Creating Multi-Table Queries
Using Calculations in Queries
Changing Query Properties
Creating a Totals Query
Creating a Parameter Query
Prompting for Dates
Creating a Find Duplicates Query
Creating a Find Unmatched Records Query
Using the Form Wizard
Adding a Field to a Form
Changing Control Properties
Using Layout View
Adding Controls to a Form
Moving and Sizing Controls
Creating a Calculated Control
Changing Control Properties
Changing Form Properties
Adding a Lookup Control
Adding a Subform using the Subform/Subreport Tool
Aligning Controls to Each Other
Creating an Option Group
Creating a Basic Report
Applying a Theme to a Report
Using the Report Wizard
Modifying Report Setup
Printing Reports
Using the Label Wizard
Working with Report Sections
Adding Controls to a Report
Changing a Control’s Data Source
Changing a Report’s Data Source
Sorting and Grouping Data
Applying Conditional Formatting
Edit Sorting and Grouping Levels in a Report
A Look at Database Relationships
Creating a One-to-One Relationship
Creating a One-to-Many Relationship
Creating a Many-to-Many Relationship
Enforcing Referential Integrity
Cascade Update Related Fields
Cascade Delete Related Records
Creating a Macro
Running a Macro Step-by-Step
Assigning a Macro to a Command Button
Creating & Using a Macro Group
Using Macro Conditions
The AutoExec Macro
Creating an AutoKeys Macro
About Action Queries
Creating a Make-Table Query
Creating an Append Query
Creating an Update Query
Creating a Delete Query
Creating a SQL Query
Importing Data from a Text File
Importing Data from Excel
Importing Data from another Access Database
Linking Data
Exporting Data to Other Formats
Exporting Data to a PDF File
Exporting Data to another Access Database
Exporting Data to Excel
Exporting Data to Microsoft Word
Exporting Data to a Microsoft Word Mail Merge
Creating & Modifying a Switchboard
Using Compact and Repair
Changing Database Properties
Documenting a Database
Analyzing a Database
Viewing Object Dependencies
Backing up a Database
Splitting a Database
Setting a Database Password
….and more