|
Provided by: 123-CBT Computer Based Training Access XP 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).
Content Emphasis
Informational
Deployment Options
Internet / Intranet, Download, LAN, Workstation
Accreditation
NASBA credits: 4 CPE Credits
Language Options
American English
Total Learning Time
6 to 8 hours
74050 Objectives
Unit 1: Basics of Access 2002
2 - 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
2 - 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.
|
|
||||||||||
