Using Microsoft Access 2010

Description

Get comfortable with Access 2010. Don't just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the price of the book you get online access anywhere with a web connection--no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you'll ever need...where you want, when you want!

Learn fast, learn easy, using web, video, and audio:

* Show Me video walks through tasks you've just got to see--including bonus advanced techniques
* Tell Me More audio delivers practical insights straight from the experts

Audio sidebars featuring Ross Pimentel

UNLOCK THE FREE WEB EDITION--To register your USING book, visit quepublishing.com/using.

CONTENTS:

Introduction xviii

1 Manipulating Data with Databases and Tables 1

What Is a Relational Database? 1

A Preview of the Database Components 1

What Types of Things Can I Do with Microsoft Access? 12

Working with an Existing Database 16

Working with Table Data 18

Editing Table Data 21

Adding Records to a Table 23

Deleting Records 24

Filtering Table Data 30

2 Using Queries to Retrieve the Data You Need 32

What Is a Query and When Should You Use One? 32

Opening a Query 32

Adding and Removing Fields 35

Modifying the Sort Order of a Query 37

Working with Simple Criteria 40

Modifying the Datasheet View of a Query 52

Saving a Query 52

Printing Query Results 53

Closing a Query 54

Designing a Query Based on Multiple Tables 55

3 Using Forms to Enter and Edit Table Data 57

Opening an Existing Form 57

Working with Data in a Form 57

Sorting Records 69

Filtering the Data Underlying a Form 69

Viewing the Design of a Form 72

Closing a Form 72

The AutoForm Feature 73

Using the Form Wizard to Build a Form 75

Using the Conditional Formatting Feature of a Form 78

4 Using Reports to Print Information 80

Opening and Viewing a Report 80

Printing a Report 83

The AutoReport Feature and the Report Wizard 85

Closing a Report 89

Viewing the Design of a Report 89

5 Creating Your Own Databases and Tables 92

Types of Databases Available 92

Creating a New Database 92

Building a New Table 94

Selecting the Appropriate Field Type for Data 99

Using Indexes to Improve Performance 04

The All-Important Primary Key 106

Working with Field Properties 107

6 Relating the Information in Your Database 118

Introduction to Relational Database Design 118

The Types of Relationships 125

Establishing Relationships in Access 127

Establishing Referential Integrity 131

7 Enhancing the Queries That You Build 137

Everything You Need to Know About Query Basics 137

Ordering Query Results 143

Refining a Query by Using Criteria 144

Updating Query Results 147

Building Queries Based on Multiple Tables 148

Creating Calculated Fields 153

Getting Help from the Expression Builder 155

Creating and Running Parameter Queries 157

Creating and Running Action Queries 158

Using Aggregate Functions to Summarize Numeric Data 167

Creating Totals Queries 169

Working with Outer Joins 171

8 Building Powerful Forms 174

Power Control Techniques 174

Conditional Formatting 185

Form Properties and Why Should You Use Them 186

Control Properties and Why to Use Them 192

Working with Combo Boxes 201

The Command Button Wizard: Programming Without Typing 206

Building Forms Based on More Than One Table 208

9 Building Powerful Reports 214

The Anatomy of a Report 214

Control Properties and Why to Use Them 216

Building Reports Based on More Than One Table 223

Working with Sorting and Grouping 232

Report Properties and Why to Use Them 237

Basing Reports on Stored Queries or Embedded SQL Statements 242

10 Automating Your Database with Macros 244

Learning the Basics of Creating and Running a Macro 244

Running an Access Macro . 254

Modifying an Existing Macro 257

Creating an Embedded Macro 259

Creating Data Macros 262

Creating a Drillthrough Macro 265

Other New Features Available in Macros 268

Testing a Macro 269

Determining When You Should Use Macros and When You Shouldn't 271

Converting a Macro to VBA Code 271

Creating an AutoExec Macro 273

11 Sharing Data with Other Applications 275

What Is External Data? 275

Importing, Linking, and Opening Files: When and Why 276

Exporting to Another Access Database 278

Exporting to an Excel Spreadsheet 280

Exporting to ASCII 282

Importing from Another Access Database 285

Importing Spreadsheet Data 289

Importing ASCII Data 293

Linking to Tables in Another Access Database 296

Linking to Another Type of Database 298

The Linked Table Manager 307

12 Working with Web Databases 309

Working with Web Databases 309

Creating a Blank Web Database 310

Creating Publishable Objects 312

Publishing Your Database to Access Services 318

Viewing Your Application in a Browser 321

Index 323