|
Provided by: 123-CBT Computer Based Training Access 2000 Fundamentals |
 |
Training
Provided by 123-CBT Computer Based Training
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.
Content Emphasis
Skills-Based
Audience
This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Access 2000 Basics
Duration: 2 - 3 Hour(s)- 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
Duration: 2 - 3 Hour(s)- 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
Duration: 2 Hour(s)- 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.
|
|
||||||||||
Access 2000 Fundamentals
--
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
-...
