Access 2003: Designing a Database
Have a question about this course? Contact a representative.
Course Description
As you begin this course, you should have the basic skills you need to work with Microsoft® Office Access 2003 database. In this course, you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications. This course is designed for the student who wishes to learn intermediate-level operations of the Microsoft Access Database program. It is designed for students pursuing the Microsoft® Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.
Objectives:
In this course, you will design and create a new Access database; restrict data entry using field properties, create an input mask, and lookup field.
Course Outline
Planning a Database
Lesson Introduction
Design a Relational Database
Identify Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize the Data
Designate Primary and Foreign Keys
Lab: Planning a Simple Human Resources Database
Lesson Follow Up
Building the Structure of a Database
Lesson Introduction
Create a New Database
Create a Table Using a Wizard
Create Tables in Design View
Create Relationships between Tables
Lab: Creating a Database and Adding Tables
Lesson Follow Up
Controlling Data Entry
Lesson Introduction
Restrict Data Entry with Field Properties
Create an Input Mask
Create a Lookup Field
Lab: Streamlining Data Entry and Maintaining Data Integrity
Lesson Follow Up
More Information
| Language | English |
| Course Length | 1.90 hours |
| Duration of Access | 12 weeks |
| Instructor | Self Study |
| Vendor | Element K |
| Requirements/Materials Included | Hardware and Software Required: Browser Netscape Communicator 4.0 Browser Other: AOL 4.0 Operating System MacOS 8.5 Browser Microsoft Internet Explorer 4.0 Operating System MS-Windows 95 |