Microsoft Access 2010 Plain and Simple

Description

Get the guide that makes learning Microsoft Access 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to build a database and sort information, using easy-to-follow steps and concise, straightforward language. You'll learn how out-of-the-box templates and reusable components make Access 2010 a fast and simple database solution.

 Here's WHAT you'll learn:

* Design and build your own database quickly
* Use Access forms to collect information with ease
* Create and modify tables to organize your data
* Store files such as documents and images
* Exchange data with other databases and documents
* Bring your data alive with colorful reports Here's HOW you'll learn it:

* Jump in whenever you need answers
* Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
* Handy TIPS teach new techniques and shortcuts
* Quick TRY THIS! exercises help apply what you learn right away

CONTENTS:

Chapter 1: Introduction: About This Book; 1.1 No Computerese!; 1.2 A Quick Overview; 1.3 A Few Assumptions; 1.4 A Final Word (or Two); Chapter 2: What’s New in Access 2010?; 2.1 Managing Access Settings and Files in Backstage View; 2.2 Customizing the Access 2010 User Interface; 2.3 Creating Databases Using Improved Templates; 2.4 Building Databases by Re-Using Application Parts; 2.5 Creating Navigation Forms; 2.6 Formatting Database Objects Using Office Themes; 2.7 Gaining Insights into Data Using Conditional Formatting; 2.8 Defining Calculated Fields Using the Improved Expression Builder; Chapter 3: Introducing Access 2010; 3.1 Introducing Databases; 3.2 Starting Access 2010; 3.3 Surveying the Access 2010 Window; 3.4 Opening a Database; 3.5 Viewing Multiple Database Objects; 3.6 Closing a Database and Exiting Access 2010; 3.7 Displaying and Managing Database Objects; 3.8 Using the Access 2010 Help System; Chapter 4: Creating a Database; 4.1 Designing a Database; 4.2 Viewing a Sample Database; 4.3 Creating a New Database; 4.4 Creating Databases Using Database Templates; 4.5 Creating a New Table in Design View; 4.6 Creating a New Table by Typing; 4.7 Creating a New Table Using a Template; 4.8 Creating a New Table Using Application Parts; 4.9 Setting a Primary Key; 4.10 Getting Data from Other Access 2010 Tables; 4.11 Relationships Explained; 4.12 Creating Relationships Between Tables; 4.13 Enforcing Referential Integrity; Chapter 5: Customizing Fields; 5.1 Working with Tables; 5.2 Assigning a Data Type; 5.3 Viewing or Changing Field Properties; 5.4 Introducing the Expression Builder; 5.5 Formatting Field Contents; 5.6 Creating Input Masks; 5.7 Assigning Required Fields and Requiring Data Entry; 5.8 Setting Default Values; 5.9 Indexing Field Values; 5.10 Validating Data Entry; 5.11 Creating a Lookup Field; 5.12 Creating an Append-Only Memo Field; 5.13 Creating an Attachment Field; Chapter 6: Customizing Tables; 6.1 Finding and Replacing Text; 6.2 Entering Data Using AutoCorrect; 6.3 Adding and Editing Text; 6.4 Manipulating Columns; 6.5 Modifying Columns and Rows; 6.6 Viewing a Subworksheet; 6.7 Filtering Table Records; Chapter 7: Creating Forms; 7.1 Creating a Simple Form; 7.2 Creating a Form Using the Form Wizard; 7.3 Creating a Form in Design View; 7.4 Creating a Multiple Items Form; 7.5 Modifying an Existing Form; 7.6 Adding and Deleting Form Controls; 7.7 Adding a Date Picker Control; 7.8 Creating a Subform; 7.9 Displaying a Form and Its Datasheet Simultaneously; Chapter 8: Creating Queries; 8.1 Introducing Query Types; 8.2 Creating a Query Using the Query Wizard; 8.3 Editing a Query in Design View; 8.4 Using Criteria to Focus Query Results; 8.5 Introducing Operators; 8.6 Using Queries to Calculate Values; 8.7 Creating a Parameter Query; 8.8 Finding Duplicate Records; 8.9 Finding Unmatched Records; 8.10 Writing Query Results to a New Table; 8.11 Creating an Update Query; 8.12 Creating a Crosstab Query; 8.13 Finding the Largest and Smallest Values in a Field by Using a Query; Chapter 9: Creating Reports; 9.1 Creating a Report Using the Report Wizard; 9.2 Creating a Summary Report; 9.3 Creating a Report in Design View; 9.4 Modifying an Existing Report; 9.5 Adding and Deleting Report Controls; 9.6 Calculating Values in a Report; 9.7 Introducing Report Sections; 9.8 Grouping Report Records; 9.9 Creating a Subform or Subreport; 9.10 Creating Mailing Labels; Chapter 10: Beautifying Forms and Reports; 10.1 Formatting Text; 10.2 Introducing Office Themes; 10.3 Applying Office Themes; 10.4 Setting Control Appearance; 10.5 Adding Lines, Shapes, and Borders; 10.6 Showing Gridlines in a Report; 10.7 Coloring Alternate Rows in a Form or Report; 10.8 Adding a Totals Row to a Worksheet; 10.9 Adding a Picture; 10.10 Applying Conditional Formatting; 10.11 Changing the Source of an Image; 10.12 Setting Image Alignment and Backing Color; 10.13 Tiling a Picture; 10.14 Setting Image Height and Width; Chapter 11: Creating Charts in Access 2010; 11.1 Creating a Chart; 11.2 Formatting Chart Elements; 11.3 Customizing Chart Axes; 11.4 Add Information to a Chart; 11.5 Changing a Chart’s Type; Chapter 12: Interacting with Other Programs; 12.1 Introducing Linking and Embedding; 12.2 Inserting a New Object; 12.3 Manipulating Objects; 12.4 Inserting Excel 2010 Charts and Worksheets; 12.5 Importing Data from Another Access 2010 Database; 12.6 Linking to a Table in Another Access 2010 Database; 12.7 Working with Hyperlinks; 12.8 Importing Data from an Excel 2010 File; 12.9 Importing Data from a Text File; 12.10 Importing Data from an XML File; 12.11 Exporting Data to a Text File; 12.12 Exporting Data to Another Access 2010 File; 12.13 Exporting Data to an XML File; 12.14 Saving Database Objects As Web FFFFFFiles; 12.15 Analyzing Data with Excel 2010; 12.16 Publishing Data to Word 2010; 12.17 Collecting Data from E-mail Messages; Chapter 13: Administering a Database; 13.1 Introducing Database Security; 13.2 Encrypting a Database; 13.3 Locking Database Records; 13.4 Creating a Navigation Form; 13.5 Documenting a Database; 13.6 Setting Startup Options; Chapter 14: Customizing Access 2010; 14.1 Adding Commands to the Quick Access Toolbar; 14.2 Modifying the Ribbon User Interface; 14.3 Changing AutoCorrect Options; Chapter 15: Presenting Table and Query Data Dynamically; 15.1 Introducing PivotTables and PivotCharts; 15.2 Creating a PivotTable; 15.3 Adding and Removing PivotTable Fields; 15.4 Pivoting a PivotTable; 15.5 Filtering PivotTable Data; 15.6 Formatting a PivotTable; 15.7 Creating a PivotChart; About the Author;