Onsite Microsoft Access 2007 Training Classes

onsite computer training

CBT Planet's onsite Access 2007 training is the perfect way to get the entire team up to speed with Access. This Microsoft Access 2007 class is led by an instructor right at your location. This course is especially cost effective when you have a group of six or more who need the training.

Students learn from a knowledgeable, experienced instructor while you enjoy the savings. In addition, the onsite Access 2007 training course keeps everyone learning the same material for optimal results afterwards. With the Microsoft Access course, your employees don't need to travel or stay in distant cities overnight. Instead, they learn at the jobsite. You have access to the team throughout the onsite Microsoft Access 2007 training should a crisis arise.

The Microsoft Access class is popular with employees, too. Not only do they learn new skills, onsite Access 2007 training lets them put these skills to work immediately.

Common Questions:
   
Maximum number of student allowed: 15
Number of hours: 8 hours per level. We start from 9 am to 5 pm.
Books Included: Yes. Each student will receive their own course manual.
Online Training Included: Optional. Receive 50% off the list price when bundled.
Computers Included: No - Customer must provide computers and software.
Instructor Background: Minimum 6 years experience in the field.
Price: Call 1-866-718-7246
 
Access 2003 Outline:
 

Access 2007 Basic - 2 days

Table Of Contents:
Unit 1: Getting started
Topic A: Database concepts
Topic B: Exploring the Access environment
Topic C: Getting help

Unit 2: Databases and tables
Topic A: Planning and designing databases
Topic B: Exploring tables
Topic C: Creating tables

Unit 3: Fields and records
Topic A: Changing the design of a table
Topic B: Finding and editing records
Topic C: Organizing records

Unit 4: Data entry rules
Topic A: Setting field properties
Topic B: Working with input masks
Topic C: Setting validation rules

Unit 5: Basic queries
Topic A: Creating and using queries
Topic B: Modifying query results and queries
Topic C: Performing operations in queries

Unit 6: Using forms
Topic A: Creating forms
Topic B: Using Design view
Topic C: Sorting and filtering records

Unit 7: Working with reports
Topic A: Reports
Topic B: Modifying and printing reports

Access 2007 Intermediate - 1 day

Table Of Contents:
Unit 1: Relational databases
Topic A: Database normalization
Topic B: Relating tables
Topic C: Implementing referential integrity

Unit 2: Related tables
Topic A: Lookup fields
Topic B: Modifying lookup fields
Topic C: Subdatasheets

Unit 3: Complex queries
Topic A: Joining tables in queries
Topic B: Calculated fields
Topic C: Summarizing and grouping values

Unit 4: Advanced form design
Topic A: Adding unbound controls
Topic B: Adding Graphics
Topic C: Adding calculated values
Topic D: Adding combo boxes
Topic E: Advanced form types

Unit 5: Reports and printing
Topic A: Customized headers and footers
Topic B: Adding calculated values
Topic C: Printing
Topic D: Labels

Unit 6: Charts
Topic A: Charts in forms
Topic B: Charts in reports

Unit 7: PivotTables and PivotCharts
Topic A: PivotTables
Topic B: Modifying PivotTables
Topic C: PivotCharts
Topic D: PivotTable forms

Access 2007 Advance - 1 day

Table Of Contents:
Unit 1: Querying with SQL
Topic A: SQL and Access
Topic B: Writing SQL statements
Topic C: Attaching SQL queries to controls

Unit 2: Advanced queries
Topic A: Creating crosstab queries
Topic B: Creating parameter queries
Topic C: Using action queries

Unit 3: Macros
Topic A: Creating, running, and modifying macros
Topic B: Attaching macros to the events of database objects

Unit 4: Advanced macros
Topic A: Creating macros to provide user interaction
Topic B: Creating macros that require user input
Topic C: Creating the AutoKeys and AutoExec macros
Topic D: Creating macros for data transfer

Unit 5: Importing, exporting, and linking
Topic A: Importing objects
Topic B: Exporting objects
Topic C: Interacting with XML documents
Topic D: Linking Access objects
Topic E: Working with Windows SharePoint Services

Unit 6: Database management
Topic A: Optimizing resources
Topic B: Protecting databases
Topic C: Setting options and properties

Unit 7: Internet integration
Topic A: Hyperlink fields
Topic B: Working with Outlook 2007

 

If your city is not listed, please contact us and we can try to accomodate your onsite corporate training needs.

  • Abilene, TX
  • Albany, NY
  • Albany, GA
  • Albuquerque, NM
  • Alexandria, LA
  • Allentown, PA
  • Altoona, PA
  • Amarillo, TX
  • Anchorage, AK
  • Anniston, AL
  • Appleton, WI
  • Asheville, NC
  • Athens, GA
  • Atlanta, GA
  • Atlantic City, NJ
  • Auburn, AL
  • Augusta, GA
  • Austin, TX
  • Bakersfield, CA
  • Baltimore, MD
  • Bangor, ME
  • Barnstable, MA
  • Baton Rouge, LA
  • Beaumont, TX
  • Bellingham, WA
  • Benton Harbor, MI
  • Billings, MT
  • Biloxi, MS
  • Binghamton, NY
  • Birmingham, AL
  • Bismarck, ND
  • Bloomington, IL
  • Bloomington, IN
  • Boise, RI
  • Boise City, ID
  • Boston, MA
  • Brownsville, TX
  • Bryan, TX
  • Buffalo, NY
  • Burlington, VT
  • Canton, OH
  • Casper, WY
  • Cedar Rapids, IA
  • Champaign, IL
  • Charleston, SC
  • Charlotte, NC
  • Charlottesville, VA
  • Chattanooga, TN
  • Cheyenne, WY
  • Chicago, IL
  • Chico, CA
  • Cincinnati, OH
  • Clarksville, TN
  • Clayton, NC
  • Cleveland, OH
  • Colorado Springs, CO
  • Columbia, MO
  • Columbia, SC
  • Columbus, GA
  • Columbus, OH
  • Corpus Christi, TX
  • Corvallis, OR
  • Cumberland, MD
  • Dallas, TX
  • Danville, VA
  • Davenport, IA
  • Dayton, OH
  • Daytona Beach, FL
  • Decatur, AL
  • Decatur, IL
  • Denver, CO
  • Des Moines, IA
  • Detroit, MI
  • Dothan, AL
  • Dover, DE
  • Dubuque, IA
  • Duluth, MN
  • Eau Claire, WI
  • El Paso, TX
  • Elkhart, IN
  • Elmira, NY
  • El Paso, TX
  • Enid, OK
  • Erie, PA
  • Eugene, OR
  • Evansville, IN
  • Fairbanks, AK
  • Fargo, ND
  • Fayetteville, AR
  • Fayetteville, NC
  • Flagstaff, AZ
  • Florence, AL
  • Florence, SC
  • Fort Collins, CO
  • Fort Myers, FL
  • Fort Pierce, FL
  • Fort Smith, AR
  • Fort Walton Beach, FL
  • Fort Wayne, IN
  • Fresno, CA
  • Gadsden, AL
  • Gainesville, FL
  • Galveston, TX
  • Glens Falls, NY
  • Goldsboro, NC
  • Grand Forks, ND
  • Grand Junction, CO
  • Grand Rapids, MI
  • Great Falls, MT
  • Green Bay, WI
  • Greensboro, NC
  • Greenville, NC
  • Greenville, SC
  • Harrisburg, PA
  • Hartford, CT
  • Hattiesburg, MS
  • Hickory, NC
  • Honolulu, HI
  • Houma, LA
  • Houston, TX
  • Huntington, WV
  • Huntsville, AL
  • Indianapolis, IN
  • Iowa City, IA
  • Jackson, MI
  • Jackson, MS
  • Jackson, TN
  • Jacksonville, FL
  • Jamestown, NY
  • Janesville, WI
  • Johnson City, TN
  • Johnstown, PA
  • Jonesboro, AR
  • Joplin, MO
  • Kalamazoo, MI
  • Kansas City, MO
  • Key West, FL
  • Killeen, TX
  • Knoxville, TN
  • Kokomo, IN
  • La Crosse, WI
  • Lafayette, IN
  • Lafayette, LA
  • Lake Charles, LA
  • Lakeland, FL
  • Lancaster, PA
  • Lansing, MI
  • Laredo, TX
  • Las Cruces, NM
  • Las Vegas, NV
  • Lawrence, KS
  • Lawton, OK
  • Lewiston, ME
  • Lexington, KY
  • Lima, OH
  • Lincoln, NE
  • Little Rock, AR
  • Longview, TX
  • Los Angeles, CA
  • Louisville, KY
  • Lubbock, TX
  • Lynchburg, VA
  • Macon, GA
  • Madison, WI
  • Mansfield, OH
  • McAllen, TX
  • Medford, OR
  • Melbourne, FL
  • Memphis, TN
  • Merced, CA
  • Miami, FL
  • Milwaukee, WI
  • Minneapolis, MN
  • Missoula, MT
  • Mobile, AL
  • Modesto, CA
  • Monroe, LA
  • Montgomery, AL
  • Muncie, IN
  • Myrtle Beach, SC
  • Naples, FL
  • Nashville, TN
  • New London, CT
  • New Orleans, LA
  • New York, NY
  • Newark, NJ
  • Norfolk, VA
  • Ocala, FL
  • Odessa, TX
  • Oklahoma City, OK
  • Olympia, WA
  • Omaha, NE
  • Orlando, FL
  • Owensboro, KY
  • Panama City, FL
  • Parkersburg, WV
  • Pensacola, FL
  • Peoria, IL
  • Philadelphia, PA
  • Phoenix, AZ
  • Pine Bluff, AR
  • Pittsburgh, PA
  • Pittsfield, MA
  • Pocatello, ID
  • Portland, ME
  • Providence, RI
  • Provo, UT
  • Pueblo, CO
  • Punta Gorda, FL
  • Raleigh, NC
  • Rapid City, SD
  • Reading, PA
  • Redding, CA
  • Reno, NV
  • Richland, WA
  • Richmond, VA
  • Roanoke, VA
  • Rochester, MN
  • Rockford, IL
  • Rocky Mount, NC
  • Roswell, NM
  • Sacramento, CA
  • Saginaw, MI
  • Salem, OR
  • Salinas, CA
  • Salt Lake City, UT
  • San Angelo, TX
  • San Antonio, TX
  • San Diego, CA
  • San Francisco, CA
  • San Luis Obispo, CA
  • Santa Barbara, CA
  • Santa Fe, NM
  • Sarasota, FL
  • Savannah, GA
  • Scranton, PA
  • Seattle, WA
  • Sharon, PA
  • Sheboygan, WI
  • Sherman, TX
  • Shreveport, LA
  • Sioux City, IA
  • Sioux Falls, SD
  • South Bend, IN
  • Spokane, WA
  • Springfield, IL
  • St. Cloud, MN
  • St. Joseph, MO
  • St. Louis, MO
  • State College, PA
  • Steubenville, OH
  • Stockton, CA
  • Sumter, SC
  • Syracuse, NY
  • Tallahassee, FL
  • Tampa, FL
  • Terre Haute, IN
  • Texarkana, TX
  • Toledo, OH
  • Topeka, KS
  • Tucson, AZ
  • Tulsa, OK
  • Tuscaloosa, AL
  • Tyler, TX
  • Utica, NY
  • Vero Beach, FL
  • Victoria, TX
  • Visalia, CA
  • Waco, TX
  • Washington, DC
  • Waterloo, IA
  • Wausau, WI
  • West Palm Beach, FL
  • Wheeling, WV
  • Wichita, KS
  • Wichita Falls, TX
  • Williamsport, PA
  • Wilmington, NC
  • Yakima, WA
  • York, PA
  • Youngstown, OH
  • Yuba City, CA
  • Yuma, AZ