NR Computer Learning Center . 2100 W. Orangewood . #110 . Orange . CA 92868 . 714-505-3475 . Computer Training, Testing, Assessment and Consulting Service provider for Small, Medium and Large businesses (SMB/SME).

Microsoft Access 2010 Advance

One-Day hands-on Microsoft Access 2010 Advance course will provide training in exchanging data with other applications, automating the business processes by using VBA code, and secure and share databases.

Topics

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.

Prerequisites

Experience with Access 2010 and completed Microsoft Access 2010 Intermediate or equivalent.

Training Class Material:

Course material
20% off Practice Test
One hour Consulting Service

For more information, call 714-505-3475

For Schedule, click here.

For more information, call (714) 505-3475.