Career Training >> Business Skills Training >> Microsoft Office Training >> Microsoft Access Training >> Access 2007 Level 2 Training Seminar
Course ID: 14434 | Course Duration: 2 Days
Course Dates: 
 
Career Training
 

Access 2007 Level 2 Training Class

Course ID: 14434
 
 
Course Snapshot View Dates Add To My Courses Get More Information About This Course Register Online Register By Fax On-Site Training View Printer Friendly Version
 
     
 

Access 2007 Level 2 Training Seminar

In this course, student will extend their knowledge into some of the more specialized and advanced capabilities.

Upon successful completion of this course, students will be able to: - restructure the data into tables to ensure data dependency and minimize redundancy. - write advanced queries to analyze and summarize data. - create and revise Access macros. - display data more effectively in a form. - customize reports by using various advanced Access features to improve the effectiveness of the reports. - maintain databases using specialized tools provided by Access.

 
     
     
  Course Details  
     
     
  Agenda  
 
Lesson 1: Structuring Existing Data
Analyze Tables
Create a Junction Table
Improve Table Structure
Lesson 2: 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 3: 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 4: Making Effective Use of Forms
Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data on a Form

Lesson 5: Making Reports More Effective
Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot
Lesson 6: Maintaining an Access Database
Link Tables to External Data Sources
Manage a Database
Document a Database
Analyze the Performance of a Database
 
     
     
  Audience  
  This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft?? Office Specialist Certification for Microsoft Office Access 2007, and it is a prerequisite to taking more advanced courses in Microsoft Office Access 2007.
 
     
  Pre-requisites  
  Access 2007 Level 1  
     
     
 
On-Site Training Bring this Access 2007 Level 2 training class in-house at your facility. Request More Information Request More Information On Access 2007 Level 2
 
Career Training
 
 
Career Training
  Access 2007 Level 2 Training Course Dates and Locations  
     
  Course ID: 14434 | Course Duration: 2 Days  
     
  Locations:  
     
   User Incentive For Registering on TrainUp.com! Gift card when you register today!  
     
 
Start Date Price      Location/Event Details Register Online Request
More Info
  Print/Fax
Register
12/08/2008 $650.00    Waltham, MA Register Online For The 12/08/2008 Event Request More Information   Register By Fax For The 12/08/2008 Event
12/08/2008 $530.00    Tempe, AZ Register Online For The 12/08/2008 Event Request More Information   Register By Fax For The 12/08/2008 Event
12/10/2008 $450.00    Jacksonville, FL Register Online For The 12/10/2008 Event Request More Information   Register By Fax For The 12/10/2008 Event
12/11/2008 $500.00    San Antonio, TX Register Online For The 12/11/2008 Event Request More Information   Register By Fax For The 12/11/2008 Event
12/11/2008 $500.00    Fort Worth, TX Register Online For The 12/11/2008 Event Request More Information   Register By Fax For The 12/11/2008 Event
12/15/2008 $490.00    Dublin, CA Register Online For The 12/15/2008 Event Request More Information   Register By Fax For The 12/15/2008 Event
12/15/2008 $249.00    Orlando, FL Register Online For The 12/15/2008 Event Request More Information   Register By Fax For The 12/15/2008 Event
12/16/2008 $490.00    Tampa, FL Register Online For The 12/16/2008 Event Request More Information   Register By Fax For The 12/16/2008 Event
12/16/2008 $470.00    Colorado Springs, CO Register Online For The 12/16/2008 Event Request More Information   Register By Fax For The 12/16/2008 Event
12/18/2008 $490.00    San Francisco, CA Register Online For The 12/18/2008 Event Request More Information   Register By Fax For The 12/18/2008 Event
12/18/2008 $658.00    Houston, TX Register Online For The 12/18/2008 Event Request More Information   Register By Fax For The 12/18/2008 Event
12/18/2008 $500.00    Reno, NV Register Online For The 12/18/2008 Event Request More Information   Register By Fax For The 12/18/2008 Event
12/19/2008 $500.00    Tulsa, OK Register Online For The 12/19/2008 Event Request More Information   Register By Fax For The 12/19/2008 Event
12/22/2008 $245.00    New York City, NY Register Online For The 12/22/2008 Event Request More Information   Register By Fax For The 12/22/2008 Event
12/22/2008 $490.00    Dublin, CA Register Online For The 12/22/2008 Event Request More Information   Register By Fax For The 12/22/2008 Event
01/08/2009 $500.00    Dallas, TX Register Online For The 01/08/2009 Event Request More Information   Register By Fax For The 01/08/2009 Event
01/08/2009 $650.00    Waltham, MA Register Online For The 01/08/2009 Event Request More Information   Register By Fax For The 01/08/2009 Event
01/29/2009 $500.00    San Antonio, TX Register Online For The 01/29/2009 Event Request More Information   Register By Fax For The 01/29/2009 Event
02/03/2009 $500.00    Fort Worth, TX Register Online For The 02/03/2009 Event Request More Information   Register By Fax For The 02/03/2009 Event
02/04/2009 $225.00    Pensacola, FL Register Online For The 02/04/2009 Event Request More Information   Register By Fax For The 02/04/2009 Event
02/10/2009 $500.00    Dallas, TX Register Online For The 02/10/2009 Event Request More Information   Register By Fax For The 02/10/2009 Event
02/16/2009 $650.00    Boston, MA Register Online For The 02/16/2009 Event Request More Information   Register By Fax For The 02/16/2009 Event
02/23/2009 $500.00    San Antonio, TX Register Online For The 02/23/2009 Event Request More Information   Register By Fax For The 02/23/2009 Event
03/02/2009 $500.00    Dallas, TX Register Online For The 03/02/2009 Event Request More Information   Register By Fax For The 03/02/2009 Event
03/19/2009 $500.00    Fort Worth, TX Register Online For The 03/19/2009 Event Request More Information   Register By Fax For The 03/19/2009 Event
03/23/2009 $500.00    San Antonio, TX Register Online For The 03/23/2009 Event Request More Information   Register By Fax For The 03/23/2009 Event
03/26/2009 $650.00    Waltham, MA Register Online For The 03/26/2009 Event Request More Information   Register By Fax For The 03/26/2009 Event
04/06/2009 $500.00    Dallas, TX Register Online For The 04/06/2009 Event Request More Information   Register By Fax For The 04/06/2009 Event
04/21/2009 $500.00    San Antonio, TX Register Online For The 04/21/2009 Event Request More Information   Register By Fax For The 04/21/2009 Event
04/21/2009 $500.00    Fort Worth, TX Register Online For The 04/21/2009 Event Request More Information   Register By Fax For The 04/21/2009 Event
05/22/2009 $500.00    Dallas, TX Register Online For The 05/22/2009 Event Request More Information   Register By Fax For The 05/22/2009 Event
10/30/3008 $658.00    Houston, TX Register Online For The 10/30/3008 Event Request More Information   Register By Fax For The 10/30/3008 Event
 
     
 
On-Site Training Bring this Access 2007 Level 2 training class in-house at your facility. Request More Information Request More Information On Access 2007 Level 2
 
Career Training
 
 
Career Training
  Browse Our Catalog  
     
  Select a market segment to view more courses

 
     
  Or, select a category to view more Business Skills courses

 
     
  Browse By Category Browse By Category

Browse By Location Browse By Location

Browse New Courses Browse New Courses

 
     
Career Training
 
   
 
 
Career Training
   
Career Training
 
 
 
 






Site Map -- Top Training Courses -- Request On-Site Training

Find Jobs -- Degree Programs -- Training Providers -- Resource Center -- About Us -- Contact us

TrainUp.com Your Career Training Marketplace