Home >> Courses
Please note: All classes run from 9:00 AM to 4:30 pm unless otherwise specified.

Access 2007 Training (Advanced)

Course ID #: ACC2K7L3
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)
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: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data. 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 7certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.

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

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

        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
       
    ACC2K7L2 - Access 2007 Training (Intermediate)
    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)
    $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