Course DescriptionThis curriculum maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships, how to manipulate tables, and how to create simple and advanced queries. The curriculum teaches how to create forms and reports and how to format controls on both forms and reports, and the student is also introduced to importing and exporting data to and from Access.This curriculum consists of two Skill Builder courses:
75050 - Microsoft Access 2003 FundamentalsCourse Overview This course, along with course 75051, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships, how to manipulate tables, and how to create simple and advanced queries.Learn To
• To identify options in the New File task pane. 75051 - Microsoft Access 2003 Proficient UserCourse OverviewThis course, along with course 75050, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. Assuming knowledge of the fundamentals, it teaches how to create forms and reports and how to format controls on both forms and reports. The student is also introduced to importing and exporting data to and from Access. Finally, this course teaches about backing up and compacting and repairing databases. Learn To • To identify options in the Form Wizard. • To identify AutoForms in the New Form dialog box. • To identify elements of a PivotChart. • To identify options in the Report Wizard. • To identify options in the Page Wizard. • To set the sort order for a report. • To publish a table to Excel. • To identify options in the Import Spreadsheet Wizard. • To back up a database. Audience The target audience will range from new users to power users, although the vast majority will have had some exposure to previous versions of Access. Fundamental PC and Windows skills are assumed. Total Learning Time 3 to 4 hours Objectives Unit 1: Forms 1 - 1.5 hours • Identify options in the Form Wizard. • Identify AutoForms in the New Form dialog box. • Identify elements of a PivotChart. • Sort records in a form. • Identify options on the Formatting (Form/Report) toolbar. • Match form control properties with their functions. • Align a selection of form controls. • Space a selection of form controls vertically. • Add a section to a form by using the View menu. Unit 2: Reports and Data Access Pages 1 - 1.5 hours • Identify options in the Report Wizard. • Identify options in the Page Wizard. • Set the sort order for a report. • Identify options in the Page Setup dialog box for setting up a report. • Identify options on the Print Preview toolbar for previewing a report. • Identify options in the Print dialog box for printing a report. • Match report control properties with their functions. • Identify options for summarizing fields in a report control. • Identify methods of manipulating report controls. Unit 3: Database Integration and Tools 1 hour • Publish a table to Excel. • Identify options in the Import Spreadsheet Wizard. • Back up a database. • Compact and repair a database. • Identify features of object dependencies. • Identify options in the Documenter dialog box. Single User License: |
|
|
|
|
|
|
|
|
|
**Register Today and Save $$ with Planetlearn.com**
Prices are for single user. If you are looking for internet/intranet or LAN solutions and have specific training needs not listed, please call 207-671-1666 or E-Mail sales@planetlearn.com
Partner Sites
Planetlearn Order securely online or call 207-671-1666 |