Microsoft Access Training

One of the most efficient and powerful ways of managing large amount of data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools.

Hands-on Instructor Led Training

A hands-on training provides understanding of the database concepts, creating and modifying databases, creating and working with Access tables, relationships, queries, forms, and reports and their various objects using the Microsoft® Office Access™ 2013 relational database application. You will also learn to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Topic:

Day 1

  • Identify the Elements of the Access Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process
  • Create a New Database
  • Create a Table Using the Design View
  • Manage Tables
  • Establish Table Relationships
  • Modify Table Data
  • Sort and Filter Records
  • Work with Subdatasheets
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
  • Create a Form
  • Modify the Design of a Form
  • View and Edit Data Using an Access Form
  • 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

  • Constrain Data Entry Using Field Properties
  • Establish Data Entry Formats for Entering Field Values
  • Create a List of Values for a Field
  • Create Query Joins
  • Join Tables with No Common Fields
  • Relate Data Within a Table
  • Set the Select Query Properties
  • Retrieve Records Based on Input Criteria
  • Create Action Queries
  • 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 the Display of Data Conditionally
  • Organize Report Information
  • Format Reports
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

Day 3

  • Restructure the Data in a Table
  • Create a Junction Table
  • Improve the Table Structure
  • Create SubQueries
  • Create Unmatched and Duplicate Queries
  • Group and Summarize Records Using Criteria
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart
  • Create a Macro
  • Attach a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Publish Reports as PDF
  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

Target Audience
This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Click here to view the schedule