|
|
| Course Description | ||
| Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar. | ||
| Course Content | Prerequisites |
|
| Lesson 1: Parameter and Action Queries Creating Parameter Queries Creating Action Queries Lesson 2: Query Joins and Crosstab Queries Joining Tables and Working with Join Properties Creating Crosstab Queries Editing Limitations in Query Datasheets Lesson 3: Using Advanced Form Techniques Organizing Field Placement Using Functions to Control Data Entry Adding an Option Group to a Form Using a Form as the User Interface Creating a Form that Contains a Subform Lesson 4: Creating Basic Macros to Automate Forms Macro Basics Attaching a Macro to a Command Button Revising a Macro Lesson 5: Using Macros to Provide User Interaction and Automate Tasks Using a Macro to Provide User Interaction Using a Macro to Automate Tasks AutoKeys and AutoExec Macros Lesson 6: Using Advanced Report Techniques Customizing the Appearance and Functionality of a Report Lesson 7: Web Capabilities and Data Integration Using Hyperlinks Data Integration |
Access Level 2 | |
| or equivalent knowledge. | ||
| Course Duration | ||
| 7.5 hours | ||
| Study Methods Available | ||
| aIndividual Tuition | ||
| aGroup Training | ||
| x Distance Learning | ||
| Follow-on Courses | ||
| Access Level 4 | ||
| All Courses | ||
| Click here to see all our courses | ||
