Access 2007 Level 1: Introduction

IT@Emory computer education - Microsoft Office Training

You have worked with Microsoft Access 2003(or earlier) and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your databases. In this course you will be introduced to the new features available in Microsoft Office Access 2007. Using the new and enhanced features in Access, you will be able to create a highly functional database. Knowing the tools that allow you to accomplish these operations will greatly expand your Access capabilities.

Instructor: Donna Hobby, Certified Technical Trainer
2 session(s): Mon and Tue: Dec 14-15 / 9:00 am-4:00 pm
Registration fee: $395   CEUs: 0.6      

After this class, you will be able to

• Identify differences in the new interface and work more efficiently by using the Ribbon, Office Button, and Quick Access Toolbar
• Use contextual tabs on the Ribbon to make changes to tables, forms, reports, and other Access objects
• Create tables and insert fields, edit data types, and use the new Auto Calendar feature
• Query a database, create user forms, and generate reports using Wizards or design tools
• Use the new interface to perform familiar tasks from older versions of Access

What will be covered

• Section One: Getting Started
  Lesson 1.1: Starting Out
  Lesson 1.2: Using the Getting Started Window
  Lesson 1.3: The Trust Center
  Lesson 1.4: Getting Help

• Section Two: The New Interface
  Lesson 2.1: Using the Quick Access Toolbar
  Lesson 2.2: Basics of Tabs
  Lesson 2.3: The Home Tab
  Lesson 2.4: The Create Tab
  Lesson 2.5: The External Data Tab
  Lesson 2.6: The Database Tools Tab

• Section Three: Creating a Database
  Lesson 3.1: First Steps
  Lesson 3.2: About Records
  Lesson 3.3: Creating a Table
  Lesson 3.4: Formatting Text

• Section Four: Doing More With Your Database
  Lesson 4.1: Creating Forms
  Lesson 4.2: Creating Queries
  Lesson 4.3: Reports
  Lesson 4.4: Sorting and Filtering Data
  Lesson 4.5: Viewing Data
  Lesson 4.5: Printing a Database Object

• Section One: Working with Tables
  Lesson 1.1: Customizing Tables
  Lesson 1.2: Formatting Tables
  Lesson 1.3: Controlling Table Data Entry
  Lesson 1.4: Managing Table Data Entry

• Section Two Working with Forms
  Lesson 2.1: Basic Form Controls
  Lesson 2.2: Advanced Form Controls
  Lesson 2.3: Formatting Your Form
  Lesson 2.4: Formatting Controls
  Lesson 2.5: Formatting Records

• Section Three: Working with Reports
  Lesson 3.1: Organizing Report Data
  Lesson 3.2: Formatting Reports
  Lesson 3.3: Common Report Tasks

• Section Four: Working with Queries
  Lesson 4.1: Basic Queries
  Lesson 4.2: Multiple Table Queries
  Lesson 4.3: Advanced Queries
  Lesson 4.4: Management (Action) Queries

• Section Five: Advanced Data Management
  Lesson 5.1: Referential Integrity
  Lesson 5.2: Table Relationships
  Lesson 5.3: Switchboards

Share this class:   Digg    Facebook    Del.icio.us    Reddit    LinkedIn  

Search Results

Search again