Access 2002 (Office XP): Level 3
In this course, you’ll explore a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate forms. In addition, you’ll gain experience working with various Microsoft Access tools, such as securing a database, using the Database Splitter, replicating a database, and creating MDE files.
| Lesson 1: Advanced Query Techniques | |
| Joining Tables and Working with Join Properties | |
| Creating Crosstab Queries | |
| Creating Parameter Queries | |
| Creating Action Queries | |
| Lesson 2: Using Advanced Form Techniques | |
| Organizing Field Placement | |
| Using a Form as the User Interface | |
| Using the Switchboard Manager | |
| Creating a Form that Contains a Subform | |
| Creating a Form in Design View | |
| Lesson 3: Creating Basic Macros to Automate Forms | |
| Macro Basics | |
| Attaching a Macro to a Command Button | |
| Lesson 4: Using Macros to Provide User Interaction and Automate Tasks | |
| Using a Macro to Provide User Interaction | |
| Using a Macro to Automate Data Entry | |
| Lesson 5: Enhancing Reports | |
| Working with Subreports | |
| Lesson 6: Using Access Tools | |
| Steps to Securing a Database | |
| Replicating a Database | |
| Importing and Exporting XML Documents | |
| Lesson 7: Creating Database Applications | |
| Creating Event Procedures | |
| Using the Database Splitter | |
| Creating MDE Files | |