Access 2007 - Beginner

Price
$39.00
Duration
2 Hours, 35 Minutes
Delivery Method
LearnNow On Demand

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. 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 certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

 

Purchase This On Demand Title or a LearnNow On Demand subscription

Access 2007 - Beginner
  Buy Now $39.00 Purchase this course for 12 months.
  Buy Now $99.00 Purchase this course and hundreds of others with our LearnNow On Demand 12-month subscription.

Course Objectives

    Introducing Access 2007, Opening An Existing Database, Creating a New Table Using Datasheet View, Adding Records to a Table, Finding Data, An Overview on Queries, Forms, Reports, Create A New Table In Design View

Agenda

1 - Introduction
  • Introduction
2 - Introducing Access 2007
  • Starting Access
  • Navigating the Main Screen
  • Using the Quick Access Toolbar and Ribbon
  • Using the Navigation Pane
  • Navigating in the Document Window
3 - Opening An Existing Database
  • Opening a Table
  • Navigating a Table
  • Using Quick Search
  • Using Quick Filter
4 - Creating a New Table Using Datasheet View
  • Adding Fields
  • Changing the Data Type
  • Adding a Lookup Field
  • Deleting a Field
5 - Create A New Table In Design View
  • Understanding The Design View
  • Setting Input Masks
  • Using The Lookup Tab
  • Indexing A Table 
6 - Adding Records to a Table
  • Adding a Record
  • Using Zoom Mode
  • Using Shortcut Keys
  • Filtering Data
7 - Finding Data
  • Using the Find Dialog Box
  • Using Replace
  • Deleting Records
  • Changing Table Appearance
8 - An Overview on Queries
  • Understanding Query Types
  • Using the Query Wizard
  • Using the Query Design View
  • Using the QBE Grid
  • Entering Criteria
  • Creating a Query Manually
  • Using Logical Operators in Criteria
  • Using Wildcards in Criteria
9 - Forms
  • Understanding Forms
  • Creating a New Form
  • Using the Form Design Window
  • Selecting, Moving, and Resizing Controls
10 - Reports
  • Understanding Report Design Steps
  • Creating a Report
  • Modifying Controls in a Report
  • Basing a Report on a Query
  • Adjusting and Printing a Report
11 - Conclusion
  • Course Recap