Microsoft Access 2000: Advanced
Microsoft Access 2000: Advanced covers more advanced Access topics including complex query techniques, table joins, and more efficient forms and reports,. In addition, it covers how macros can enhance you database and user input interfaces.
| Price |
$52 Nonmembers / $39 Members |
| Course Credits |
N/A |
| Prerequisites |
Access 2000: Level 2 or comparable experience |
| Required Software |
Shockwave 8.0.1 or higher |
| Optional Software |
None |
Additional Notes
Please note: If you do not currently have Shockwave 8.0.1 or higher on your system you will need to download it which you can do for free from the following site. If you are taking the course at your place of business, please check with your IT Department before downloading Shockwave.
This course has a preassessment that will help you identify those portions of the course on which you should focus your time. You may retake the preassessment when you finish the course. The score on most recent taking of the preassessment will be recorded in your transcript. There is narration supplied with the course if your computer has sound capabilities. However, the narration is not necessary to successfully complete the course.
Learning Objectives
After completing this course, students will be able to:
- Create parameter queries
- Create action queries
- Join tables and work with join properties
- Create cross-tab queries
- Use functions to control data entry
- Use a form as the user interface
- Create a form that contains a subform
- Create and use macros
- Attach a macro to a command button
- Use macros to provide user interaction and automate data entry
| 
