The Missing Credits Introduction What's a Database? About Access Databases About This Book The Very Basics Example Databases About MissingManuals.com Safari Enabled Part One:. Building a database Chapter 1. Creating Databases A Tour of an Access Database The Access Window Tables Forms Queries Reports Putting It All Together Creating a New Database Starting with a Wizard Phase 1: Choosing Your Template Phase 2: Choosing Table Fields Phase 3: Choosing Styles for Forms and Reports Phase 4: Adding a Title and a Picture Modifying the Wizard's Database Opening a Database Navigating with the Switchboard Adjusting Table Designs Adding Records Using a Form Printing a Report Starting from a Blank Database Chapter 2. Creating Tables to Hold Data Planning Your Tables Creating Tables with the Wizard Phase 1: Starting the Table Wizard Phase 2: Choosing Fields for Your Table Phase 3: Naming Your Table and Setting a Primary Key Phase 5: Creating Your Table Creating Tables in the Design Window Adding Fields Choosing Data Types Setting Field Properties Adding and Editing Table Data Adding Records to a Datasheet Editing Records in a Datasheet Changing How a Table Displays Data Chapter 3. Creating Forms to Add and Display Data Form Basics Form Layouts Controls Properties and the Property Sheet Creating Autoforms Creating Forms with the Form Wizard Phase 1: Choosing a Record Source Phase 2: Choosing Fields Phase 3: Choosing a Form Layout Phase 4: Choosing a Form Style Phase 5: Naming and Saving the Form Modifying the Form Design Editing the Labels Adding a Title in the Form Header Dragging a Control Creating Forms in Design View Phase 1: Starting Your Design Phase 2: Choosing a Data Source Phase 3: Adding Fields to the Form Phase 4: Adding Images to the Form Phase 5: Adding a Form Style Phase 6: Naming and Saving the Form Chapter 4. Linking Tables to Combine Data Why Relate? A Relational Database Tour Common Fields Subdatasheets and Subforms Linking Tables in the Relationships Window Adding Tables to the Relationships Window Adding Relationships Between Tables Modifying or Deleting Relationships Printing Relationships Using Subdatasheets to View Related Items Creating Subforms Adding Information in a Subform Part two:. Organizing information Chapter 5. Sorting and Filtering Sorting Database Records Ascending Sorts Descending Sorts Sorting on Multiple Fields Saving Your Sorting Choice Finding Data with Filters Filtering by Selection: The Quick Way to Filter Filtering by Form Filtering with Wildcards, Operators, and Expressions Using Advanced Filter/Sort Chapter 6. Finding Data with Queries Types of Queries Select Query Crosstab Query Parameter Query Action Query Autolookup Query SQL Query Setting Query Properties Creating Queries with the Query Wizard Creating a Simple Query Creating a Crosstab Query Using a Query to Check for Duplicate Records Creating a Find Unmatched Query Saving, Deleting, and Printing Queries Chapter 7. Creating Custom Queries Creating Queries in the Query Design Window Using Criteria in Queries Crafting a Custom Query Using the Query Design Window Tweaking Your Custom Query Getting Sums, Totals, and Averages from Your Database Using Expression Builder Chapter 8. Generating Reports Report Basics How Reports Differ from Forms Types of Access Reports Two Ways to Create Reports Displaying and Printing Reports Parts of a Report Report Design Sections Using the Report Wizard Starting the Wizard Choosing the Report Type Choosing the Data Source Choosing the Fields Grouping the Report Data Sorting the Report Data Choosing a Report Layout Choosing a Report Style Adding a Report Title Part three:. appendixes Appendix A. Help and Installation Installing Access 2003 Access Help Visiting Microsoft Office Online Appendix B. Access FAQ Importing and Exporting Validation Finding Find Appendix C. Access 2003, Menu by Menu File Menu Edit Menu View Menu Insert Menu Format Menu Records Menu Tools Menu Window Menu Help Menu Index
Scott Palmer, Ph.D., has done database design and programming since 1985. He is the author of 21 books, including three best-sellers. He was computer columnist for The Washington DC Business Journal and has written for The Wall Street Journal, Federal Computer Week, InfoWorld, PC World, Cato Policy Report, Reason Magazine, and many other publications. He studied at Indiana University, the State University of New York, and the University of London. He is a member of the Mathematical Association of America and the American Economic Association.