|
 |
 |
 |
 |
 |
 |
|
|
|
 |
|
|
Microsoft Access - Level 1 |
|
|
 |
|
|
|
 |
 |
 |
|
 |
 |
|
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
 |
|
The skills and knowledge covered in this course are sufficient to create robust relational database systems in Microsoft Access, enter, edit and delete data in database files, produce information in forms and reports, and generate queries on the data.
Learning Outcomes:
At the completion of this courseware participants will be able to:
• start and exit Access and understand how Access works
• understand some elementary database theory.
• create and design relational databases
• set table relationships and add records to a relational database
• import data into an Access table from a variety of sources
• work with records in a relational database
• create simple queries using more than one table
• create select queries for a relational database
• create forms and reports using the Form Wizard and Report Wizard
• access the computer's help system and safely work with a computer.
Course Content:
• Access 2003 Orientation
• Database Theory
• Database Design
• Creating Relational Databases
• Setting Table Relationships
• Adding Relational Records
• Importing Records
• Working With Records
• Relational Queries
• Relational Select Queries
• Creating Forms
• Creating Reports
• General Computer Usage
Target Audience:
This course is primarily designed for people who need to know how to create effective databases using Microsoft Access and to manipulate data to provide viable information.
Duration:
1 Day
Courseware:
High quality learning materials are available for purchase by participants. Participants will also be presented with a certificate of achievement upon completion of the course.
|
|
|
|
|
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
|
|
