MS Access 2010 Training Classes in Houston - Call 713-777-7664

MS Access 2010 Training Classes in Houston - Call 713-777-7664

Advanced Access Training Classes in Houston
Training is offered at our facilities or on-site in your office

Call 713-777-7664

or go to http://Compusoftusa.com

Microsoft Access Training in Houston - Hands on Microsoft Access Classes in Houston, Texas

• Hands-on, instructor-led training classes
• Step-by-step training manual with exercise link
• Certificate of completion

Hands on Microsoft Access Training in Houston, Texas
 Microsoft Access Classes in Houston, Texas

Call 713-777-7664

The best way to learn Microsoft Excel is hands-on and step-by-step!
This is a Hands-on, Instructor-led Microsoft Excel Training Class.
You will receive a step-by-step manual with exercise CD.
You will also receive a Certificate of successful completion .
 
Have a group of staff members that needs this training?
We offer training classes both on-site (at your location) and in our computer labs - Inquire about our group-discount pricing.
Microsoft Access - Training Classes in Houston, Texas
Call 713-777-7664



 
Microsoft® Office Access ® : Level 1
Training Course Content


Lesson 1: An Overview of Access

Topic 1A: Relational Databases
Topic 1B: The Access Environment
Topic 1C: The Database Environment
Topic 1D: Examine an Access Table

Lesson 2: Managing Data

Topic 2A: Examine an Access Form
Topic 2B: Add and Delete Records
Topic 2C: Sort Records
Topic 2D: Display Record Sets
Topic 2E: Update Records
Topic 2F: Run a Report

Lesson 3: Establishing Table Relationships

Topic 3A: Identify Table Relationships
Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
Topic 3C: Working with Subdatasheets

Lesson 4: Querying the Database

Topic 4A: The Select Query
Topic 4B: Add Criteria to a Query
Topic 4C: Add a Calculated Field to a Query
Topic 4D: Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

Topic 5A: Form Design Guidelines
Topic 5B: Create AutoForms
Topic 5C: Create a Form Using the Form Wizard
Topic 5D: Modify the Design of a Form

Lesson 6: Producing Reports

Topic 6A: Create an AutoReport
Topic 6B: Create a Report by Using the Wizard
Topic 6C: Examine a Report in Design View
Topic 6D: Add a Calculated Field to a Report
Topic 6E: Modify the Format Properties of a Control
Topic 6F: AutoFormat a Report
Topic 6G: Adjust the Width of a Report
 



 
Microsoft® Office Access ® : Level 2
Training Course Content


Lesson 1: Planning a Database

Topic 1A: Design a Relational Database
Topic 1B: Identify Database Purpose
Topic 1C: Review Existing Data
Topic 1D: Determine Fields
Topic 1E: Group Fields into Tables
Topic 1F: Normalize the Data
Topic 1G: Designate Primary and Foreign Keys

Lesson 2: Building the Structure of a Database

Topic 2A: Create a New Database
Topic 2B: Create a Table Using a Wizard
Topic 2C: Create Tables in Design View
Topic 2D: Create Relationships between Tables

Lesson 3: Controlling Data Entry

Topic 3A: Restrict Data Entry with Field Properties
Topic 3B: Create an Input Mask
Topic 3C: Create a Lookup Field

Lesson 4: Finding and Joining Data

Topic 4A: Find Data with Filters
Topic 4B: Create Query Joins
Topic 4C: Join Unrelated Tables
Topic 4D: Relate Data Within a Table

Lesson 5: Creating Flexible Queries

Topic 5A: Set Select Query Properties
Topic 5B: Create Parameter Queries
Topic 5C: Create Action Queries

Lesson 6: Improving Your Forms

Topic 6A: Enhance the Appearance of a Form
Topic 6B: Restrict Data Entry in Forms
Topic 6C: Add Command Buttons
Topic 6D: Create a Subform

Lesson 7: Customizing Your Reports

Topic 7A: Organize Report Information
Topic 7B: Set Report Control Properties
Topic 7C: Control Report Pagination
Topic 7D: Summarize Information
Topic 7E: Add a Subreport to an Existing Report
Topic 7F: Create Mailing Labels

Lesson 8: Expanding the Reach of Your Data

Topic 8A: Publish Access Data as a Word Document
Topic 8B: Analyze Access Data in Excel
Topic 8C: Export Data to a Text File
Topic 8D: Merge Access Data with a Word Document

 
 
Microsoft® Office Access ® : Level 3
Training Course Content


Lesson 1: Structuring Existing Data

Topic 1A: Import and Link Data Tables
Topic 1B: Analyze Tables
Topic 1C: Improve Table Structure

Lesson 2: Writing Advanced Queries

Topic 2A: Create Unmatched and Duplicates Queries
Topic 2B: Group and Summarize Records Using the Criteria Field
Topic 2C: Summarize Data with a Crosstab Query
Topic 2D: Create a PivotTable and a PivotChart
Topic 2E: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro
Topic 3B: Attach a Macro to a Command Button
Topic 3C: Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros

Topic 4A: Require Data Entry with a Macro
Topic 4B: Display a Message Box with a Macro
Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Effective

Topic 5A: Change the Display of Data Conditionally
Topic 5B: Display a Calendar on a Form
Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Effective

Topic 6A: Cancel Printing of a Blank Report
Topic 6B: Include a Chart in a Report
Topic 6C: Arrange Data in Columns
Topic 6D: Create a Report Snapshot

Lesson 7: Maintaining an Access Database

Topic 7A: Link Tables to External Data Sources
Topic 7B: Back Up a Database
Topic 7C: Compact and Repair a Database
Topic 7D: Protect a Database with a Password
Topic 7E: Determine Object Dependency
Topic 7F: Document a Database
Topic 7G: Analyze the Performance of a Database
 
See Current Schedule
See Current Specials
Register for Class
MS Access 2003 Training in Houston
MS Access 2007 Training in Houston
Microsoft Access computer classes offerings in Houst