Microsoft Access 2010 Level 2 - DAC10L2

In this course you will improve and customise tables, queries, forms and reports, and share Access data with other applications.

Target Audience:

Microsoft Office Access 2010 Level 2 is designed for delegates who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity, handling complex queries, forms, and reports, and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2010.

Outline

Lesson 1: Controlling Data Entry

  • Topic 1A: Constrain Data Entry Using Field Properties
  • Topic 1B: Establish Data Entry Formats for Entering Field Values
  • Topic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables

  • Topic 2A: Create Query Joins
  • Topic 2B: Join Tables with No Common Fields
  • Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries

  • Topic 3A: Set the Select Query Properties
  • Topic 3B: Retrieve Records Based on Input Criteria
  • Topic 3C: Create Action Queries

Lesson 4: Improving Forms

  • Topic 4A: Restrict Data Entry in Forms
  • Topic 4B: Organize Information with Tab Pages
  • Topic 4C: Add a Command Button to a Form
  • Topic 4D: Create a Subform
  • Topic 4E: Display a Summary of Data in a Form
  • Topic 4F: Change the Display of Data Conditionally

Lesson 5: Customizing Reports

  • Topic 5A: Organize Report Information
  • Topic 5B: Format Reports
  • Topic 5C: Control Report Pagination
  • Topic 5D: Summarize Report Information
  • Topic 5E: Add a Subreport to an Existing Report
  • Topic 5F: Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

  • Topic 6A: Import Data into Access
  • Topic 6B: Export Data to Text File Formats
  • Topic 6C: Export Access Data to Excel
  • Topic 6D: Create a Mail Merge
  • Pricing / Dates / Locations available on request

  • Please call us on 01285 711200
    Email: info@connect2courses.com
    Enquire below:

Course Information

  • Define database objects
  • Design a simple database
  • Create tables and table relationships
  • Manage data in a table
  • Create filters and queries
  • Query records using expressions
  • Create and modify forms and reports
  • Open and navigate in a Word document
  • Open and navigate in an Excel spreadsheet
  • Open a text file in Notepad

At the end of this course you 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
  • Customise reports to organise the displayed information and produce specific print layouts
  • Share data between Access and other applications

Enquire about this course

Please leave this field blank: