This event has ended

Access 2007 Level 1 Training (2 day class)

Methode Electronics

Thursday, January 23, 2014 at 9:00 AM - Friday, January 24, 2014 at 5:00 PM (CST)

Harwood Heights, IL

Access 2007 Level 1 Training (2 day class)

Registration Information

Type Remaining End Quantity
Seat 5 Registrations Ended Free  

Share Access 2007 Level 1 Training (2 day class)

Event Details

Outline

Lesson 1: Exploring the Microsoft®

  • Office Access™ 2007
  • Environment
  • Examine Database Concepts
  • Explore the User Interface
  • Explore the Ribbon
  • Customize the Access Environment
  • Obtain Help
  • Use an Existing Access Database

Lesson 2: Designing a Database

  • Describe the Relational Database
  • Design Process
  • Define Database Purpose
  • Review Existing Data
  • Determine Fields
  • Group Fields into Tables
  • Normalize Data
  • Designate Primary and Foreign Keys
  • Determine Table Relationships

Lesson 3: Building a Database

  • Create a New Database
  • Create a Table
  • Manage Tables
  • Create a Table Relationship
  • Save a Database as a Previous Version

Lesson 4: Managing Data in a Table

  • Modify Table Data
  • Sort Records
  • Work with Subdatasheets

Lesson 5: Querying a Database

  • Filter Records
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

  • View Data Using an Access Form
  • Create a Form
  • Modify the Design of a Form

Lesson 7: Generating Reports

  • View an Access Report
  • Create a Report
  • Add a Custom Calculated Field to a Report
  • Format the Controls in a Report
  • Apply an AutoFormat to a Report
  • Prepare a Report for Print

Lesson 8: 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 9: Joining Tables

  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within a Table

Lesson 10: Creating Flexible Queries

  • Set Select Query Properties
  • Create Parameter Queries
  • Create Action Queries

Lesson 11: 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 12: Customizing Reports

  • Organize Report Information
  • Format the Report
  • Set Report Control Properties
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report

Lesson 13: 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
Have questions about Access 2007 Level 1 Training (2 day class)? Contact Methode Electronics
Attendee List Sort by: Date | First Name | Last Name
Show More

When & Where


Methode Corporate Headquarters
7401 W Wilson Ave
Harwood Heights, IL 60706

Thursday, January 23, 2014 at 9:00 AM - Friday, January 24, 2014 at 5:00 PM (CST)


  Add to my calendar

Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.