TRAIN Online Class Schedule
Course Access 2010: Intermediate[WDRS0124/CR/01]
Prerequisites Windows: Introduction and Access: Introduction or equivalent knowledge.
Requal. Interval One Time Only
Contact Barbara Brooks
Authorized Instructors Barbara Brooks (WR)
Target Audience Individuals responsible for creating new databases, the designing of tables and relationships, intermediate level queries, forms, reports, and data access pages.
Objective Modify the design and field properties of a table to streamline data entry and maintain data integrity. Create a list of values for a field. Create query joins, join unrelated tables, relate data within a table. Set select query properties, create parameter and action queries. Design a form layout and enhance the appearance of a form. Restrict data entry in forms, add a command button to a form and create a subform. Organize report information, format the report and set report control properties. Control report pagination, summarize report information and add a subreport to an existing report. Import and export data. Analyze Access data in Excel. Export data to a text file. Merge Access data with a Word Document.
Course Content * Controlling Data Entry
* Joining Tables
* Creating Flexible Queries
* Improving Your Forms
* Customizing Reports
* Sharing Data Across Applications

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.