| 1. | About this Course |
Welcome Introduction and objectives Getting help with the course How the course is structured About the model database About the exercises Database naming conventions |
2. | Creating Relational Databases |
Objectives Overview Designing a relational database Understanding relationships Creating a One-to-Many relationship Enforcing referential integrity Creating a Many-to-Many relationship Creating a One-to-One relationship Editing a relationship Deleting a relationship Printing the relationship layout Troubleshooting common mistakes Exercise Review questions Summary |
| 3. | Creating Advanced Queries |
Objectives Overview Understanding query types Adding filters to queries Filtering by Form Creating multiple-table queries Manually joining tables Creating totals in queries Creating calculated fields Displaying top and bottom values Using the Expression Builder Using the IIF function Creating Parameter queries Creating Crosstab queries Finding duplicate records Finding unmatched records Creating tables with queries Deleting records with queries Appending records to tables Updating records with queries Exercise Review questions Summary |
4. | Creating Advanced Forms |
Objectives Overview Understanding controls Changing form properties Creating combo boxes Limiting combo box choices Amending column widths Creating command buttons Using command buttons to link forms Changing a control's data source Creating calculations in forms Creating One-to-Many sub-forms Modifying sub-forms Using sub-forms Creating Many-to-Many sub-forms Creating One-to-One sub-forms Exercise Review questions Summary |
| 5. | Creating Advanced Reports |
Objectives Overview Sorting and grouping records Creating and using calculations Creating multiple-table reports Creating charts on reports Exercise Review questions Summary |
6. | Advanced Formatting |
Objectives Overview Adjusting lines in forms and reports Adjusting section properties Formatting control properties Inserting pictures on forms and reports Adding pictures to the background Adding picture fields to tables Exercise Review questions Summary |
| 7. | Working with Macros |
Objectives Overview Creating a macro Running a macro Editing a macro Attaching a macro to a button Attaching a macro to keystrokes Making macro actions conditional Exercise Review questions Summary |
8. | Using Access with Other Programs |
Objectives Overview Importing information from text files Importing information from Access Importing information from Excel Linking information to Excel Exporting information to text files Exporting information to Access Exporting information to Excel Analysing information in Excel Exporting information to Word Mail merging with Word Exercise Review questions Summary |
| 9. | Working with the Internet |
Objectives Overview Introducing Internet options Creating and using hyperlinks Publishing to the Web Creating data access pages Previewing data access pages Using data access pages Changing data access page design Creating PivotTables on pages Exercise Review questions Summary |
10. | Managing Your Databases |
Objectives Overview Converting Access databases Backing up and restoring databases Compacting and repairing databases Setting and deleting a password Exercise Review questions Summary |
| 11. | Module Summary |
Congratulations Your quiz score Good luck |
|||
