Email a Friend
Print
Add to Outlook
Event Information
Date
11/4/2008 - 11/6/2008
Time
6:00 PM - 8:30 PM
Venue
Carmichael Hall
Cost
85.00
Audience
General Audience
Additional Information
An introduction to the fundamentals of creating a relational database. You will learn the general capabilities of Access as a complete database creation utility, focusing primarily on table structures.
Target Audience Individuals who are new to computers or inexperienced with database design.
Getting Started with Access 2007
Use the Database Wizard
Define Access capabilities and uses
Learn database terminology and Access Objects
Use database window to choose objects
Navigate records
Enter data into records/edit records
Preview and print datasheet
Get Help and exit Access
Using Tables and Queries
Plan a database
Create a table and define fields
Define a Primary Key
Use table design view
Sort and find data
Filter records
Create and modify a query
Use And & Or criteria in a query
Modifying a Database Structure
Examine relational databases
Understand relationship types
Plan related tables and lookups
Understand and use multiple data types
Modify and work with field properties
Use data validation
Use linked and imported tables
Establish table relationships
Enforce referential integrity
Use the Lookup Wizard
Import data from other databases
Class Activity
In addition to the instructor-led tutorials, students will create the table structures necessary to create a database capable of handling an invoice system for a small retail business.
