Maybe you got Access as part of Microsoft Office and wonder what it can do for you and your household; maybe you're a small business manager and don't have a techie on staff to train the office in Microsoft Access. Regardless, you want to quickly get your feet wet - but not get in over your head - and "Access 2003 for Starters: The Missing Manual" is the book to make it happen. Far more than a skimpy introduction, but much less daunting than a weighty tech book, "Access 2003 for Starters: The Missing Manual" demystifies databases and explains how to design and create them with ease. It delivers everything you need - and nothing you don't - to use Access right away. It's your expert guide to the Access features that are most vital and most useful, and it's your trusted advisor on the more in-depth features that are best saved for developers and programmers. Access is sophisticated and powerful enough for professional developers, but easy and practical enough for everyday users like you. This Missing Manual explains all the major features of Access 2003, including designing and creating databases, organizing and filtering information, and generating effective forms and reports.
Bestselling authors, database designers, and programmers Scott Palmer, Ph.D., and Kate Chase are your guides for putting the world's most popular desktop data management program to work. Their clear explanations, step-by-step instructions, plenty of illustrations, and timesaving advice help you get up to speed quickly and painlessly. Whether you're just starting out or you know you've been avoiding aspects of the program and missing out on much of what it can do, this friendly, witty book will gently immerse you in Microsoft Access. Keep it handy, as you'll undoubtedly refer to it again and again.
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.
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