Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com
Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog (All Modalities)

Item IDCourse Title and DescriptionLength
AIN100AMicrosoft Access Training Part 16.0 hrs
 1 day introduction to Microsoft Access, the most popular desktop database solution. Microsoft Access provides a wealth of powerful data management and reporting tools in a very user friendly environment. This course covers databases, tables, the datasheet, sorting and manipulating tables, basic queries, reports and forms. Using our courseware students will work on several small database applications during this course or develop their own. These can be tailored to the needs of a custom group or private training student. No prior knowledge of Access is assumed. This course is the same as AIN100 Introduction to Microsoft Access day 1.

 
Session 1Tables and Queries 
 
  • Getting Started with Access Databases
    • Orientation to Microsoft Access
    • Create a Simple Access Database
    • Get Help and Configure Options in Microsoft Access
  • Working with table data
    • Modify table data
    • Sort and filter records
  • Querying a database
    • Create Basic Queries
    • Sort and Filter Data in a Query
    • Perform Calculations in a Query

 
Session 2Forms and Reports 
 
  • Using Forms
    • Create Basic Access Forms
    • Work with Data on Access Forms
  • Generating Reports
    • Create a Report
    • Add Controls to a Report
    • Enhance the Appearance of a Report
    • Prepare a Report for Print
    • Organize Report Information
    • Format Reports