Missing Manual

Sebastopol : : O'Reilly Media, , 2008.

1 online resource (965 p.)

Description based upon print version of record.. - 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. - 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 "

Electronic books.

005.7565

0596527608. - 9780596527600