Access 2007
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...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
Beijing ; Sebastopol, California :
Pogue Press/O'Reilly
2007.
|
| Edition: | First edition |
| Series: | Missing manual
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627303806719 |
Table of 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
