Microsoft Access 2000 Curriculum CBT Training CDs

Rating:
Summary: Microsoft Access 2000 Curriculum CBT Training CDs
Review: Course Overview
The Microsoft Access 2000 Curriculum will give learners the skills and knowledge necessary to be able to create, edit, and query databases and tables. This curriculum will give students the skills and knowledge necessary to take full advantage of Microsoft Access 2000's advanced capabilities. Students will learn how to create and manipulate forms, create and manipulate reports, integrate with the web, and use some of Access 2000's advanced tools.

This curriculum consists of 3 courses:
72050 Microsoft Access 2000 Fundamentals - 6-8 hours
72051 Microsoft Access 2000 Proficient User - 6-8 hours
72052 Microsoft Access 2000 Expert User - 6-8 hours

Certification Requirements This course contains content that will help prepare students for the Proficient and Expert Access 2000 MOUS certifications.

Learn To
See individual course descriptions for specific course objectives and scope.

Audience
End users. It can be assumed that students have a working knowledge of: - Fundamentals of using a GUI (i.e., pull-down and pop-up menus, manipulating windows, etc.). - Basic awareness of database technology.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits Per Course
ITCAP credits: 1.5 Credit Hours
CEU credits: 2.10 CEUs

Language Options
US English

Total Learning Time
18 to 24 hours




Microsoft Access 2000 Fundamentals
Course Overview
This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000. Participants will learn to identify the basic features of Access 2000; create and maintain tables; and work with Access 2000 data.

Learn To
Identify the concepts related to databases and the features of Access 2000.
Create and maintain tables and table data.
Locate and manipulate data.

Audience
This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
ITCAP credits: 0.5 Credit Hour
CEU credits: 0.70 CEUs

Language Options
French, Dutch, Italian, Brazilian Portuguese, German, US English, Chinese, Spanish

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Access 2000 Basics - 2-3 hours
Identify the advantages of the database approach over the traditional approach for storing and accessing data.
Match the relational database components with their definitions.
Sequence the steps involved in planning a relational database.
Match the Access 2000 interface components with their functions.
Open an existing database in Access 2000.
Identify the functions of each Access 2000 database object.
Identify the object views available in Access 2000.
Print database objects.
Create a new database in Access 2000.
Access help on a specified subject by using the office Assistant.

Unit 2: Access 2000 Tables - 2-3 hours
Create a table by using the Table Wizard.
Create a table by using the Design view.
Create a table by entering data directly in the Data sheet view.
Set a primary key for a table.
Insert a field into a table.
Modify the data type of a field.
Modify the layout of a field by moving the field in the Design view.
Modify the properties of a field.
Create an input mask for a field in a table.
Delete a field from a table.
Enter data in a table.
Customize the Datasheet view of a table.
Navigate between the records in a database object.
Modify the data in a table.
Delete a record from a table.
Copy items by using the Office Assistant.

Unit 3: Working with Access 2000 Data 2 hours
Locate a specific record in a table.
Match the filters available in Access 2000 with their functions.
Apply a filter to a table by specifying a search criterion.
Apply Filter By Form to a table.
Apply Filter Excluding Selection.
Apply the Advanced Filter/Sort filter to a table.
Remove a filter applied on a database object.
Sort records of a table on a single field.
Sort records of a table on multiple fields.
Create a query based on a single table in the database.
Create a query based on multiple tables in the database.
Create a query by using the Simple Query Wizard.
Save a query.
Retrieve a query.
Sort the output of a query on a specified field.
Print the output of a query.
Create a query with a summary to compute the data in a field of a table.
Modify a query.
Add a table to an existing query.
Modify a field in a query to enable the query to perform custom calculations.




Microsoft Access 2000 Proficient User
Course Overview
This course is intended for end users that are looking to use the intermediate skills of Microsoft Access 2000. At the completion of this course, students will learn how to use Access 2000 to maintain tables and table data; manage Access 2000 data; create and modify forms; and create and modify report formats.

Learn To
Use Access 2000 to maintain tables and table data.
Manage Access 2000 data.
Create and modify forms.
Create and modify report formats.

Audience
This course is intended for end users that are looking to use the intermediate features of Microsoft Access 2000. Participants should have completed Microsoft Windows 98 Fundamentals (Course 71011) or have equivalent knowledge and Microsoft Access 2000 Fundamentals (Course 72050).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
ITCAP credits: 0.5 Credit Hour
CEU credits: 0.70 CEUs

Language Options
Chinese, Dutch, French, Italian, US English, German, Spanish

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Access 2000 Tables - 1-2 hours
Create a relationship between two tables.
Enforce referential integrity on the basis of specified requirements.
Display related records in a subdatasheet for a record in the Datasheet view.
Print the relationships in an Access database from the Relationships window.
Match the criteria for data integrity with their functions.
Set a validation rule for a field of a table by using Expression Builder.
Set validation text for a field of a table by using the Design view.
Set the required property criterion for a given field of a table by using the Design view.
Set up a lookup field in a given table by using the Design view.
Identify the factors to be considered while selecting an appropriate data type for a field.
Modify an input mask by using the Design view.
Modify a lookup field in a table by using the Design view.

Unit 2: Applications and Database Administration - 1-2 hours
Import data into a new Access 2000 table.
Link the data from an Excel spreadsheet to an Access 2000 table.
Add a hyperlink to a file by using the Datasheet view.
Copy database objects to Excel by using the drag and drop method.
Export a database object to a Web page.
Back up a database by using the Backup utility.
Restore a database from a backup copy by using the Backup utility.
Compact an open database.

Unit 3: Access 2000 Forms - 2 hours
Create a form by using the Form Wizard.
Match the control types with their functions.
Add controls to a form by using the Control Toolbox.
Add a calculated control to a form by using the Control Toolbox.
Modify the format properties of a form control.
Add sections to a form.
Enter a record in a form.

Unit 4: Access 2000 Reports - 2 hours
Create a report by using the Report Wizard.
Add sections to a report.
Print a report.
Add controls to a report.
Add a calculated control to a report in the Design view.
Resize a control in a report in Design View.
Modify the format properties of a report.




Microsoft Access 2000 Expert User
Course Overview
This course provides participants the knowledge to use the advanced features of Microsoft Access 2000. At the completion of this course, students will learn how to create and refine queries; create, modify and enhance the forms in the Design view; create, modify and enhance reports; and secure and enhance the performance of an Access 2000 database.

Learn To
Create and refine queries.
Create, modify and enhance the forms in the Design view.
Create, modify and enhance reports.
Secure and enhance the performance of an Access 2000 database.

Audience
This course is intended for end users that are looking to use the advanced features of Microsoft Access 2000. Participants should have completed Microsoft Windows 98 Fundamentals (Course 71011) or have equivalent knowledge, Microsoft Access 2000 Fundamentals (Course 72050) and Microsoft Access 2000 Proficient User (Course 72051).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
ITCAP credits: 0.5 Credit Hour
CEU credits: 0.70 CEUs

Language Options
Spanish, German, Italian, US English, Dutch, Chinese, French

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Access Queries - 1-2 hours
Create an update query by using the Query Design toolbar.
Create a delete query by using the Query Design toolbar.
Create an append query by using the Query Design toolbar.
Create a make-table query by using the Query Design toolbar.
Create a select query that totals a group of records by using the Design view.
Create a parameter query by using the Design view.
Create a crosstab query by using the Crosstab Query Wizard.
Specify multiple search criteria in a query to display specific records by using the Design view.
Modify the properties of a field in a query.
Filter records in a query.
Change the type of join between two tables in a query.
Remove the join between two tables in a query.
Optimize a query by indexing the table on a field.

Unit 2: Access Forms - 1-2 hours
Create a form by using the Design view.
Customize the form sections by using the Design view.
Set the properties of a section in a form by using the Section dialog box.
Modify the properties of a form in the Design view by using the Form dialog box.
Modify the properties of a control in a form.
Apply conditional formatting to the form data.
Insert a graphic in a form in the Design view.
Add a subform to a form by using the Toolbox toolbar.
Link the main form with its subform by using the Subform/Subreport dialog box.

Unit 3: Access Reports - 2 hours
Create a report by using the Design view.
Create a chart in a report by using the Chart Wizard.
Modify the properties of a report in the Design view.
Modify a report by using the Design view.
Modify the properties of the sections in a report by using the shortcut menu.
Modify the properties of a control in a report by using the Report Design toolbar.
Insert a picture in a report.
Add a subreport to a report by using the Toolbox toolbar.
Synchronize a report and its subreport by using the Report Design toolbar.

Unit 4: Access 2000 Tools - 2 hours
Create a replica of a database.
Export a table from an Access 2000 database to Excel.
Set the startup options for a database.
Encrypt a database.
Set a password for a database.
Create a macro by using Macro Builder.
Create a switchboard form by using the Switchboard Manager.
Split a database between its data and its objects by using the Database Splitter.
Optimize the performance of a database by using the Performance Analyzer.
Update the link of a linked table in a database by using the Linked Table Manager.
Create a data access page by using the Page Wizard.
Group the records of a data access page in Design view.
Sort the records of a data access page by using the Page Design toolbar.
Create a hyperlink in a data access page to another data access page.