MOS: Access 2010 Boot Camp

Description

Access 2010 gives you a powerful set of tools that are sophisticated enough for professional developers, yet easy for new users to learn. Create powerful database solutions that make organizing, accessing, and sharing information easier than ever. This course is recommended 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.

This one-day course prepares you for Exam 77-885

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Curriculum

Lesson 1: Getting Started with Access 2010

Identify the Elements of the User Interface
Identify the Tabs and Commands on the Ribbon
Obtain Help in Access

Lesson 2: Identifying the Components of a Database

Define Database Concepts
Identify the Components of a Database
Examine the Relational Database Design Process

Lesson 3: Organizing Data in Tables

Create a Table
Modify Table Data and Properties
Create a Table Relationship

Lesson 4: Viewing Data in Tables

Sort Records
Filter Records
View Data from Related Tables

Lesson 5: Querying a Database

Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

Create a Form
View Data Using an Access Form
Modify a Form

Lesson 7: Generating Reports

View an Access Report
Create a Report
Add a Calculated Field to a Report
Format the Controls in a Report
Apply a Theme to a Report
Prepare a Report for Print

Lesson 8: 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

Lesson 9: Joining Tables

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

Lesson 10: Creating Flexible Queries

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

Lesson 11: 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

Lesson 12: 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

Lesson 13: Sharing Data Across Applications

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

Lesson 14: Structuring Existing Data

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

Lesson 15: Writing Advanced Queries

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

Lesson 16: Simplifying Tasks with Macros

Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro

Lesson 17: Creating Effective Reports

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

Lesson 18: 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

Enrolled