Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

MS Access 2007 Intermediate by rjj75795


									                                  (615) 254-0581                          1(866) 577-2902
    Office Training           Access 2007: Intermediate
Duration: 1 day               About this Course  
                              You have the basic skills needed to work with Microsoft® Office Access™ 2007 databases, includ‐
                              ing creating and working with Access tables, relationships, queries, forms, and reports. But so 
Objective:                    far, you have been focusing only on essential database user skills. In this course, you will con‐
                              sider how to maintain data consistency, how to customize database components, and how to 
You will maintain data        share Access data with other applications.  
consistency and integrity;     
improve queries, forms, 
and reports; and also in‐     Audience Profile  
tegrate Microsoft® Office     Microsoft Office Access 2007: Level 2 is designed for individuals whose job responsibilities in‐
Access™ 2007 with other       clude maintaining data integrity; handling complex queries, forms, and reports; and sharing data 
applications.                 between Access and other applications. This course is also a prerequisite to taking more ad‐
                              vanced courses in Access 2007. Individuals who want to pursue Microsoft Certified Application 
                              Specialist certification in Microsoft Office Access 2007 can also take this course. 

                              At Course Completion students will be able to:  (Course objectives) 
Previously attended Ac‐        

cess 2007 Introduction or     •      Modify the design and field properties of a table to streamline data entry and
have equivalent working              maintain data integrity.
knowledge                     •      Retrieve data from tables using joins.
                              •      Create flexible queries to display specified records, allow for user-determined
                                     query criteria, and modify data using queries.
Additional course             •      Enhance the capabilities of a form by grouping form controls and making
recommendations:                     other aesthetic improvements to make forms work more efficiently and intui-
                                     tively for the user.
• Access 2007 Advanced        •      Customize reports to organize the displayed information and produce specific
• Crystal Reports                    print layouts.
                              •      Share data across different applications.
• SQL Querying 

                              LPS Integration                                                        Metro Center
All classes taught at our 
Metro Center facility in 
                              230 Great Circle Road, Suite 218
Nashville .                   Nashville, Tennessee 37228

                              Main: (615) 254-0581 Fax: (615) 349-9009
Class hours: 9:00‐5:00 
Page 2         Access 2007 Intermediate

Course Outline

Lesson 1: Controlling Data Entry
         •   Restrict Data Entry Using Field Properties
         •   Establish a Pattern for Entering Field Values
         •   Create a List of Values for a Field
Lesson 2: Joining Tables
         •   Create Query Joins
         •   Join Unrelated Tables
         •   Relate Data Within a Table
Lesson 3: Creating Flexible Queries
   •     Set Select Query Properties
   •     Create Parameter Queries
   •     Create Action Queries
Lesson 4: Improving Forms
         •   Design a Form Layout
         •   Enhance the Appearance of a Form
         •   Restrict Data Entry in Forms
         •   Add a Command Button to a Form
         •   Create a Subform
Lesson 5: Customizing Reports
         •   Organize Report Information
         •   Format the Report
         •   Set Report Control Properties
         •   Control Report Pagination
         •   Summarize Report Information
         •   Add a Sub report to an Existing Report
         •   Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
         •   Import Data into Access
         •   Export Data
         •   Analyze Access Data in Excel
         •   Export Data to a Text File
         •   Merge Access Data with a Word Document

To top