TRAIN Online Class Schedule
Course Access 2010: Intro [WDRS0110/CR/01]
Prerequisites Comfort working in the Windows environment.
Prerequisite Course
Requal. Interval One Time Only
Contact Barbara Brooks
Authorized Instructors
Reference Material
Target Audience People familiar with databases and how they are utilized.
Objective Learn Microsoft's database management system and concepts. Explore the user interface, customize the Access environment and use an existing database. Learn the relational database design process, define database purpose, review existing data, determine fields and group fields into tables. Normalize data, designate primary and foreign keys and determine table relationships. Create a new database, create and manage tables, then create a table relationship. Modify table data and sort records. Filter records, create a query, add criteria to a query, add a calculated field to a query and perform calculations on a record grouping. View data using an access form. Create and modify the design of a form. Create an Access report and add a custom calculated field to a report. Format the controls and apply an AutoFormat to a report.
Course Content * Getting Started with Access
* Identifying Components of a Database
* Building a Database
* Managing Data in a Table
* Viewing Data in Tables
* Querying a Database
* Designing Forms
* Generating Reports
Course Content
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.
Project:
Task
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.