|
Module One: Getting Started |
 |
Icebreaker |
 |
Housekeeping items |
 |
Pre-Assignment Review |
 |
Workshop objectives |
 |
Action plans and evaluation forms |
|
|
|
|
|
Module Two: Getting Started With Access |
 |
Common Database Terms |
 |
Opening Access |
 |
Understanding the Getting Started Window |
 |
Creating a Blank Access Database |
 |
Creating a Database from a Template |
|
|
|
|
|
Module Three: Using the Access Interface |
 |
Understanding Security Warnings |
 |
Interface Overview |
 |
Overview of the Ribbon Interface |
 |
Working with the Backstage View |
 |
Using the Navigation Pane |
|
|
|
|
|
Module Four: Working with Database Objects |
 |
Viewing Database Objects |
 |
Exporting an Object |
 |
Renaming an Object |
 |
Sorting and Filtering Your View |
 |
Understanding Application Parts |
|
|
|
|
|
Module Five: Creating Tables |
 |
Creating a Blank Table in Datasheet View |
 |
Creating a Blank Table in Design View |
 |
Creating a Table from a Template |
 |
Adding a Table from a SharePoint List |
 |
Key Features on the Table Tools Tabs |
|
|
|
|
|
Module Six: Working with Tables |
 |
Adding Information to a Table |
 |
Editing Records |
 |
Deleting Records |
 |
Searching for Records |
|
|
|
|
|
Module Seven: Creating Forms |
 |
Types of Controls |
 |
Creating a Navigation Form |
 |
Creating a Form with the Wizard |
 |
Creating a Form in Layout View |
 |
Modifying Your Form in Design View |
 |
Key Features on the Form Tools Tabs |
|
|
|
|
|
Module Eight: Working with Forms |
 |
Common Formatting Tasks |
 |
Using Themes |
 |
Adding Controls |
 |
Moving Controls |
 |
Deleting Controls |
|
|
|
|
|
Module Nine: Creating Reports |
 |
Using the Report Wizard |
 |
Using Design View |
 |
Adding a Logo |
 |
Working with Controls |
 |
Key Features on the Report Tools Tabs |
|
|
|
|
|
Module Ten: Creating Queries |
 |
Types of Queries |
 |
Creating a Query with the Wizard |
 |
Executing a Query |
 |
Viewing the Query |
 |
Key Features on the Query Tools Tabs |
|
|
|
|
|
Module Eleven: Managing Your Database |
 |
Using Alternate File Formats |
 |
Printing an Object |
 |
Backing up Your Database |
 |
E-mailing your Database |
|
|
|
|
|
Module Twelve: Wrapping Up |
 |
Words from the Wise |
 |
Parking Lot |
 |
Action Plans and Evaluations |