 |  |  |  |  |  |
| Course | Microsoft Access Introduction | |
| Duration | 2 Days | |
| Overview | This course is a very solid introduction to setting up and managing a database in Microsoft Access. Students wishing to attend this course should be comfortable with the windows environment. | |
| Content | Introducing Access | Database Concepts & Terms Plan & Design a Database Sample Applications |
| Tables | Using Tables, View Data, Add, Edit Data Find Records, Sort, Filter, View Related Data Create a Table, Data Types Name AutoCorrect, Field Properties Key Fields, Indexes Import Table from Excel Saving, Open, Print and Rename a Table |
|
| Queries | Quick Queries, View Data Create & Run Select Queries Parameter Queries, Calculations in Queries Summary Queries Save, Open, Print, Rename |
|
| Forms | Auto Forms, Create Forms Add & Edit Data, View Data Sort & Filter Records Customise Forms, Adding Combo Boxes Align, Size & Format Objects Save, Open, Print & Rename Forms |
|
| Reports Design | Quick Reports, Create Reports with Wizards Create Reports & Group Data Show Report Totals Edit Reports Add Headers, Footers, & Design Elements Save, Open, Print & Rename |
|
| Relationships | One to Many, One to One, Print Relationships Indexes and Referential Integrity |
|
| Database Utilities | Compact a Database Copying Objects |
|