Access 2007 / Matthew MacDonald.

Format:

Book

Author/Creator:

MacDonald, Matthew.

Series:

Missing manual

The Missing manual Access 2007

Language:

English

Subjects (All):

Microsoft Access.

Database management--Computer programs.

Database management.

Physical Description:

1 online resource (965 p.)

Edition:

First edition.

Place of Publication:

Beijing ; Sebastopol, California : Pogue Press/O'Reilly, 2007.

Language Note:

English

System Details:

text file

Summary:

Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "

Contents:

Access 2007: The Missing Manual; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; Access vs. Excel; Access vs. SQL Server; The New Face of Access 2007; Using the Ribbon with the Keyboard; The Office Menu; The Quick Access Toolbar; The New Features in Access 2007; About This Book; About ? These ? Arrows; Drop-down buttons; Ordinary menus; About Shortcut Keys; About Clicking; Examples; About MissingManuals.com; Safari® Enabled; I. Storing Information in Tables; 1.2. Getting Started; 1.2.2. Understanding Tables; 1.2.3. Creating a Simple Table

1.2.4. Editing a Table1.2.4.2. Shortcut keys; 1.2.4.3. Cut, copy, and paste; 1.3. Saving and Opening Access Databases; 1.3.2. Saving a Database with a Different Name or Format; 1.3.3. Opening a Database; 1.3.4. Opening More Than One Database at Once; 1.3.5. Opening a Database Created in an Older Version of Access; 1.3.6. Creating Another Database; 1.4. The Navigation Pane; 1.4.2. Managing Database Objects; 2. Building Smarter Tables; 2.2. Design View; 2.2.2. How Updates Work in Design View; 2.3. Access Data Types; 2.3.2. Memo; 2.3.3. Number; 2.3.3.2. Number formatting; 2.3.4. Currency

2.3.5. Date/Time2.3.6. Yes/No; 2.3.7. Hyperlink; 2.3.8. Attachment; 2.3.9. AutoNumber; 2.3.9.2. Using replication IDs; 2.4. The Primary Key; 2.5. Six Principles of Database Design; 2.5.2. 2. Break Down Your Information; 2.5.3. 3. Include All the Details in One Place; 2.5.4. 4. Avoid Duplicating Information; 2.5.5. 5. Avoid Redundant Information; 2.5.6. 6. Include an ID Field; 3. Mastering the Datasheet: Sorting, Searching, Filtering, and More; 3.1.2. Rearranging Columns; 3.1.3. Resizing Rows and Columns; 3.1.4. Hiding Columns; 3.1.5. Freezing Columns; 3.2. Datasheet Navigation

3.2.2. Filtering3.2.2.2. Filter by selection; 3.2.2.3. Filter by condition; 3.2.3. Searching; 3.3. Advanced Editing; 3.3.2. AutoCorrect; 3.3.3. Special Characters; 3.4. Printing the Datasheet; 3.4.1.2. Changing the page layout; 3.4.2. Fine-Tuning a Printout; 4. Blocking Bad Data; 4.1.2. Setting Default Values; 4.1.3. Preventing Duplicate Values with Indexes; 4.2. Input Masks; 4.2.2. Creating Your Own Mask; 4.3. Validation Rules; 4.3.2. Writing a Field Validation Rule; 4.3.2.2. Validating dates; 4.3.2.3. Validating text; 4.3.2.4. Combining validation conditions

4.3.3. Creating a Table Validation Rule4.4. Lookups; 4.4.2. Adding New Values to Your Lookup List; 5. Linking Tables with Relationships; 5.1.2. Matching Fields: The Relationship Link; 5.1.3. Linking with the ID Column; 5.1.4. The Parent-Child Relationship; 5.2. Using a Relationship; 5.2.2. Editing Relationships; 5.2.3. Referential Integrity; 5.2.3.2. Cascading deletes; 5.2.3.3. Cascading updates; 5.2.4. Navigating a Relationship; 5.2.5. Lookups with Related Tables; 5.3. More Exotic Relationships; 5.3.2. Many-to-Many Relationship; 5.3.2.2. Multi-value fields; 5.4. Relationship Practice

5.4.1.2. Identifying the relationships

Notes:

Includes index.

Description based on print version record.

ISBN:

9780596513962

0596513968

9780596554545

0596554540

OCLC:

609841299