|
Provided by: 123-CBT Computer Based Training Access XP Proficient User |
 |
Course Overview
This courses covers more advanced features of Access 2002. Individuals will learn how to make different types of data queries, work with forms and link data to other databases.
Learn To
• Create a single-table query in Design view.
• Create a multiple-table query in Design view.
• Create a simple query by using the Simple Query Wizard.
• Identify features of the Form Wizard.
• Identify features of the AutoForm Wizard.
• Add a record to a form.
• Identify features of the Report Wizard.
• Print a report from Print Preview.
• Add a control label to a report.
• Identify options of the Import Spreadsheet Wizard that are used to import an Excel worksheet to a data access page.
• Link an existing Microsoft Access table to a database.
• Publish a table to Microsoft Excel.
Audience
The intended audience for this course are 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
74051 Objectives
Unit 1: Querying Data
1 - 2 hours
• Create a single-table query in Design view.
• Create a multiple-table query in Design view.
• Create a simple query by using the Simple Query Wizard.
• Match query wizards with their functions.
• Identify the effects of opening queries.
• Sort a query by output.
• Apply a criterion to a query.
• Apply an aggregate tool to a query.
• Add a table to a query.
• Add a calculated field to a query.
• Match the field properties with their features.
Unit 2: Forms Introduction
1 - 2 hours
• Identify features of the Form Wizard.
• Identify features of the AutoForm Wizard.
• Add a record to a form.
• Insert a picture into a field.
• Add an unbound control image to a form.
• Identify featu
|
|
||||||||||
