Microsoft Office Access 2007 Plain & Simple

Acknowledgments;
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 2007;
2.1 Familiarizing Yourself with the New User Interface;
2.2 Formatting Database Objects Using New AutoFormats;
2.3 Creating New Types of Fields;
2.4 Collecting Data from E-mail Messages;
Chapter 3: Introducing Access 2007;
3.1 Introducing Databases;
3.2 Starting Access;
3.3 Surveying the Access Window;
3.4 Opening a Database;
3.5 Viewing Multiple Database Objects;
3.6 Closing a Database and Exiting Access;
3.7 Displaying and Managing Database Objects;
3.8 Using the Access Help System;
Chapter 4: Getting to Know Access Databases;
4.1 Viewing a Sample Database;
4.2 Working with Database Objects;
4.3 Examining a Table;
4.4 Examining a Form;
4.5 Examining a Query;
4.6 Examining a Report;
4.7 Using the Database Templates;
4.8 Frequently Used Object Views;
Chapter 5: Creating a Database;
5.1 Designing a Database;
5.2 Creating a New Database;
5.3 Creating a New Table in Design View;
5.4 Creating a New Table by Typing;
5.5 Adding Existing Fields to a Table;
5.6 Setting a Primary Key;
5.7 Getting Data from Other Access Tables;
5.8 Relationships Explained;
5.9 Creating Relationships between Tables;
5.10 Enforcing Referential Integrity;
Chapter 6: Customizing Fields;
6.1 Working with Tables;
6.2 Assigning a Data Type;
6.3 Viewing or Changing Field Properties;
6.4 Introducing the Expression Builder;
6.5 Formatting Field Contents;
6.6 Creating Input Masks;
6.7 Assigning Required Fields and Requiring Data Entry;
6.8 Setting Default Values;
6.9 Indexing Field Values;
6.10 Validating Data Entry;
6.11 Creating a Lookup Field;
6.12 Creating an Append-Only Memo Field;
6.13 Creating an Attachment Field;
Chapter 7: Customizing Tables;
7.1 Finding and Replacing Text;
7.2 Entering Data Using AutoCorrect;
7.3 Adding and Editing Text;
7.4 Manipulating Columns;
7.5 Modifying Columns and Rows;
7.6 Viewing a Subdatasheet;
7.7 Filtering Table Records;
Chapter 8: Creating Forms;
8.1 Creating a Simple Form;
8.2 Creating a Form Using the Form Wizard;
8.3 Creating a Form in Design View;
8.4 Creating a Multiple Items Form;
8.5 Modifying an Existing Form;
8.6 Adding and Deleting Form Controls;
8.7 Adding a Date Picker Control;
8.8 Creating a Subform;
8.9 Displaying a Form and Its Datasheet Simultaneously;
Chapter 9: Creating Queries;
9.1 Introducing Query Types;
9.2 Creating a Query Using the Query Wizard;
9.3 Editing a Query in Design View;
9.4 Using Criteria to Focus Query Results;
9.5 Introducing Operators;
9.6 Using Queries to Calculate Values;
9.7 Finding Duplicate Records;
9.8 Finding Unmatched Records;
9.9 Writing Query Results to a New Table;
9.10 Creating an Update Query;
9.11 Creating a Crosstab Query;
9.12 Finding the Largest and Smallest Values in a Field by Using a Query;
Chapter 10: Creating Reports;
10.1 Creating a Report Using the Report Wizard;
10.2 Creating a Summary Report;
10.3 Creating a Report in Design View;
10.4 Modifying an Existing Report;
10.5 Adding and Deleting Report Controls;
10.6 Calculating Values in a Report;
10.7 Introducing Report Sections;
10.8 Grouping Report Records;
10.9 Creating a Subreport;
10.10 Creating Mailing Labels;
Chapter 11: Beautifying Forms and Reports;
11.1 Formatting Text;
11.2 Applying AutoFormats;
11.3 Setting Control Appearance;
11.4 Adding Lines, Shapes, and Borders;
11.5 Editing Lines and Borders;
11.6 Showing Gridlines in a Report;
11.7 Coloring Alternate Rows in a Form or Report;
11.8 Adding a Totals Row to a Datasheet;
11.9 Adding a Picture;
11.10 Applying Conditional Formatting;
11.11 Changing the Source of an Image;
11.12 Setting Image Alignment and Backing Color;
11.13 Tiling a Picture;
11.14 Setting Image Height and Width;
Chapter 12: Creating Charts in Access;
12.1 Creating a Chart;
12.2 Formatting Chart Elements;
12.3 Customizing Chart Axes;
12.4 Add Information to a Chart;
12.5 Changing a Chart’s Type;
Chapter 13: Interacting with Other Programs;
13.1 Introducing Linking and Embedding;
13.2 Inserting a New Object;
13.3 Manipulating Objects;
13.4 Inserting Excel Charts and Worksheets;
13.5 Importing Data from Another Access Database;
13.6 Linking to a Table in Another Access Database;
13.7 Working with Hyperlinks;
13.8 Importing Data from an Excel File;
13.9 Importing Data from a Text File;
13.10 Importing Data from an XML File;
13.11 Exporting Data to a Text File;
13.12 Exporting Data to Another Access File;
13.13 Exporting Data to an XML File;
13.14 Saving Database Objects as Web Files;
13.15 Analyzing Data with Microsoft Excel;
13.16 Publishing Data to Microsoft Word;
13.17 Collecting Data from E-mail Messages;
Chapter 14: Administering a Database;
14.1 Introducing Database Security;
14.2 Encrypting a Database;
14.3 Locking Database Records;
14.4 Creating a Switchboard;
14.5 Documenting a Database;
14.6 Setting Startup Options;
Chapter 15: Customizing Access;
15.1 Adding Buttons to the Quick Access Toolbar;
15.2 Building a Macro;
15.3 Running a Macro;
15.4 Defining Macro Groups;
15.5 Adding and Deleting Macro Actions;
15.6 Launching a Macro from a Button;
15.7 Displaying a Message Box;
15.8 Running a Macro When a Form Opens;
15.9 Changing AutoCorrect Options;
Chapter 16: Presenting Table and Query Data Dynamically;
16.1 Introducing PivotTables and PivotCharts;
16.2 Creating a PivotTable;
16.3 Adding and Removing PivotTable Fields;
16.4 Pivoting a PivotTable;
16.5 Filtering PivotTable Data;
16.6 Formatting a PivotTable;
16.7 Creating a PivotChart;
About the Author;
Choose the Right Book for You;
Published and Upcoming Titles;