Home >> Courses >> Computer Application Training Courses >> Business & Office Applications Training
Please note: All classes run from 9:00 AM to 4:30 pm unless otherwise specified.

Access 2007 Training (Intermediate)

Course ID #: ACC2K7L2
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2007: Basic. (More Details Below)
Choose a Course Date:  
    Price per seat $225.00
    Qty
    Seats Available: 0

    		  
    • Additional Course Details
      • Description:
        This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2007: Basic. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Comes with CertBlaster exam prep software (download). Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.

        Outline:
        • 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

        --------------

        Please note that the material taught at some locations may differ slightly from the outline shown above. Please contact your local ExecuTrain office if you have any questions about specific course content.

    Other courses that may be of interest:
    Click the "Details" button to check availability or special pricing options.

    $225.00
       
    ACC2K3L1 - Access 2003 Training (Basic)
    This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches the basic functions and features of Access 2003. (More Details Below)
    $225.00
       
    ACC2K3L2 - Access 2003 Training (Intermediate)
    This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches intermediate-level features and functions of Access 2003. (More Details Below)
    $225.00
       
    ACC2K3L3 - Access 2003 Training (Advanced)
    This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches advanced-level functions and features of Access 2003. (More Details Below)
    $225.00
       
    ACC2K3L4 - Access 2003 Training (Level 4)
    In previous levels, you were introduced to advanced topics that dealt with local database management. In this course, you will learn remote database management, how to exchange data with XML and other type applications (More Details Below)
    $225.00
       
    ACC2K7L1 - Access 2007 Training (Basic)
    This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, covers the basic functions and features of Access 2007. (More Details Below)
    $225.00
       
    ACC2K7L3 - Access 2007 Training (Advanced)
    This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2007: Intermediate. (More Details Below)
    $179.00
       
    A&WLLC - Access And Word: Produce Letters, Lists, And Catalogs (1/2 Day)
    Students will learn efficient ways to use Access and Word together to create form letters, lists, and catalogs. (More Details Below)
    $99.00
       
    MIG2ACC07 - Migrating to Access 2007 (90 Minutes)
    This 90-minute ExecuTrain Express course is designed for current Access users who are migrating to Access 2007. Class participants will learn how to take advantage of new tools...(More Details Below)
    $99.00
       
    MIG2OFF07 - Migrating to Office 2007 (90 Minutes)
    This 90-minute ExecuTrain Express course is designed for current Microsoft Office users who are migrating to Office 2007.
    $225.00
       
    OFF2K7NF - Microsoft Office 2007: New Features training
    Microsoft Office 2007: New Features comes with enhanced features for improving the management, organization, and distribution of your data. In this course, you will work with the new and increased features in Office 2007.

    Customer Reviews


    Write A Review