Skip to content

Computer Training Classes in Houston - Call 713-777-7664

Home About Us Courses Calendar Location Contact Us
 
You are here: Home arrow Calendar
Microsoft Access 2007 Training in Houston - Hands on Microsoft Access 2007 Classes in Houston, Texas PDF Print E-mail

Hands on Microsoft Access Training in Houston, Texas

 Microsoft Access Classes in Houston, Texas

Call 713-777-7664

The best way to learn Microsoft Access 2007 is hands-on and step-by-step!

This is a Hands-on, Instructor-led Microsoft Access 2007 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 2007 - Training Classes in Houston, Texas

Call 713-777-7664



 

Microsoft® Office Access ® 2007: Level 1  - 1 day hands-on class.


Performance-Based Objectives

  • Examine the basic database concepts and explore the Microsoft

  • Office Access 2007 environment.

  • Design a simple database.

  • Build a new database with related tables.

  • Manage data in a table.

  • query a database using different methods.

  • design forms.

  • generate reports.

 

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® Office Access ® 2007: Level 2  - 1 day hands-on class.


Performance-Based Objectives

  • Modify the design and field properties of a table to streamline data

  • Entry and maintain data integrity.

  • Retrieve data from tables using joins.

  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.

  • Enhance the capabilities of a form by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user.

  • Customize reports to organize the displayed information and produce specific print layouts.

  • Share data across different applications.

 

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® Office Access ® 2007: Level 3  - 1 day hands-on class.


Performance-Based Objectives

  • Restructure data into appropriate tables to ensure data dependency and minimize redundancy.

  • Write advanced queries to analyze and summarize data.

  • Create and revise Microsoft® Office Access™ 2007 macros.

  • Display data more effectively in a form.

  • Customize reports by using various Microsoft® Office Access™ 2007 features, making them more effective.

  • Maintain your database using tools provided by Microsoft® Office Access™ 2007.

 

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® Office Access ® 2007: Level 4  - 1 day hands-on class.


Performance-Based Objectives

  • Share Access data with other applications.

  • Use VBA to automate a business process.

  • Create and modify a database switchboard, and set the startup options.

  • Secure databases.

  • Share databases using a SharePoint site.

 

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

 


INDIVIDUAL/CUSTOMIZED CLASSES

Compusoft offers Individual & Customized training classes. The fees will be quoted depending on a cost-per-hour basis, and usually ranges from $25 to $175 per hour, plus $30 for each manual.

 

See Current Schedule

See Current Specials

Register for Class

Microsoft Access 2007 Training in Houston

Microsoft Access 2003 Training in Houston

Microsoft Access computer classes offerings in Houston

Copyright © Compusoft Training Center, Inc. 1990 - 2009 - All Rights Reserved

 

Calendar

September 2010 October 2010
Su Mo Tu We Th Fr Sa
Week 35 1 2 3 4
Week 36 5 6 7 8 9 10 11
Week 37 12 13 14 15 16 17 18
Week 38 19 20 21 22 23 24 25
Week 39 26 27 28 29 30