Skip Ribbon Commands
Skip to main content

EK-084587 - Microsoft Office Access 2010 Introduction, Level I

Price:

Duration: 2 Days

Audience:

Level:

Technology:

Delivery Method:

Software Assurance Value:

Microsoft CPE:

Course Information

Course Description

​This two-day course is for the individual whose job responsibilities include designing and creating new databases, tables and relationships, creating and maintaining records, locating records and producing reports based on a database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.

Course Objectives

​Upon successful completion of this course, students will be able to:

  • identify the basic components of an Access database.
  • build the structure of a database.
  • manage data in tables.
  • query a database.
  • design forms.
  • generate reportsstreamline 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

Course Audience

​This course is designed for students who wish to learn the basics of Microsoft Access.

Course Outline

Day 1
Getting Started with Access Databases
  • Elements of the Access 2010 Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process
Building the Structure of a Database
  • Create a New Database
  • Create a Table Using the Design View
  • Manage Tables
  • Establish Table Relationships
Managing Data in a Table
  • Modify Table Data
  • Sort and Filter Records
  • Work with Subdatasheets
Querying a Database
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Calculations on a Record Grouping
Designing Forms
  • Create and Modify a Form
  • View Data Using an Access Form
Generating Reports
  • Create a Report
  • Add a Control to a Report
  • Format the Controls in a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
Day 2
Controlling Data Entry
  • Constrain Data Entry Using Field Properties
  • Establish Data Entry Formats
  • Create a List of Values for a Field
Joining Tables
  • Create Query Joins
  • Join Tables with No Common Fields
  • Relate Data within a Table
Creating Flexible Queries
  • The Select Query Properties
  • Retrieve Records Based on Input Criteria
  • Create Action Queries
Improving Forms
  • Restrict Data Entry in Forms
  • Organize Information with Tab Pages
  • Add a Command Button to a Form
  • Create a Subform
  • Display a Summary of Data in a Form
  • Change Display of Data Conditionally
Customizing Reports
  • Organize Report Information
  • Format Reports and Control Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
Sharing Data Across Applications
  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

Course Prerequisites

​Prospective students proficient with Windows. Familiarity with the Office 2010 environment is helpful.

Course Schedule
This course is not scheduled yet.

Upcoming Training

There is no item in course list.