Home | Career Tracks | Boot Camps | Course Search | Student Log In | Request Info | 1-800-482-3172 | Contact Us

About Us
Corporate IT Training
Vocational IT Training
CareerSource Solutions
Government/VA Solutions
Financing Options
Other Training Information
Student Resources
Career Services
Promotions
Press Releases
Course Catalog
Course Search
Forms
Real Estate Classes
Store
Connect With Us

MOS: Microsoft Office 2010 - Access Boot Camp

 

 

Click Here to View Schedules & Pricing and to Enroll Online

 

 

Duration: 1 Day

 

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 course prepares you for Exam 77-885


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
 

 

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
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

Academy Code of Honor:  
The Academy guarantees that students shall pass all vendor examinations during the training program or may re-attend within one year of the program completion date. Students will only be responsible for accommodations and vendor exam fees.  

Student Login | Request Info | Course Search | Contact Us