Description
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.
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).
Prerequisites
(Currently no course prerequisite information)
Objective
- 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.
Topics Include
Unit 1: Access Queries - 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 - 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 - 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 - 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.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).
The network version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Web Based Training
|
