This fast-paced book teaches you the basics of Access 2007 so you can start using this popular database program right away. You'll learn how to work with Access' most useful features to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry.
The new Access is radically different from previous versions, but with this book, you'll breeze through the new interface and its timesaving features in no time with:
Lots of illustrations
Plenty of friendly advice
Ideal for small businesses and households, Access runs on PCs and manages large stores information, including numbers, pages of text, and pictures -- everything from a list of family phone numbers to an enormous product catalog. Unfortunately, each new version of the program crammed in yet another set of features -- so many that even the pros don't know where to find them all. Access 2007 breaks the mold: Microsoft changed the user interface by designing a tabbed toolbar that makes features easy to locate.
One thing that hasn't improved is Microsoft's documentation. Even if you find the features you need, you still may not know what to do with them. Access 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
STORING INFORMATION IN TABLES
Chapter 1 Creating your First Database
Understanding Access Databases
Saving and Opening Access Databases
The Navigation Pane
Chapter 2 Building Smarter Tables
Understanding Data Types
Access Data Types
The Primary Key
Six Principles of Database Design
Chapter 3 Mastering the Datasheet: Sorting, Searching, Filtering, and More
Printing the Datasheet
Chapter 4 Blocking Bad Data
Data Integrity Basics
Chapter 5 Linking Tables with Relationships
Using a Relationship
More Exotic Relationships
MANIPULATING DATA WITH QUERIES
Chapter 6 Queries that Select Records
Queries and Related Tables
Query Power: Calculated Fields and Text Expressions
Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.
Sanders Kleinfeld was the production editor for Access 2007 for Starters: The Missing Manual. Philip Dangler and Colleen Gorman provided quality control. Lucie Haskins wrote the index.
The cover of this book is based on a series design originally created by David Freedman and modified by Mike Kohnke, Karen Montgomery, and Fitch (www.fitch.com). Back cover design, dog illustration, and color selection by Fitch.
Tom Ingalls designed the interior layout, which was modified by Ron Bilodeau. Abby Fox converted the text and prepared it for layout. Robert Romano and Jessamyn Read produced the illustrations.
Comments about oreilly Access 2007 for Starters: The Missing Manual:
Access 2007 For Starters The Missing Manual
Reviewed by Esther Schare, Director
Broward Personal Computer Association
President, Kings Point Computer Club
As with all other Microsoft products, Access 2007 For Starters, The Missing Manual should have been in the box with the application. Once again, it is your best friend for answers, in spite of the "Help" area in the product.
The biggest difference in Microsoft's latest issue of Access 2007 For Starters is that there is no "drop down" menu. It has been replaced by "ribbons" that indicate immediately where you want to do to do whatever it is that you want to make or change. The greatest obstacle is unlearning all the strokes that you had to do prior to this version. The learning curve of the ribbons takes time, but the bottom line is that once learned, it becomes a treasure because of the amount of time that it saves when adding to, or taking away from, or changing and/or amending your worksheet. Every one of the previous Access keyboard features continues to work in the same manner. There is no relearning for these actions.
The Access For Starters, The Missing Manual has Four Parts, each of which have several chapters that takes you by the hand, to lead you through this new application. It is specifically written for those who have not yet been introduced to the many uses of databases.
One of the more difficult tasks with any database, is that you have to think ahead of all the types of information you will want in that database. Yes, you can insert various information at a later date, but it will serve you well if you think it through before you begin. Essentially, a database is a collection of information that is stored in a single file.
Altogether you have six different types of database objects, i.e., Tables that store information and are the heart of the database; Queries that allow you to quickly perform an action on a table. Usually this action involves retrieving a choice bit of information; Forms are the windows that you create, arrange and colorize (if you like). Forms provide an easy way to view or change the information; Reports help you print some or all of the information in a table and you can choose where the information appears on the page and how it is grouped and sorted as well as how it is formatted; Macros are mini-programs that automate custom tasks. Macros are a simple way to get custom results without becoming a programmer; and finally, Modules which are files that contain Visual Basic code. This last, both Macros and Modules and described simply here, but go into much more detail in the advanced book by Matthew MacDonald entitled Access 2007, not to be confused with Access 2007 For Starters.
Chapter 1: Instructs you how to create your first database, and understanding tables. In this chapter you will also learn how to edit a table, understand tables, editing the table and then save the database. In this chapter you will also learn how to make a backup, saving a dataset with a different name, and opening more than one database at a time.
Chapter 2: speaks to design view, access data types, i.e. text, memo, number, currency, date/time, attachment, etc. This chapter also includes information concerning database dsign like choosing good field names, breaking down your information, including all the details in one place, avoiding duplicating information and/or redundant information.
Chapter 3: goes into more detail about datasheet customization, formatting the datasheet, rearranging and/or resizing columns and rows, how to hide columns or freeze them. It also discusses datasheet navigation, like sorting, filtering, searching, and then printing the datasheet.
Chapters 4 and 5: These chapters are about blocking bad data, validation rules, linking tables with various relationships, such as matching fields, redundant data vs. related data, defining and editing a relationship and finally a one-to-one or many-to-many relationships. While these two chapters sound far advanced, once you read about them and following the instructions, you can see that they are not as difficult as they sound.
Chapter 6: Discusses in depth the basic reason that databases are so popular. You can query the selected records so that you can manipulate whatever information has been input. Microsoft has included a Query Wizard, which makes it easier to obtain your selected information.
Chapter 7: This chapter further discusses queries and Mr. MacDonald has succinctly discussed understanding the action queries.
Chapter 8: This chapter is devoted to creating simple reports, arranging a report, adding and removing fields and creating a report from scratch. Printing, previewing and exporting a report is addressed, as is formatting, filtering and sorting reports.
Chapter 9: This chapter describes the creation of simple forms as opposed to reports. Again, creating, using a form, sorting and filtering and the Form Wizard is included in this chapter.
Chapter 10: Gives you information about sharing Access with the rest of the world by understanding imports and exporting . This chapter also goes into detail about using the clipboard and copying cells from another application, like Excel, into your Access datasheet.
In spite of the fact that this book "For Starters", make no mistake, Microsoft's Access is a heavy weight application that will take time to learn. However, it is easier to learn the application using Access 2007 For Starters rather than continually input mountains of information into various reports, when this application will allow you to query and then generate a report with all the data that you require.