HOUSTON, TEXAS MICROSOFT ACCESS COURSES - Call 713/487-6465 Call 713/487-6465 Call 713/487-6465

Posting ID : B1009195146
Date Posted : 2012-06-23
Group : Computer Services

HOUSTON, TEXAS MICROSOFT ACCESS COURSES - Call 713/487-6465 Call 713/487-6465 Call 713/487-6465

Hands-on, Instructor-led training
Professional experienced Tutors & Instructors
Step-by-Step training method
Step-by-Step Training Manual with exercise software
Certificate of completion
Reasonable flat price
Training can be customized to suit your specific needs

Microsoft Access 2010 – Course in Houston, Texas

Microsoft Access 2010: Level 1

Training Course
Content

Lesson 1: Getting Started with Access Databases

Topic 1A:
Identify the Elements of the Access 2010 Interface
Topic 1B: Identify the
Components of a Database
Topic 1C: Examine the Relational Database Design
Process

Lesson 2: Building the Structure of a Database

Topic 2A:
Create a New Database brTopic 2B: Create a Table Using the Design View
Topic
2C: Manage Tables
Topic 2D: Establish Table Relationships

Lesson 3:
Managing Data in a Table

Topic 3A: Modify Table Data brTopic 3B: Sort
and Filter Records
Topic 3C: Work with Subdatasheets

Lesson 4:
Querying a Database

Topic 4A: Create a Query brTopic 4B: Add Criteria to
a Query
Topic 4C: Add a Calculated Field to a Query
Topic 4D: Perform
Calculations on a Record Grouping

Lesson 5: Designing Forms

Topic
5A: Create a Form
Topic 5B: Modify the Design of a Form
Topic 5C: View and
Edit Data Using an Access Form

Lesson 6: Generating Reports

Topic
6A: Create a Report brTopic 6B: Add a Control to a Report
Topic 6C: Format
the Controls in a Report
Topic 6D: Enhance the Appearance of a Report

Topic 6E: Prepare a Report for Print

Appendix A: Microsoft Office Access
2010 Exam 77–885

Microsoft Access 2010: Level 2

Training Course
Content

Lesson 1: Controlling Data Entry

Topic 1A: Constrain Data
Entry Using Field Properties brTopic 1B: Establish Data Entry Formats for
Entering Field Values
Topic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables

Topic 2A: Create Query Joins
Topic 2B: Join
Tables with No Common Fields
Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Topic 3A: Set the Select Query
Properties
Topic 3B: Retrieve Records Based on Input Criteria
Topic 3C:
Create Action Queries

Lesson 4: Improving Forms

Topic 4A: Restrict
Data Entry in Forms
Topic 4B: Organize Information with Tab Pages
Topic
4C: Add a Command Button to a Form
Topic 4D: Create a Subform
Topic 4E:
Display a Summary of Data in a Form
Topic 4F: Change the Display of Data
Conditionally

Lesson 5: Customizing Reports

Topic 5A: Organize
Report Information
Topic 5B: Format Reports
Topic 5C: Control Report
Pagination
Topic 5D: Summarize Report Information
Topic 5E: Add a
Subreport to an Existing Report
TTopic 5F: Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

Topic 6A: Import Data into
Access
Topic 6B: Export Data to Text File Formats
Topic 6C: Export Access
Data to Excel
Topic 6D: Create a Mail Merge

Microsoft Access 2010:
Level 3

Training Course Content

Lesson 1: Structuring Existing
Data

Topic 1A: Restructure the Data in a Table br Topic 1B: Create a
Junction Table
Topic 1C: Improve the Table Structure

Lesson 2: Writing
Advanced Queries

Topic 2A: Create SubQueries
Topic 2B: Create
Unmatched and Duplicate Queries
Topic 2C: Group and Summarize Records Using
Criteria
Topic 2D: Summarize Data Using a Crosstab Query

Lesson 3:
Simplifying Tasks with Macros

Topic 3A: Create a Macro
Topic 3B:
Attach a Macro
Topic 3C: Restrict Records Using a Condition
Topic 3D:
Validate Data Using a Macro

Lesson 4: Creating Effective Reports

Topic 4A: Include a Chart in a Report
Topic 4B: Print Data in Columns

Topic 4C: Cancel Printing of a Blank Report
Topic 4D: Publish Reports as PDF

Lesson 5: Maintaining an Access Database

Topic 5A: Link Tables to
External Data Sources
Topic 5B: Manage a Database
Topic 5C: Determine
Object Dependency
Topic 5D: Document a Database
Topic 5E: Analyze the
Performance of a Database

Microsoft Access 2010: Level 4

Training
Course Content

Lesson 1: Integrating Access into Your Business

Topic 1A: Import XML Data into an Access Database
Topic 1B: Export Access
Data to the XML Format
Topic 1C: Export Data to an Outlook Address Book

Topic 1D: Collect Data Through Email Messages

Lesson 2: Automating a
Business Process with VBA

Topic 2A: Create a Standard Module
Topic 2B:
Develop Code
Topic 2C: Call a Procedure from a Form
Topic 2D: Run a
Procedure

Lesson 3: Managing Switchboards

Topic 3A:
Create a Database Switchboard
Topic 3B: Modify a Database Switchboard

Topic 3C: Set the Startup Options

Lesson 4:
Distributing and Securing Databases

Topic 4A: Split a Database
Topic
4B: Implement Security
Topic 4C: Set Passwords
Topic 4D: Convert an Access
Database to an ACCDE File
Topic 4E: Package a Database with a Digital
Signature

Lesson 5: Sharing Databases Using a
SharePoint Site

Topic 5A: Export a Table to a SharePoint List
Topic
5B: Import Data from a SharePoint List
Topic 5C: Publish a Database to a
SharePoint Site
Topic 5D: Move a Database to a SharePoint Site
Topic 5E:
Work Offline

Microsoft Access 2007 – Course in Houston, Texas

Microsoft Access 2007: Level 1

Training Course
Content

Lesson 1: Exploring the Microsoft® Office Access™ 2007
Environment

Topic 1A: Examine Database Concepts
Topic 1B: Explore the
User Interface
Topic 1C: Use an Existing Access Database
Topic 1D:
Customize the Access Environment
Topic 1E: Obtain Help

Lesson 2:
Designing a Database

Topic 2A: Describe the Relational Database Design
Process
Topic 2B: Define Database Purpose
Topic 2C: Review Existing Data

Topic 2D: Determine Fields
Topic 2E: Group Fields into Tables
Topic 2F:
Normalize Data
Topic 2G: Designate Primary and Foreign Keys
Topic 2H:
Determine Table Relationships

Lesson 3: Building a Database

Topic
3A: Create a New Database
Topic 3B: Create a Table
Topic 3C: Manage Tables

Topic 3D: Create a Table Relationship
Topic 3E: Save a Database as a Previous
Version

Lesson 4: Managing Data in a Table

Topic 4A: Modify Table
Data
Topic 4B: Sort Records
Topic 4C: Work with Subdatasheets

Lesson 5: Querying a Database

Topic 5A: Filter Records
Topic 5B:
Create a Query
Topic 5C: Add Criteria to a Query
Topic 5D: Add a
Calculated Field to a Query
Topic 5E: Perform Calculations on a Record
Grouping

Lesson 6: Designing Forms

Topic 6A: View Data Using an
Access Form
Topic 6B: Create a Form
Topic 6C: Modify the Design of a Form

Lesson 7: Generating Reports

Topic 7A: View an Access Report
Topic
7B: Create a Report
Topic 7C: Add a Custom Calculated Field to a Report

Topic 7D: Format the Controls in a Report
Topic 7E: Apply an AutoFormat Style
to a Report
Topic 7F: Prepare a Report for Print

Microsoft Access
2007: Level 2

Training Course Content

Lesson 1: Controlling Data
Entry

Topic 1A: Restrict Data Entry Using Field Properties
Topic 1B:
Establish a Pattern for Entering Field Values
Topic 1C: Create a List of
Values for a Field

Lesson 2: Joining Tables

Topic 2A: Create Query
Joins
Topic 2B: Join Unrelated Tables
Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries

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

Lesson 4: Improving Forms

Topic 4A: Design a Form Layout

Topic 4B: Enhance the Appearance of a Form
Topic 4C: Restrict Data Entry in
Forms
Topic 4D: Add a Command Button to a Form
Topic 4E: Create a Subform

Lesson 5: Customizing Reports

Topic 5A: Organize Report Information

Topic 5B: Format the Report
Topic 5C: Set Report Control Properties
Topic
5D: Control Report Pagination
Topic 5E: Summarize Report Information
Topic
5F: Add a Subreport to an Existing Report
Topic 5G: Create a Mailing Label
Report

Lesson 6: Sharing Data Across Applications

Topic 6A: Import
Data into Access
Topic 6B: Export Data
Topic 6C: Analyze Access Data in
Excel
Topic 6D: Export Data to a Text File
Topic 6E: Merge Access Data
with a Word Document

Microsoft Access 2007: Level 3

Training
Course Content
Lesson 1: Structuring Existing Data

Topic 1A: Analyze
Tables
Topic 1B: Create a Junction Table
Topic 1C: Improve Table Structure

Lesson 2: Writing Advanced Queries

Topic 2A: Create Subqueries

Topic 2B: Create Unmatched and Duplicate Queries
Topic 2C: Group and
Summarize Records Using Criteria
Topic 2D: Summarize Data Using a Crosstab
Query
Topic 2E: Create a PivotTable and a PivotChart

Lesson 3:
Simplifying Tasks with Macros

Topic 3A: Create a Macro
Topic 3B:
Attach a Macro
Topic 3C: Restrict Records Using a Condition
Topic 3D:
Validate Data Using a Macro
Topic 3E: Automate Data Entry Using a Macro

Lesson 4: Making Effective Use of Forms

Topic 4A: Display a Calendar
on a Form
Topic 4B: Organize Information with Tab Pages
Topic 4C: Display
a Summary of Data in a Form

Lesson 5: Making Reports More Effective

Topic 5A: Include a Chart in a Report
Topic 5B: Print Data in Columns

Topic 5C: Cancel Printing of a Blank Report
Topic 5D: Create a Report
Snapshot

Lesson 6: Maintaining an Access Database

Topic 6A: Link
Tables to External Data Sources
Topic 6B: Manage a Database
Topic 6C:
Determine Object Dependency
Topic 6D: Document a Database
Topic 6E:
Analyze the Performance of a Database

Microsoft Access 2007: Level 4

Training Course Content

Lesson 1: Integrating Access into Your
Business

Topic 1A: Import XML Data into an Access Database
Topic 1B:
Export Access Data to XML Format
Topic 1C: Export Data to the Outlook Address
Book
Topic 1D: Collect Data Through Email Messages

Lesson 2:
Automating a Business Process with VBA

Topic 2A: Create a Standard Module

Topic 2B: Develop Code
Topic 2C: Call a Procedure from a Form
Topic 2D:
Run the Procedure

Lesson 3: Managing Switchboards

Topic 3A: Create
a Database Switchboard
Topic 3B: Modify a Database Switchboard
Topic 3C:
Set the Startup Options

Lesson 4: Distributing and Securing Databases

Topic 4A: Split a Database
Topic 4B: Implement Security
Topic 4C: Set
Passwords
Topic 4D: Convert an Access Database to an ACCDE File
Topic 4E:
Package a Database with a Digital Signature

Lesson 5: Sharing Databases
Using a SharePoint Site

Topic 5A: Export a Table to a SharePoint List

Topic 5B: Import Data from a SharePoint List
Topic 5C: Publish a Database to
a SharePoint Site
Topic 5D: Move a Database to a SharePoint Site
Topic 5E:
Work Offline

Microsoft Access 2003 – Course in Houston, Texas

Microsoft Access 2003: Level 1

Training Course
Content

Lesson 1: An Overview of Access 2003

Topic 1A: Understand
Relational Databases
Topic 1B: Examine the Access Environment
Topic 1C:
Open 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 Recordsets

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: Work
with Subdatasheets

Lesson 4: Querying the Database

Topic 4A:
Create a 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: Examine Form Design
Guidelines
Topic 5B: Create a Form Using AutoForm
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

Appendix A: Microsoft Office Specialist Program

Microsoft
Access 2003: 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

Appendix A: Microsoft Office Specialist Program

Microsoft Access 2003:
Level 3

Training Course Content
Lesson 1: Structuring Existing Data

Topic 1A: Import Data
Topic 1B: Analyze Tables
Topic 1C: Create a
Junction Table
Topic 1D: 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

Appendix A: Microsoft Office Specialist Program

Microsoft Access 2003: Level 4

Training Course Content

Lesson 1: Making Your Data Available on the Web

Topic 1A: Create a Data
Access Page by Using the Wizard
Topic 1B: Improve the Presentation of the
Data Access Page
Topic 1C: Viewing Data Access Pages with the Browser

Topic 1D: Edit Data Using the Data Access Page
Topic 1E: Group Records in the
Data Access Page

Lesson 2: Developing a Data Access Page in Design View

Topic 2A: Create a Data Access Page in Design View
Topic 2B: Incorporate
a ComboBox in the Data Access Page
Topic 2C: Test the New Record Function of
the Data Access Page
Topic 2D: Develop a PivotTable with the Office
PivotTable Tool
Topic 2E: Develop a PivotChart

Lesson 3: Integrating
Access into Your Business

Topic 3A: Import XML Data into an Access
Database
Topic 3B: Export Access Data to XML Format
Topic 3C: Share Data
with Other Office Applications

Lesson 4: Automating a Business Process
with VBA

Topic 4A: Create a Standard Module
Topic 4B: Develop Code

Topic 4C: Call a Procedure from a Form
Topic 4D: Run the Procedure

Lesson 5: Creating a Switchboard and Setting the Startup Options

Topic
5A: Create a Database Switchboard
Topic 5B: Modify a Database Switchboard

Topic 5C: Set the Startup Options
Topic 5D: Modify the Startup Options

Lesson 6: Distributing and Securing the Database

Topic 6A: Split a
Database
Topic 6B: Implement Security
Topic 6C: Set Passwords
Topic 6D:
Encode and Decode a Database
Topic 6E: Convert an Access Database to an MDE
File

Appendix A: Microsoft Office Specialist Program


Some Other Postings