Access 2007

Access 2007 - Level 1

Course length: 6 hours

Prerequisites:
Windows – Level 1 or equivalent knowledge

What’s in Access 2007 – Level 1
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2007 relational database application.

Objectives
Upon successful completion of this course, students will be able to:

  • Examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
  • Design a simple database.
  • Build a new database with related tables.
  • Manage data in a table.
  • Query a database using different methods.
  • Design forms.
  • Generate reports.


Course Content

Lesson 1: Exploring the Access 2007 Environment

  • Topic 1A: Examine Database Concepts
  • Topic 1B: Explore the User Interface
  • Topic 1C: Use an Existing Access Database
  • Topic 1D: Customize the Access Environment
  • Topic 1E: Obtain Help


Lesson 2: Designing a Database

  • Topic 2A: Describe the Relational Database Design Process
  • Topic 2B: Define Database Purpose
  • Topic 2C: Review Existing Data
  • Topic 2D: Determine Fields
  • Topic 2E: Group Fields into Tables
  • Topic 2F: Normalize Data
  • Topic 2G: Designate Primary and Foreign Keys
  • Topic 2H: Determine Table Relationships


Lesson 3: Building a Database

  • Topic 3A: Create a New Database
  • Topic 3B: Create a Table
  • Topic 3C: Manage Tables
  • Topic 3D: Create a Table Relationship
  • Topic 3E: Save a Database as a Previous Version


Lesson 4: Managing Data in a Table

  • Topic 4A: Modify Table Data
  • Topic 4B: Sort Records
  • Topic 4C: Work with Subdatasheets


Lesson 5: Querying a Database

  • Topic 5A: Filter Records
  • Topic 5B: Create a Query
  • Topic 5C: Add Criteria to a Query
  • Topic 5D: Add a Calculated Field to a Query
  • Topic 5E: Perform Calculations on a Record Grouping


Lesson 6: Designing Forms

  • Topic 6A: View Data Using an Access Form
  • Topic 6B: Create a Form
  • Topic 6C: Modify the Design of a Form


Lesson 7: Generating Reports

  • Topic 7A: View an Access Report
  • Topic 7B: Create a Report
  • Topic 7C: Add a Custom Calculated Field to a Report
  • Topic 7D: Format the Controls in a Report
  • Topic 7E: Apply an AutoFormat Style to a Report
  • Topic 7F: Prepare a Report for Print


    (top)


Access 2007 - Level 2

Course length: 7 hours

Prerequisites: Access 2007 – Level 1 or equivalent knowledge

What’s in Access 2007 – Level 2?
You have the basic skills needed to work with Access 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Objectives
Upon successful completion of this course, you will be able to:

  • Modify the design and field properties of a table to streamline data entry and maintain data integrity.
  • Retrieve data from tables using joins.
  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
  • Enhance the capabilities of a form by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user.
  • Customize reports to organize the displayed information and produce specific print layouts.
  • Share data across different applications.


Course Content

Lesson 1: Controlling Data Entry

  • Topic 1A: Restrict Data Entry Using Field Properties
  • Topic 1B: Establish a Pattern for Entering Field Values
  • Topic 1C: Create a List of Values for a Field


Lesson 2: Joining Tables

  • Topic 2A: Create Query Joins
  • Topic 2B: Join Unrelated Tables
  • Topic 2C: Relate Data Within a Table


Lesson 3: Creating Flexible Queries

  • Topic 3A: Set Select Query Properties
  • Topic 3B: Create Parameter Queries
  • Topic 3C: Create Action Queries


Lesson 4: Improving Forms

  • Topic 4A: Design a Form Layout
  • Topic 4B: Enhance the Appearance of a Form
  • Topic 4C: Restrict Data Entry in Forms
  • Topic 4D: Add a Command Button to a Form
  • Topic 4E: Create a Subform


Lesson 5: Customizing Reports

  • Topic 5A: Organize Report Information
  • Topic 5B: Format the Report
  • Topic 5C: Set Report Control Properties
  • Topic 5D: Control Report Pagination
  • Topic 5E: Summarize Report Information
  • Topic 5F: Add a Subreport to an Existing Report
  • Topic 5G: Create a Mailing Label Report


Lesson 6: Sharing Data Across Applications

  • Topic 6A: Import Data into Access
  • Topic 6B: Export Data
  • Topic 6C: Analyze Access Data in Excel
  • Topic 6D: Export Data to a Text File
  • Topic 6E: Merge Access Data with a Word Document


    (top)


Access 2007 - Level 3

Course length: 6 hours

Prerequisites: Access 2007 – Level 2 or equivalent knowledge

What’s in Access 2007 – Level 3
Your training in and use of Access 2007 has provided you with a solid foundation in the basic and intermediate skills of working in Access 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Objectives
Upon successful completion of this course, students will be able to:

  • Restructure data into appropriate tables to ensure data dependency and minimize redundancy.
  • Write advanced queries to analyze and summarize data.
  • Create and revise Access 2007 macros.
  • Display data more effectively in a form.
  • Customize reports by using various Access 2007 features, making them more effective.
  • Maintain your database using tools provided by Access 2007.


Course Content

Lesson 1: Structuring Existing Data

  • Topic 1A: Analyze Tables
  • Topic 1B: Create a Junction Table
  • Topic 1C: Improve Table Structure


Lesson 2: Writing Advanced Queries

  • Topic 2A: Create Subqueries
  • Topic 2B: Create Unmatched and Duplicate Queries
  • Topic 2C: Group and Summarize Records Using Criteria
  • Topic 2D: Summarize Data Using a Crosstab Query
  • Topic 2E: Create a PivotTable and a PivotChart


Lesson 3: Simplifying Tasks with Macros

  • Topic 3A: Create a Macro
  • Topic 3B: Attach a Macro
  • Topic 3C: Restrict Records Using a Condition
  • Topic 3D: Validate Data Using a Macro
  • Topic 3E: Automate Data Entry Using a Macro


Lesson 4: Making Effective Use of Forms

  • Topic 4A: Display a Calendar on a Form
  • Topic 4B: Organize Information with Tab Pages
  • Topic 4C: Display a Summary of Data in a Form


Lesson 5: Making Reports More Effective

  • Topic 5A: Include a Chart in a Report
  • Topic 5B: Print Data in Columns
  • Topic 5C: Cancel Printing of a Blank Report
  • Topic 5D: Create a Report Snapshot


Lesson 6: Maintaining an Access Database

  • Topic 6A: Link Tables to External Data Sources
  • Topic 6B: Manage a Database
  • Topic 6C: Determine Object Dependency
  • Topic 6D: Document a Database
  • Topic 6E: Analyze the Performance of a Database


    (top)