Access 2010 Level 2: Intermediate Topics
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1 Day

COURSE COST: $425.00

COURSE TIMES: 9:00am - 5:00pm

Printable version of this course
print

COURSE OVERVIEW

This course is designed for students 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 application programs.

In this course you will:

  • Modify the design and field properties of a table to streamline data entry and maintain data integrity.
  • Retrieve data from tables using joins.
  • Create flexible queries to display specified reports, allow user-determined query criteria, and modify data using queries.
  • Enhance the capabilities of a form.
  • Customized reports to organize the displayed information and produce specific print layouts.
  • Share Access data across other applications.


AUDIENCE AND PREREQUISITES

To get the most out of this course, it is recommended you take our Microsoft Office Access 2010: Level 1 course or have equivalent knowledge.

PREREQUISITE COURSESFOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware $ 24.65. For more information, please contact: learn@vtec.org

COURSE TOPICS:


Joining Tables
Create Query Joins
Join Tables with No Common Fields
Relate Data Within a Table

Creating Flexible Queries
Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries

Writing Advanced Queries
Create SubQueries
Create Unmatched and Duplicate Queries
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart

Structuring Existing Data
Restructure the Data in a Table
Create a Junction Table
Improve the Table Structure

Customize Reports
Organize Report Information
Format Reports
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report

Creating Effective Reports
Include a Chart in a Report
Print Data Columns
Cancel Printing of a Blank Report
Publish Reports as a PDF

Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge

Maintaining an Access Database
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database