GO! with Microsoft Access 2007, Brief

by Gaskin, Shelley; Marks, Suzanne

• ISBN13: 9780132448161
• ISBN10: 0132448165
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2007-05-16
• Publisher: Prentice Hall

Summary

The primary goal ofGO! Series: Microsoft Access 2007 Brief,1/eis to teach Microsoft Access 2007 quickly and easily, with an approach that is based on clearly-defined projects. A key feature of the book is the use of Microsoft procedural syntax: steps begin withwherethe action is to take place, followed by the action itself. This book contains a CD-ROM that provides users with the skills to solve business problems using the computer as a tool.The Brief edition covers the following topics: getting started with Access databases and tables; forms, filters, and reports; sorts and queries.An efficient and handy guide for anyone interested in a project-based introduction to Microsoft Access 2007.

Author Biography

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois   University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.

Table of Contents

Getting Started with Access Databases and Tables

Create a New Blank Database

Start Access and Create a New Blank Database

Starting Access, Creating and Naming a Folder, and Creating a Database from a New Blank Database

Add Records to a Table

Adding Records to a Table

Rename Table Fields in Datasheet View

Renaming the Fields In a Table in Datasheet View

Changing the Data Type of a Field in Datasheet View

Modify the Design of a Table

Deleting a Field in Design View

Modifying a Field Size and Description in Design View

Setting a Primary Key and Saving a Table

Add a Second Table to a Database

Adding a Second Table to a Database

Adding Records to a Second Table

Print a Table

Adjusting Column Widths and Printing a Table

Create and Use a Query

Using the Simple Query Wizard to Create a Query

Create and Use a Form

Creating a Form

Create and Print a Report

Table of Contents provided by Publisher. All Rights Reserved.