Using Microsoft Access 2010

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(http://quepublishing.com/using) quepublishing.com/using ." Cover......Page 1 Table of Contents......Page 10 Introduction......Page 20 A Preview of the Database Components......Page 25 What Types of Things Can I Do with Microsoft Access?......Page 36 Working with an Existing Database......Page 40 Working with Table Data......Page 42 Editing Table Data......Page 45 Adding Records to a Table......Page 47 Deleting Records......Page 48 Filtering Table Data......Page 54 Opening a Query......Page 56 Adding and Removing Fields......Page 59 Modifying the Sort Order of a Query......Page 61 Working with Simple Criteria......Page 64 Saving a Query......Page 76 Printing Query Results......Page 77 Closing a Query......Page 78 Designing a Query Based on Multiple Tables......Page 79 Working with Data in a Form......Page 81 Filtering the Data Underlying a Form......Page 93 Closing a Form......Page 96 The AutoForm Feature......Page 97 Using the Form Wizard to Build a Form......Page 99 Using the Conditional Formatting Feature of a Form......Page 102 Opening and Viewing a Report......Page 104 Printing a Report......Page 107 The AutoReport Feature and the Report Wizard......Page 109 Viewing the Design of a Report......Page 113 Creating a New Database......Page 116 Building a New Table......Page 118 Selecting the Appropriate Field Type for Data......Page 123 Using Indexes to Improve Performance......Page 128 The All-Important Primary Key......Page 130 Working with Field Properties......Page 131 Introduction to Relational Database Design......Page 142 The Types of Relationships......Page 149 Establishing Relationships in Access......Page 151 Establishing Referential Integrity......Page 155 Everything You Need to Know About Query Basics......Page 161 Ordering Query Results......Page 167 Refining a Query by Using Criteria......Page 168 Updating Query Results......Page 171 Building Queries Based on Multiple Tables......Page 172 Creating Calculated Fields......Page 177 Getting Help from the Expression Builder......Page 179 Creating and Running Parameter Queries......Page 181 Creating and Running Action Queries......Page 182 Using Aggregate Functions to Summarize Numeric Data......Page 191 Creating Totals Queries......Page 193 Working with Outer Joins......Page 195 Power Control Techniques......Page 198 Conditional Formatting......Page 209 Form Properties and Why Should You Use Them......Page 210 Control Properties and Why to Use Them......Page 216 Working with Combo Boxes......Page 225 The Command Button Wizard: Programming Without Typing......Page 230 Building Forms Based on More Than One Table......Page 232 The Anatomy of a Report......Page 238 Control Properties and Why to Use Them......Page 240 Building Reports Based on More Than One Table......Page 247 Working with Sorting and Grouping......Page 256 Report Properties and Why to Use Them......Page 261 Basing Reports on Stored Queries or Embedded SQL Statements......Page 266 Learning the Basics of Creating and Running a Macro......Page 268 Running an Access Macro......Page 278 Modifying an Existing Macro......Page 281 Creating an Embedded Macro......Page 283 Creating Data Macros......Page 286 Creating a Drillthrough Macro......Page 289 Other New Features Available in Macros......Page 292 Testing a Macro......Page 293 Converting a Macro to VBA Code......Page 295 Creating an AutoExec Macro......Page 297 What Is External Data?......Page 299 Importing, Linking, and Opening Files: When and Why......Page 300 Exporting to Another Access Database......Page 302 Exporting to an Excel Spreadsheet......Page 304 Exporting to ASCII......Page 306 Importing from Another Access Database......Page 309 Importing Spreadsheet Data......Page 313 Importing ASCII Data......Page 317 Linking to Tables in Another Access Database......Page 320 Linking to Another Type of Database......Page 322 The Linked Table Manager......Page 331 Working with Web Databases......Page 333 Creating a Blank Web Database......Page 334 Creating Publishable Objects......Page 336 Publishing Your Database to Access Services......Page 342 Viewing Your Application in a Browser......Page 345 C......Page 347 D......Page 348 F......Page 349 J-K-L......Page 350 P......Page 351 R......Page 352 T......Page 353 X-Y-Z......Page 354

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.

Manipulating data with databases and tables Using queries to retrieve the data you need Using forms to display information Using reports to print information Creating your own databases and tables Relating the information in your database Enhancing the queries that you build Building powerful forms Building powerful reports Automating your database with macros Sharing data with other applications Working with web databases. Presents a guide to the 2010 version of the database management application, covering such topics as creating databases and tables, manipulating data, producing reports, working with forms, and building and enhancing queries. Each book offers an accessible introduction to a computing topic, offering real-world advice and step-by-step tasks, and is integrated with links to online video, podcasts and additional bonus content.