Computer Training Course Outline for PC Training Experts
Home
About
Contact
Courses
Tutorials
Hot Articles
Blog
Forums
Access 2016 Level 2
(
1.0 day
)
This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access® program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.
Performance-Based Objectives
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
Improve forms
Customize reports to organize the displayed information and produce specific print layouts
Share data between Access and other applications
Course Outline*
Module 1: 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
Module 4: 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
Module 2: Joining Tables
Create Query Joins
Join Tables with No Common Fields
Relate Data Within a Table
Module 5: 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
Module 3: Creating Flexible Queries
Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries
Module 6: Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge Create a Mail Merge Create a Mail Merge Create a Mail Merge Create a Mail Merge Create a Mail Merge
Register
Dates Offered
Email
Print Friendly
Show All
*Note: webinar courses cover only essential topics due to time constraints. Please discuss topics with your instructor prior to webinars to ensure your necessary topics are covered.
Dates Offered
Email
Print
Friendly
Tuition
Live, In-Person:
$277.00
Live, Webinar:
$166.20
Home
|
About
|
Contact
|
Schedule Training
|
Course Catalog
|
Blog
|
Terms of Use
|
Privacy Statement
Copyright © 2011 Mike Phillips