- Shopping Bag ( 0 items )
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 ...
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:
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.
This fast-paced book teaches the basics of Access 2007 so readers can start using the program right away. Rather than include every detail, this manual shows how to work with Access's most-used features and Microsoft's new context-sensitive user interface.
The Missing Credits; About the Author; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What You Can Do with Access; The New Face of Access 2007; About This Book; Part I: STORING INFORMATION IN TABLES; Chapter 1: Creating your First Database; 1.1 Understanding Access Databases; 1.2 Getting Started; 1.3 Saving and Opening Access Databases; 1.4 The Navigation Pane; Chapter 2: Building Smarter Tables; 2.1 Understanding Data Types; 2.2 Design View; 2.3 Access Data Types; 2.4 The Primary Key; 2.5 Six Principles of Database Design; Chapter 3: Mastering the Datasheet: Sorting, Searching, Filtering, and More; 3.1 Datasheet Customization; 3.2 Datasheet Navigation; 3.3 Printing the Datasheet; Chapter 4: Blocking Bad Data; 4.1 Data Integrity Basics; 4.2 Input Masks; 4.3 Validation Rules; 4.4 Lookups; Chapter 5: Linking Tables with Relationships; 5.1 Relationship Basics; 5.2 Using a Relationship; 5.3 More Exotic Relationships; 5.4 Relationship Practice; Part II: MANIPULATING DATA WITH QUERIES; Chapter 6: Queries that Select Records; 6.1 Query Basics; 6.2 Creating Queries; 6.3 Queries and Related Tables; 6.4 Query Power: Calculated Fields and Text Expressions; 6.5 Calculated Fields; Chapter 7: Queries that Update Records; 7.1 Understanding Action Queries; 7.2 Update Queries; 7.3 Append Queries; 7.4 Delete Queries; Part III: PRINTING REPORTS AND USING FORMS; Chapter 8: Creating Reports; 8.1 Report Basics; 8.2 Printing, Previewing, and Exporting a Report; 8.3 Formatting a Report; 8.4 Filtering and Sorting a Report; Chapter 9: Creating Simple Forms; 9.1 Form Basics; 9.2 Sorting and Filtering in a Form; 9.3 The Form Wizard; Part IV: SHARING ACCESS WITH THE REST OF THE WORLD; Chapter 10: Importing and Exporting Data; 10.1 Case for Importing and Exporting; 10.2 Using the Clipboard; 10.3 Import and Export Operations; Colophon;
Matthew MacDonald is an author, educator, and software developer. He is the author of Excel 2007: The Missing Manual and several books about .NET, including The Book of VB .NET (No Starch), ASP.NET: The Complete Reference (McGraw-Hill), Microsoft .NET Distributed Applications (Microsoft Press), and several more. He is a regular columnist for Inside Visual Basic, and has been involved in non-programming writing projects like the classical All-Music Guide.
Posted June 16, 2011
No text was provided for this review.