| | | Copyright |
| | | About the Author |
| | | Acknowledgments |
| | | We Want to Hear from You! |
| | | Introduction |
| | | | Some Key Terms |
| | | | Some Things to Keep in Mind |
| | | | The Basic Structure of This Book |
| | | | Conventions Used in This Book |
| | | | Contacting the Authors |
|
| | | Part I: Getting to Know Access |
| | | | Chapter 1. Welcome to Databases |
| | | | What Can You Do with a Database? |
| | | | Why Not Just Use Excel? |
| | | | A Sample Database: Northwind Traders |
|
| | | | Chapter 2. Take a Quick Tour of Access |
| | | | Launching Access |
| | | | Opening a Database |
| | | | Opening an Existing File |
| | | | Converting |
| | | | Exploring the Access User Interface |
| | | | Making a Grand Exit |
|
| | | | Chapter 3. Exploring the Database Window |
| | | | What's in the Database Window? |
| | | | Organizing Database Objects |
|
|
| | | Part II: Building and Using a Database |
| | | | Chapter 4. Planning a Database |
| | | | The Goal |
| | | | Determining the Database's Purpose |
| | | | The Discovery ProcessFinding the Data |
| | | | Identifying Possible Forms |
| | | | Planning Possible Reports |
|
| | | | Chapter 5. Building Your First Tables |
| | | | What's in a Table? |
| | | | How to Create a Simple Table |
| | | | Working with Data in Your Tables |
| | | | How to Find Information |
|
| | | | Chapter 6. Tapping the Power of Relationships |
| | | | Using the Lookup Wizard |
| | | | Using the Table Analyzer to Create Relationships |
| | | | Using the Relationships Window |
| | | | SubdatasheetsA Product of Relationships |
|
| | | | Chapter 7. Retrieving Data with Queries |
| | | | How to Create Simple Queries |
| | | | Using Query Design View |
|
|
| | | Part III: Putting a Friendly Face on Your Data |
| | | | Chapter 8. Creating and Using Data Entry Forms |
| | | | Creating Simple Forms |
| | | | Entering Data Through Forms |
| | | | Finding Information with Forms |
|
| | | | Chapter 9. Printing Information with Reports |
| | | | Building Reports |
| | | | Using Reports |
|
| | | | Chapter 10. Take Your Data to the Web with Pages |
| | | | A Quick Overview of the Page Object |
| | | | Creating Simple Pages |
| | | | Using Pages |
| | | | How You'll Use Pages |
|
|
| | | Part IV: Making Access Work Your Way |
| | | | Chapter 11. Customizing Your Tables |
| | | | Using Data Types Wisely |
| | | | Setting Field Properties |
| | | | Working with Indexes |
|
| | | | Chapter 12. Getting Down to Business with Queries |
| | | | Running the Query Wizards |
| | | | Working in Query Design View |
|
| | | | Chapter 13. Customizing Forms |
| | | | Setting Form Properties |
| | | | Using the Field List |
| | | | Using the Toolbox |
| | | | Working with Sections and Subforms |
| | | | Object Dependencies |
|
| | | | Chapter 14. Dressing Up Your Reports |
| | | | Formatting Reports |
| | | | Specialized Wizards |
|
|
| | | Part V: Letting Access Do Your Work for You |
| | | | Chapter 15. Automating Your Database |
| | | | Using the Switchboard Wizard |
| | | | Setting Startup Options |
| | | | Writing Macros |
|
| | | | Chapter 16. Sharing Data |
| | | | Exporting Data to Excel |
| | | | Using Excel Data in Access |
| | | | Copying Linked Data |
| | | | Exporting Access Data to a Text File |
| | | | Importing Text Files into Access |
| | | | Publishing to Word |
| | | | Merging Access Data with Word Documents |
| | | | Sending Access Objects in Email |
| | | | More Compatible Formats |
|
| | | | Chapter 17. Using Common Office Features |
| | | | The Helpful AssistantNot! |
| | | | Running SpellCheck |
| | | | About AutoCorrect |
| | | | Getting Help When You Need It |
| | | | Customizing Access Toolbars |
|
|
| | | Index |