Access 2003: Designing a Database

ExecuTrain
Alpharetta, Georgia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

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. This training, which has been approved by the National Association of State Boards of Accountancy, includes exercise items intended to assist candidates in their training for Continuing Professional Education (CPE) credits.

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.
Hardware and Software Required:
Browser Netscape Communicator 4.0
Browser AOL 4.0
Operating System MacOS 8.5
Browser Microsoft Internet Explorer 4.0
Operating System MS-Windows 95

Table of Contents:

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


...''

Phone:1-800-908-7246

School Address:



Jobs & Resumes: Alpharetta
Houses & Roommates: Alpharetta

Access 2003: Integrating Access with the Web, XML, and Office Applications
Access 2003: Improving Usability with Access Macros
Acrobat 8.0
ACT! 2000: Advanced
ACT! 2007
Quickbooks 2006
Corel Presentations 11
Crystal Reports 2008
Excel 2003: Collaborating with Workbooks

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.