Book description
Get the fast facts that make learning Microsoft Office Access 2007 plain and simple! This no-nonsense guide uses easy numbered steps and concise, straightforward language that show the most expedient ways to learn a skill or solve a problem.
Table of contents
-
Microsoft® Office Access™ 2007 Plain & Simple
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- Acknowledgments
- 1. Introduction: About This Book
- 2. What’s New in Access 2007
- 3. Introducing Access 2007
- 4. Getting to Know Access Databases
- 5. Creating a Database
-
6. Customizing Fields
- Working with Tables
- Assigning a Data Type
- Viewing or Changing Field Properties
- Introducing the Expression Builder
- Formatting Field Contents
- Creating Input Masks
- Assigning Required Fields and Requiring Data Entry
- Setting Default Values
- Indexing Field Values
- Validating Data Entry
- Creating a Lookup Field
- Creating an Append-Only Memo Field
- Creating an Attachment Field
- 7. Customizing Tables
- 8. Creating Forms
-
9. Creating Queries
- Introducing Query Types
- Creating a Query Using the Query Wizard
- Editing a Query in Design View
- Using Criteria to Focus Query Results
- Introducing Operators
- Using Queries to Calculate Values
- Finding Duplicate Records
- Finding Unmatched Records
- Writing Query Results to a New Table
- Creating an Update Query
- Creating a Crosstab Query
- Finding the Largest and Smallest Values in a Field by Using a Query
- 10. Creating Reports
-
11. Beautifying Forms and Reports
- Formatting Text
- Applying AutoFormats
- Setting Control Appearance
- Adding Lines, Shapes, and Borders
- Editing Lines and Borders
- Showing Gridlines in a Report
- Coloring Alternate Rows in a Form or Report
- Adding a Totals Row to a Datasheet
- Adding a Picture
- Applying Conditional Formatting
- Changing the Source of an Image
- Setting Image Alignment and Backing Color
- Tiling a Picture
- Setting Image Height and Width
- 12. Creating Charts in Access
-
13. Interacting with Other Programs
- Introducing Linking and Embedding
- Inserting a New Object
- Manipulating Objects
- Inserting Excel Charts and Worksheets
- Importing Data from Another Access Database
- Linking to a Table in Another Access Database
- Working with Hyperlinks
- Importing Data from an Excel File
- Importing Data from a Text File
- Importing Data from an XML File
- Exporting Data to a Text File
- Exporting Data to Another Access File
- Exporting Data to an XML File
- Saving Database Objects as Web Files
- Analyzing Data with Microsoft Excel
- Publishing Data to Microsoft Word
- Collecting Data from E-mail Messages
- 14. Administering a Database
- 15. Customizing Access
- 16. Presenting Table and Query Data Dynamically
- A. About the Author
- B. Choose the Right Book for You
- Index
- About the Author
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
Product information
- Title: Microsoft® Office Access™ 2007 Plain & Simple
- Author(s):
- Release date: January 2007
- Publisher(s): Microsoft Press
- ISBN: 9780735622920
You might also like
book
Microsoft® Office Access™ 2007 Step by Step
Experience learning made easy—and quickly teach yourself how to build database solutions with Access 2007. With …
book
Microsoft® Office Access 2003 Inside Out
Take your database expertise to the next level! This supremely organized reference packs hundreds of timesaving …
book
Microsoft® Access® 2010 Inside Out
You're beyond the basics, so dive right in and really put your database skills to work! …
book
Microsoft® Access® 2010: Step by Step
Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With …