Microsoft Access 2013 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