Access 2007 - Introduction
  • Access 2007 - Introduction

    $30.00
$30.00

Product Overview

This vBook will teach you the basics of Microsoft Access 2007. The primary focus it getting acquainted in how to create the basic database objects within the interface and how to use these objects effectively.

Authored By Timothy J. Miles


Preview

Product Description

This vBook will teach you the basics of Microsoft Access 2007. The primary focus it getting acquainted in how to create the basic database objects within the interface and how to use these objects effectively.



Table of Contents:



  • Introduction  

  • Access Overview

    • Opening Access

    • Using a Template

    • Viewing the Quick Access Toolbar

    • Working with the Navigation Pane

    • Viewing the Status Bar



  • Opening an Existing Database

    • Viewing the Start-Up Form

    • Understanding Tables

    • Explaining the ID Field

    • Using the Quick-Search

    • Using the Field AutoFilter

    • Changing the Table Layout



  • Creating a Table in Datasheet View

    • Using the 'Add New Field' feature

    • Reviewing the Data Types

    • Using a Lookup Column

    • Saving your Table

    • Deleting a Field



  • Creating a Table in Design View

    • Using the Design View

    • Viewing all Data Types

    • Understanding the Field Properties

    • Using an Input Mask

    • Understanding Indexes



  • Using Find and Replace

    • Using Access Wildcards

    • Replacing Data

    • Deleting a Record

    • Hiding and Showing Fields

    • Freezing and Unfreezing Columns

    • Setting the Row Height



  • Working with Queries

    • Introducing the Select Query

    • Using the Query Wizard to Create a New Query

    • Understanding the Resulting Dataset

    • Working with the Query Tools, Design Ribbon for Query

    • Working in the Query Table View and QBE Grid

    • Adding Criteria

    • Creating a Query from Scratch

    • Using Criteria for your Queries



  • Working with Forms

    • Introducing the Form

    • Understand the different types of Forms

    • Using the Form Wizard

    • Working in the Form Design View

    • Understanding Form Controls

    • Understanding Properties

    • Understanding the Dialog Box and the Pop-up Form

    • Changing Properties for a Text Box

    • Modifying the Order of Controls



  • Working with Simple Reports

    • Creating Labels

    • Using the Report Wizard

    • Using Layout View

    • Using Design View

    • Understanding the Report Header and Footer

    • Grouping and Sorting your Reports

    • Creating a Report From a Query

    • Summary