|
Provided by: 123-CBT Computer Based Training Access XP Expert User |
 |
Course Overview
This course covers the more complex aspects of working with data using Access 2002. Assuming the learner is already proficient in Access, the course covers advanced features of database queries, and enhancing forms and reports.
Learn To
• Create an update query.
• Create a delete query.
• Create an append query.
• Create a form in Design view.
• Modify section properties in a form.
• Create a subform with the Form Wizard.
• Create a report in Design view.
• Modify section properties of a report.
• Add a chart to a report.
• Modify a database by using the Compact and Repair tool.
• Convert a database from a previous version to Access 2002 format.
• Distribute a database as an MDE file.
Audience
The intended audience for this course would include Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, and Database Administrators. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s).
Content Emphasis
Skills-Based
Deployment Options
Internet / Intranet, Download, LAN, Workstation
Accreditation
NASBA credits: 4 CPE Credits
Language Options
American English
Total Learning Time
6 to 8 hours
74052 Objectives
Unit 1: Advanced Queries
1 - 2 hours
• Create an update query.
• Create a delete query.
• Create an append query.
• Create a make-table query.
• Create a parameter query.
• Create a crosstab query.
• Create a union query.
• Filter records with a query by using the OR criteria condition.
• Filter records with a query by using the AND criteria condition.
• Create a criterion query by using a form control.
• Change a join type in a query.
Unit 2: Forms Enhancements
1 - 2 hours
• Create a form in Design view.
• Modify section properties in a form.
• Create a subform with the Form Wizard.
• Add a subform to an existing form.
• Create a switchboard form by using the Add-In tool.
• Identify database startup options for Microsoft Access 2002.
Unit 3: Report / Data Access Pa
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information
Training Presented in: English
|
|
||||||||||
