|
Provided by: 123-CBT Computer Based Training 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.
Content Emphasis
Skills-Based
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).
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Access 2000 Tables
Duration: 1 - 2 Hour(s)- 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
Duration: 1 - 2 Hour(s)- 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
Duration: 2 Hour(s)- 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
Duration: 2 Hour(s)- 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.
|
|
||||||||||
