What you'll learn:
- Understand the basics of Access tables, queries, forms and reports
- Learn how to find, filter, and sort database information
- Plan and create databases, with tables and different types of fields
- Gain an understanding of basic database principles
- Learn how to create a relational database with multiple tables
- Create powerful queries to find, update, append, and delete record
- Add professional forms and reports to your database
- Analyze and summarize database information with queries and report
![]() |
Copy these free tutorials to use in your own lesson plans: | |
Access Fundamentals | ||
Understand the Screen |
Copy Link | |
Open and Save a Database |
Copy Link | |
Work with Database Objects |
Copy Link | |
Tour of Tables |
Copy Link | |
Tour of Queries |
Copy Link | |
Tour of Forms |
Copy Link | |
Tour of Reports |
Copy Link | |
Help |
Copy Link | |
Close and Exit Access |
Copy Link | |
Create and Work with a Database | ||
Plan a Database |
Copy Link | |
Create a Database |
Copy Link | |
Add, Edit, and Delete Records |
Copy Link | |
Select Data |
Copy Link | |
Cut, Copy, and Paste Data |
Copy Link | |
Use Undo and Redo |
Copy Link | |
Check Spelling |
Copy Link | |
Use the Zoom Box |
Copy Link | |
Preview and Print |
Copy Link | |
Find, Filter, and Format Data | ||
Find and Replace Data |
Copy Link | |
Sort Records |
Copy Link | |
Use Common Filters |
Copy Link | |
Filter by Selection |
Copy Link | |
Filter by Form |
Copy Link | |
Create an Advanced Filter |
Copy Link | |
Adjust Rows and Columns |
Copy Link | |
Change Gridlines and Cell Effects |
Copy Link | |
Freeze a Column |
Copy Link | |
Hide a Column |
Copy Link | |
Tables | ||
Create a Table |
Copy Link | |
Understand Field Types and Properties |
Copy Link | |
Index a Field |
Copy Link | |
Add a Primary Key and Auto-Increment Fields |
Copy Link | |
Insert, Reorder, and Delete Fields |
Copy Link | |
Add Field Descriptions and Captions |
Copy Link | |
Change the Field Size |
Copy Link | |
Format Number, Currency, and Date/Time Fields |
Copy Link | |
Format Text Fields |
Copy Link | |
Set a Default Value |
Copy Link | |
Require Data Entry |
Copy Link | |
Validate Data |
Copy Link | |
Create an Input Mask |
Copy Link | |
Create a Lookup Field |
Copy Link | |
Create a Value List |
Copy Link | |
Modify a Lookup List |
Copy Link | |
Add Total Rows |
Copy Link | |
Create Relational Databases | ||
Table Relationships and Relationship Types |
Copy Link | |
Create Relationships Between Tables |
Copy Link | |
Enforce Referential Integrity |
Copy Link | |
Print and Delete Relationships |
Copy Link | |
Work with Queries | ||
Create a Query |
Copy Link | |
Hide, Remove, and Sort Fields |
Copy Link | |
Use AND and OR Operators in a Query |
Copy Link | |
Create a Multiple Table Query |
Copy Link | |
Create a Calculated Field |
Copy Link | |
Work with Expressions and the Expression Builder |
Copy Link | |
Format Fields within Queries |
Copy Link | |
Use an IIF Function |
Copy Link | |
Summarize Groups of Records |
Copy Link | |
Display Top or Bottom Values |
Copy Link | |
Parameter Queries |
Copy Link | |
Find Duplicate Records |
Copy Link | |
Find Unmatched Records |
Copy Link | |
Crosstab Queries |
Copy Link | |
Delete Queries |
Copy Link | |
Append Queries |
Copy Link | |
Make-Table Queries |
Copy Link | |
Update Queries |
Copy Link | |
Work with Forms | ||
Create a Form with the Form Wizard |
Copy Link | |
Create and Use a Form |
Copy Link | |
Modify a Form in Layout View |
Copy Link | |
Form Design View Basics |
Copy Link | |
Change the Tab Order |
Copy Link | |
Work with Control Properties |
Copy Link | |
Work with Form Properties |
Copy Link | |
Change a Controls Data Source |
Copy Link | |
Create a Calculated Control |
Copy Link | |
Change a Controls Default Value |
Copy Link | |
Create a Subform |
Copy Link | |
Work with and Modify Subforms |
Copy Link | |
Create and Modify a Navigation Form |
Copy Link | |
Work with Reports | ||
Create a Report |
Copy Link | |
Use the Report Wizard |
Copy Link | |
Use the Label Wizard |
Copy Link | |
Work in Layout View |
Copy Link | |
Format Fonts |
Copy Link | |
Copy Formatting |
Copy Link | |
Change Text Alignment |
Copy Link | |
Insert a Logo and Background Image |
Copy Link | |
Adjust Page Margin and Orientation |
Copy Link | |
Add Page Numbers and Dates |
Copy Link | |
Group and Sort |
Copy Link | |
Summarize Data using Totals |
Copy Link | |
Understand Report Sections |
Copy Link | |
Advanced Topics | ||
Use Conditional Formatting |
Copy Link | |
Work with Number Formatting |
Copy Link | |
Use Themes |
Copy Link | |
Import Information |
Copy Link | |
Export Information |
Copy Link | |
Link External Information |
Copy Link | |
Mail Merge Records to Word |
Copy Link | |
Use Hyperlink Fields |
Copy Link | |
Database Object Dependencies |
Copy Link | |
Compact and Repair a Database |
Copy Link | |
Convert an Access Database |
Copy Link | |
Back Up and Restore a Database |
Copy Link | |
Password Protect a Database |
Copy Link | |
Split a Database |
Copy Link |