Get introduced to Access with PICTURE YOURSELF LEARNING MICROSOFT(r) 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.
Table of Contents
Introduction. 1: Creating a Database. 2: Creating and Editing Tables. 3: Improving Table Design and Creating Relationsips. 4: Creating Forms. 5: Creating Simple Queries. 6: Creating Queries that Filter and Summarize Data. 7: Creating Reports.