Skip Navigation Links

Course Length:
1 Day
Course Description:
You will improve and customize tables, queries, forms and reports, and share Access data with other applications.
Who Should Attend:
This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access® program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.
Benefits of Attendance:
Upon completion of this course, students will be able to:
  • Streamline data entry and maintain data integrity.
  • Join tables to retrieve data from unrelated tables.
  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
  • Improve forms.
  • Customize reports to organize the displayed information and produce specific print layouts.
  • Share data between Access and other applications.
Prerequisites:
To ensure your success, we recommend that you first take one of Element K’s introductory courses, such as Microsoft® Office Access® 2010 : Level 1, or have equivalent knowledge and skills.
Course Outline:
  • Controlling Data Entry
    1. Constrain Data Entry Using Field Properties
    2. Establish Data Entry Formats for Entering Field Values
    3. Create a List of Values for a Field
  • Joining Tables
    1. Create Query Joins
    2. Join Tables with No Common Fields
    3. Relate Data Within a Table
  • Creating Flexible Queries
    1. Set the Select Query Properties
    2. Retrieve Records Based on Input Criteria
    3. Create Action Queries
  • Improving Forms
    1. Restrict Data Entry in Forms
    2. Organize Information with Tab Pages
    3. Add a Command Button to a Form
    4. Create a Subform
    5. Display a Summary of Data in a Form
    6. Change the Display of Data Conditionally
  • Customizing Reports
    1. Organize Report Information
    2. Format Reports
    3. Control Report Pagination
    4. Summarize Report Information
    5. Add a Subreport to an Existing Report
    6. Create a Mailing Label Report
  • Sharing Data Across Applications
    1. Import Data into Access
    2. Export Data to Text File Formats
    3. Export Access Data to Excel
    4. Create a Mail Merge