|
Provided by: 123-CBT Computer Based Training Access 2000 Expert User |
 |
Training
Provided by 123-CBT Computer Based Training
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.
Content Emphasis
Skills-Based
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).
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Access Queries
Duration: 1 - 2 Hour(s)- 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
Duration: 1 - 2 Hour(s)- 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
Duration: 2 Hour(s)- 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
Duration: 2 Hour(s)- 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.
|
|
||||||||||
Access 2000 Expert User
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
