TRAIN Online Class Schedule
Course Access 2003: Intermediate[LS000670/CR/01]
Prerequisites Access 2003: Introduction or equivalent knowledge
Requal. Interval One Time Only
Contact Nicole Gee
Target Audience People responsible for creating new databases, the designing of tables and relationships, intermediate level queries, forms, reports, and data access pages.
Objective Learn how to follow the steps required to properly design a simple database. Create a new database with related tables. Control data entry by modifying the design of a table to streamline data entry and maintain data integrity. Find and retrieve desired data by using filters and joins between tables and within a single table. Create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries. Enhance the appearance, data entry, and data access capabilities of your forms. Customize reports to better organize the displayed information and produce specific print layouts such as mailing labels. Use Access data in other applications, such as Word and Excel.
Course Content * Planning a Database
* Building the Structure of a Database
* Controlling Data Entry
* Finding and Joining Data
* Creating Flexible Queries
* Improving Your Forms
* Customizing Your Reports
* Expanding the Reach of Your Data

Instructor's Comments If you withdraw from the class 10 business days or fewer before it begins and do not find a replacement, you will be charged the full fee.

Invalid Fermi ID: 00000X

Fermi ID Employee   Visitor   Contractor   Other -- Fermilab Phone Book
  This course has a fee. Select the project and task to use when the class is booked.
Note: The task code popup above requires a recent version of JavaScript. If no tasks appear when you select a project code please use a newer browser. If one is not available please contact the ServiceDesk for assistance. If you return to this page please re-select your project code to re-populate the task code popup.
Waiting List Option Add me to any class that becomes available.
Do you wish to be added to the waiting list? When a class is created or an opening becomes available, persons on the waiting list are automatically enrolled. An email notification will be sent at that time.