Microsoft Excel 2002 Curriculum CBT Training CDs

Rating:
Summary: Microsoft Excel 2002 Curriculum CBT Training CDs
Review: Course Overview
This curriculum presents the learner with the fundamentals of Microsoft Access 2002, and guides the learner through the basics of Access databases and covers topics such as creating and modifying databases, and establishing relationships between tables. It also covers more advanced features of Access 2002, and how to make different types of data queries, work with forms and link data to other databases. Finally, more complex aspects of working with data using Access 2002 are covered.

This curriculum consists of three courses:
Course 74050 Microsoft Access 2002 Fundamentals
Course 74051 Microsoft Access 2002 Proficient User
Course 74052 Microsoft Access 2002 Expert User

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

Audience
The intended audiences for this curriculum are Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, Database Administrators. Access 2002 Fundamentals doesn't require any previous database knowledge. Its audience could include a range of other job types such as Junior Secretarial, Customer Service etc. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits Per Course
CEU credits: 2.10 CEUs

Language Options
US English

Total Learning Time
18 to 24 hours




Microsoft Access 2002 Fundamentals
Course Overview
This course presents the learner with the fundamentals of Microsoft Access 2002. This course guides the learner through the basics of Access databases and covers topics such as creating and modifying databases, and establishing relationships between tables.

Learn To
Identify advantages of a relational database.
Identify the basics of a relational database.
Sequence the steps for planning a relational database.
Create a table in Datasheet view.
Identify features of the Table Wizard
Create a table in Design view.
Identify features of relationships between tables.
Create a one-to-many relationship between tables.
Sequence the steps to define a many-to-many relationship between two tables.

Audience
The intended audiences for this course are Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, Database Administrators. Access 2002 Fundamentals doesn't require any previous database knowledge. Its audience could include a range of other job types such as Junior Secretarial, Customer Service etc. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
Polish, French, German, Spanish, Arabic, US English, Chinese, Italian, Russian, Dutch

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Basics of Access 2002 - 3 hours
Identify advantages of a relational database.
Identify the basics of a relational database.
Sequence the steps for planning a relational database.
Open a database by using Microsoft Access.
Match database objects with their features.
Identify the functions of each database object view.
Create a blank database.
Identify the options available when creating a database by using a database template.
Get help by using the Office Assistant.
Identify features of the Help Window.

Unit 2: Table Creation and Modification - 3 hours
Create a table in Datasheet view.
Identify features of the Table Wizard.
Create a table in Design view.
Create a field for a table in Design view.
Move a field in a table in Datasheet view.
Modify a field property in a table in Design view.
Create an input mask in a table field.
Delete a field from a table in Design view.
Set a field as a primary key in Design view.
Set an index for a field in a table.
Match optimum field data types with their features.
Customize an input mask for a field in a table in Design view.
Identify features of the Lookup Wizard.
Identify the functions of Lookup field properties.
Enter data into a table in Datasheet view.
Edit data in a table in Datasheet view.
Delete data from a table in Datasheet view.
Add a hyperlink to a table in Datasheet view.
Sort table data by a single field.
Copy data into fields from other Office applications by using Office Clipboard.
Match the record navigation controls with their functions.
Locate a record in a datasheet by using the Find command.
Filter by selecting a value in Datasheet view.
Filter by excluding a selected value in Datasheet view.
Filter by form in Datasheet view.
Filter for input by entering specific criteria in a Filter For box.
Filter a record by using the Advanced Filter/Sort window.
Resize a column in Datasheet view.
Format a datasheet.

Unit 3: Table Relationships and Data Integrity - 2 hours
Identify features of relationships between tables.
Create a one-to-many relationship between tables.
Sequence the steps to define a many-to-many relationship between two tables.
Print a relationship report of a database.
Identify features of a subdatasheet.
Validate data integrity in a table.
Identify features of the Required property used to ensure data integrity.