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.
Faithe Wempen, M.A., has written over 60 books on computer hardware and software, and is a Microsoft Office Specialist Master Instructor and an A+ Certified computer technician. She is a freelance computer support technician and trainer, teaches courses in Microsoft Office and computer concepts at Indiana University Purdue University at Indianapolis (IUPUI), and is a frequent contributor to technical magazines and Web sites including Microsoft Office Solutions magazine and TechProGuild.com. Faithe is a Contributing Editor at CertCities.com for Microsoft Office and A+, an online instructor and course developer for the Hewlett-Packard Learning Center Online, and on the advisory team for the A+ Certification program at Training, Inc. She lives in Noblesville IN, where she co-owns and manages Sycamore Knoll Bed and Breakfast.
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