Microsoft Access 2010 Intermediate
Sponsored links
This course is designed to teach individuals intermediate-level operations of the Microsoft® Office Access® program. You will learn 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. You will also learn how to improve forms, customize reports to organize the displayed information and produce specific print layouts and share data between Access and other applications.
In this course you will improve and customize tables, queries, forms and reports, and share Access data with other applications.
| Delivery: |
|
| Category: | |
| Duration: |
|
| Qualification: |
|
Further Details
Microsoft Access 2010 Training Course (Intermediate) Outline -
Controlling Data Entry
Constrain Data Entry Using Field Properties
Establish Data Entry Formats for Entering Field Values
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
Set 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 the Display of Data Conditionally
Customizing Reports
Organize Report Information
Format Reports
Control Report 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
This Training Course is offered "in house" at the following locations:
Cambridge
Colchester
Ipswich
Leicester
Norwich
Peterborough
Birmingham
London N
London NW
London SE
London SW
London W
London WC
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
