Missing Manual

Sebastopol : : O'Reilly Media, , 2009.

1 online resource (384 p.)

Description based upon print version of record.. - Access 2007 for Starters: The Missing Manual; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; Access vs. Excel; The New Face of Access 2007; Using the Ribbon with the Keyboard; The Office Menu; The Quick Access Toolbar; About This Book; About → These → Arrows; Drop-down buttons; 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 Table; 1.2.4.2. Shortcut keys. - 1.2.4.3. Cut, copy, and paste1.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/Time; 2.3.6. Yes/No; 2.3.7. Hyperlink. - 2.3.8. Attachment2.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. Filtering; 3.2.2.2. Filter by selection. - 3.2.2.3. Filter by condition3.2.3. Searching; 3.3. Printing the Datasheet; 3.3.1.2. Changing the page layout; 3.3.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.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 Rule; 4.4. Lookups; 4.4.2. Adding New Values to Your Lookup List; 5. Linking Tables with Relationships. - 5.1.2. Matching Fields: The Relationship Link5.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.4. Relationship Practice; 5.4.1.2. Identifying the relationships; 5.4.1.3. Getting more detailed; 5.4.2. The Chocolate Store; 5.4.2.2. Ordering products; II. MANIPULATING DATA WITH QUERIES. - 6.2. Creating Queries. - 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 explanationsStep-by-step instructionsLot

Electronic books.

005.7565 . - 005.75

0-596-52833-7. - 978-0-596-52833-1(h.) : Nkr 190.00