Further Details
Microsoft Access 2003 Module I
Course Length
Access 2003 Module I is a one day course.
Prerequisites
This course assumes a basic knowledge of the Microsoft Windows operating environment and the fundamental skills validated by the Internet and Computing Core
Certification (IC3).
Brief Description
This course
provides competency in creating databases and tables, working with table
data and field properties, working with related tables and using filters
and queries.
Guided,
step-by-step labs provide opportunities to practice new skills. You can
challenge yourself and reinforce your skills after each lesson in the Lesson
Summary and Lesson Review sections, and the Activities and Optional Labs.
Additional skill review is provided in Lesson Quizzes and a Course Assessment
that are available from your instructor.
Cost:
The cost of this course is just £125 per person
Topics
Creating Databases and Tables
Introduction to Access
Database Components
Relational Database Design
Starting Access
Database Window Layout and Features
Database Creation
Creating Tables
Modifying Table Design
Working with Table Data and Field Properties
Overview of Table Data and Field Properties
Modifying Datasheet Layouts
Working with Table Records
Importing Data into Tables
Modifying Field Properties
Working with Related Tables
Overview of Table Relationships
Establishing Relationships
Enforcing Referential Integrity
Creating Lookup Fields
Using Lookup Fields to Add Data
Using Filters and Queries
Overview of Filters and Queries
Using Comparison Operators
Using Filters
Creating Select Queries
Refining Query Results
Using Criteria in Select Queries
Modifying Select Queries
Performing Calculations in Queries
Creating and Modifying Crosstab Queries
Creating and Modifying Unmatched Queries
Creating and Modifying Duplicate Queries
Guide price
£125 per student |
