Picture Yourself Learning Microsoft Access 2007

Picture Yourself Learning Microsoft Access 2007

by Faithe Wempen
     
 

ISBN-10: 1598638416

ISBN-13: 9781598638417

Pub. Date: 09/25/2008

Publisher: Cengage Learning

Get introduced to Access with Picture Yourself Learning Microsoft Access 2007! Perfect for those who are comfortable using Microsoft Office 2007, but new to Access, the database component of the Office suite of applications. You'll learn how to create and share databases, including tables, queries, forms, and reports. This book uses a visual approach to learning and…  See more details below

Overview

Get introduced to Access with Picture Yourself Learning Microsoft Access 2007! Perfect for those who are comfortable using Microsoft Office 2007, but new to Access, the database component of the Office suite of applications. You'll learn how to create and share databases, including tables, queries, forms, and reports. This book uses a visual approach to learning and is packed with clear, step-by-step instructions and full-color images that will walk you through the basics of all the capabilities of Access. If you've never used Access, you can start at the beginning with a tour of the interface and learn how to create a basic database file and input data into it. Once you're comfortable you'll discover different ways to create and edit tables with input masks, data validation, and lookups, and how to generate relationships between tables. You'll learn how to make, edit, and format user input forms for more user-friendly databases, and you'll find out how to make and run queries that filter and summarize your data into simple statistics. Finally you'll learn how to generate attractive and easy-to-read reports that you can share in electronic or print form. Picture Yourself Learning Microsoft Access 2007 will help you make the most out of your Access experience.

Read More

Product Details

ISBN-13:
9781598638417
Publisher:
Cengage Learning
Publication date:
09/25/2008
Edition description:
New Edition
Pages:
96
Product dimensions:
7.30(w) x 9.00(h) x 0.40(d)

Table of Contents


Introduction vi Chapter 1 Creating a Database 1 Getting Started with Access 2 Creating a Table in Datasheet View 5 Entering and Viewing Data in a Datasheet 9 Chapter 2 Creating and Editing Tables 13 Editing a Table Design in Design View 14 Specifying the Primary Key Field 18 Defining Field Properties 19 Chapter 3 Improving Table Design and Creating Relationships 25 Setting Up Input Masks 26 Using Data Validation 30 Creating a Lookup 33 Creating Relationships 37 Chapter 4 Creating Forms 41 Creating a Data Entry Form 42 Understanding Form Views 45 Modifying a Form in Layout View 46 Navigating Records in Form View 46 Editing a Form in Design View 50 Chapter 5 Creating Simple Queries 53 Creating Queries 54 Modifying a Query in Design View 58 Chapter 6 Creating Queries that Filter and Summarize Data 61 Creating a Query that Shows Only Certain Records 62 Prompting the User for a Parameter 65 Creating a Summary Query 68 Chapter 7 Creating Reports 71 Understanding Reports 72 Creating a Simple Report 74 Distributing a Report 78 Using Report Design View 80 Sorting and Grouping Data in a Report 82 Formatting a Report 84 Adding Aggregate Functions (Totals) to a Report 86 Index 87

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >