Microsoft Access
| Course Level | Introduction | Intermediate |
| Duration | 1 Day | 1 Day |
| Course Reference | ACC E1 | ACC E2 |
| Subjects Covered |
Understand Databases Concepts Open & Close a Database File Database Objects Design & Plan a Database Work with Tables Create a Table Create Field Names & Setting Data Types Set the Primary Key Change the Table View Add & Delete Fields Open & Close a Table Set Table Field Properties Change the Field Size & Field Formats Use Default Values & Required Fields Use Indexes Use the Lookup Wizard Work with Filters & Queries Forms Use the Form Wizard View & Enter Data in Forms Edit & Delete Records Reports Use the Report Wizard Preview & Print a Report Manage Forms & Reports Basic Editing in Design View Sort & Find Database Record |
RECAP - Database Design Managing Table Relationships Creating & Editing Relationships Manually Creating a relationship Creating a relationship using a Lookup Table Creating a relationship using the Table Wizard Referential Integrity Relationship Types Deleting Relationships Creating Queries using Relational Databases Understanding & Creating Queries Specifying a Sort Order & Criteria Changing & Saving Queries Table Relationships in Queries Calculated Query Expressions Parameter Queries Form Design using Relational Databases Creating Forms using the Form Wizard Creating Forms using Design View Editing Forms in Design View Action Queries Mail Merging Data with Microsoft Word Exporting to Microsoft Excel Creating and Editing an Access Switchboard |
