Access Fundamentals |
Understand the Screen |
Open and Save a Database |
Work with Database Objects |
Tour of Tables |
Tour of Queries |
Tour of Forms |
Tour of Reports |
Help |
Close and Exit Access |
Create and Work with a Database |
Plan a Database |
Create a Database |
Add, Edit, and Delete Records |
Select Data |
Cut, Copy, and Paste Data |
Use Undo and Redo |
Check Spelling |
Use the Zoom Box |
Preview and Print |
Find, Filter, and Format Data |
Find and Replace Data |
Sort Records |
Use Common Filters |
Filter by Selection |
Filter by Form |
Create an Advanced Filter |
Adjust Rows and Columns |
Change Gridlines and Cell Effects |
Freeze a Column |
Hide a Column |
Tables |
Create a Table |
Understand Field Types and Properties |
Index a Field |
Add a Primary Key and Auto-Increment Fields |
Insert, Reorder, and Delete Fields |
Add Field Descriptions and Captions |
Change the Field Size |
Format Number, Currency, and Date/Time Fields |
Format Text Fields |
Set a Default Value |
Require Data Entry |
Validate Data |
Create an Input Mask |
Create a Lookup Field |
Create a Value List |
Modify a Lookup List |
Add Total Rows |
Create Relational Databases |
Table Relationships and Relationship Types |
Create Relationships Between Tables |
Enforce Referential Integrity |
Print and Delete Relationships |
Work with Queries |
Create a Query |
Hide, Remove, and Sort Fields |
Use AND and OR Operators in a Query |
Create a Multiple Table Query |
Create a Calculated Field |
Work with Expressions and the Expression Builder |
Format Fields within Queries |
Use an IIF Function |
Summarize Groups of Records |
Display Top or Bottom Values |
Parameter Queries |
Find Duplicate Records |
Find Unmatched Records |
Crosstab Queries |
Delete Queries |
Append Queries |
Make-Table Queries |
Update Queries |
Work with Forms |
Create a Form with the Form Wizard |
Create and Use a Form |
Modify a Form in Layout View |
Form Design View Basics |
Change the Tab Order |
Work with Control Properties |
Work with Form Properties |
Change a Controls Data Source |
Create a Calculated Control |
Change a Controls Default Value |
Create a Subform |
Work with and Modify Subforms |
Create and Modify a Navigation Form |
Work with Reports |
Create a Report |
Use the Report Wizard |
Use the Label Wizard |
Work in Layout View |
Format Fonts |
Copy Formatting |
Change Text Alignment |
Insert a Logo and Background Image |
Adjust Page Margin and Orientation |
Add Page Numbers and Dates |
Group and Sort |
Summarize Data using Totals |
Understand Report Sections |
Advanced Topics |
Use Conditional Formatting |
Work with Number Formatting |
Use Themes |
Import Information |
Export Information |
Link External Information |
Mail Merge Records to Word |
Use Hyperlink Fields |
Database Object Dependencies |
Compact and Repair a Database |
Convert an Access Database |
Back Up and Restore a Database |
Password Protect a Database |
Split a Database |