- Shopping Bag ( 0 items )
-
All (7) from $1.99
-
New (1) from $65.0
-
Used (6) from $1.99
More About This Textbook
Overview
Product Details
Related Subjects
Meet the Author
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.
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