Access 2007 for Starters: The Missing Manual

Informacje podstawowe:

• Wydawnictwo: O'Reilly Media / Pogue Press
• Data wydania: 25 stycznia 2007
• Liczba stron: 384
• Autor/autorzy:
  • Matthew MacDonald

Opis:

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:

• Clear explanations
• Step-by-step instructions
• Lots of illustrations
• Larger type
• 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.

O autorze/autorach:

Matthew MacDonald

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.

View Matthew MacDonald's full profile page.

Zawartość (spis treści):

1. STORING INFORMATION IN TABLES

   1. Chapter 1 Creating your First Database
      1. Understanding Access Databases
      2. Getting Started
      3. Saving and Opening Access Databases
      4. The Navigation Pane
   2. Chapter 2 Building Smarter Tables
      1. Understanding Data Types
      2. Design View
      3. Access Data Types
      4. The Primary Key
      5. Six Principles of Database Design
   3. Chapter 3 Mastering the Datasheet: Sorting, Searching, Filtering, and More
      1. Datasheet Customization
      2. Datasheet Navigation
      3. Printing the Datasheet
   4. Chapter 4 Blocking Bad Data
      1. Data Integrity Basics
      2. Input Masks
      3. Validation Rules
      4. Lookups
   5. Chapter 5 Linking Tables with Relationships
      1. Relationship Basics
      2. Using a Relationship
      3. More Exotic Relationships
      4. Relationship Practice

2. MANIPULATING DATA WITH QUERIES

   1. Chapter 6 Queries that Select Records
      1. Query Basics
      2. Creating Queries
      3. Queries and Related Tables
      4. Query Power: Calculated Fields and Text Expressions
      5. Calculated Fields
   2. Chapter 7 Queries that Update Records
      1. Understanding Action Queries
      2. Update Queries
      3. Append Queries
      4. Delete Queries

3. PRINTING REPORTS AND USING FORMS

   1. Chapter 8 Creating Reports
      1. Report Basics
      2. Printing, Previewing, and Exporting a Report
      3. Formatting a Report
      4. Filtering and Sorting a Report
   2. Chapter 9 Creating Simple Forms
      1. Form Basics
      2. Sorting and Filtering in a Form
      3. The Form Wizard

4. SHARING ACCESS WITH THE REST OF THE WORLD

   1. Chapter 10 Importing and Exporting Data
      1. Case for Importing and Exporting
      2. Using the Clipboard
      3. Import and Export Operations

1. Colophon