Access 2007: In Easy Steps

Getting Started     7
What is Access 2007?     8
The Getting Started Screen     9
The Quick Access Toolbar     10
Using the Office Button     12
Personalizing Access 2007     15
Converting Older Databases     16
Using Office Online     18
Get Training Online     19
Downloading New Content     20
Downloading New Templates     21
Using Templates     22
Using the Ribbon     24
Using the Navigation Pane     25
Using the Help System     26
Designing Databases     27
Relational Databases     28
Relationship Types     30
Database Design     32
Before You Even Start Access     33
Designing Tables     34
Primary and Foreign Keys     35
Fine-Tuning Your Design     36
Creating Tables     37
The Table Window     38
Using Table Templates     39
Using Datasheet View     40
Adding and Deleting Fields     41
Data Types in Datasheet View     43
Using Design View     44
Creating aTable     45
Inserting a Design View Row     46
Deleting a Design View Field     47
Setting the Primary Key     48
Using Data Types     49
Using Attachments     51
Specifying Field Properties     52
Using Validation Rules     53
Creating an Input Mask     54
Setting a Default Value     55
Using Indexes     56
Creating a Lookup Column     58
Defining Relationship     61
The Relationships Window     62
Adding Tables     63
Specifying Relationships     64
Referential Integrity     56
Specifying Join Properties     68
Left and Right Joins     70
Working With Data     71
Entering Data     72
Inserting Rows     73
Using the Clipboard     74
Copying and Pasting Data     75
Copying Directly from Excel     76
Copying Data to Excel     77
Importing Data from Excel     78
Importing Data from Access     83
Linking to Access Databases     85
Managing Import Tasks     87
Collecting Data with Email     88
Filtering Data     94
Totalling Columns     96
Spell-Checking Data     97
Formatting Data     98
Querying Databases     101
What is a Query?     102
Using the Query Wizard     103
Query Design View     106
Adding Criteria to a Query     108
Querying Multiple Tables     109
Using Criteria for Numbers     110
Using Criteria for Text     111
Creating a Make Table Query     112
Creating an Append Query     114
Creating an Update Query     115
Creating a Delete Query     116
Using SQL     117
Using SQL     118
The Three Languages of SQL     119
Opening the SQL Window     120
Using the Select Clause     121
Using the Where Clause     122
SQL Aggregate Functions     123
Creating Union Queries     124
Creating Forms     125
What is a Form?     126
The Anatomy of a Form     127
Using a Form for Data Entry     128
Filtering Forms     130
Applying a Detailed Filter     131
Using the Form Wizard     132
Creating a Simple Form     135
Using Split Forms     136
Using Multiple Item Forms     139
Finding a Record     140
Fine-Tuning Forms     141
Using Design View     142
Using Layout View     143
Using the Field List     144
Adding Headers and Footers     145
Adding Controls to a Form     146
Fine-Tuning Controls     147
Changing Control Properties     148
Creating Calculated Controls     149
Changing Tab Order     150
Creating a Tabbed Form     151
Using Buttons     154
Creating a Modal Dialog     156
Using Macros     160
Creating Reports     161
Using the Report Wizard     162
Creating a Simple Report     166
Using Report Design View     167
Adding Fields to a Report     168
Adding Controls to a Report     169
Adding Headers and Footers     170
Sorting and Grouping Data     171
Printing Labels     172
Setting Custom Label Sizes      175
Using Print Preview     176
Printing Reports     177
Send Your Report via Email     178
Sharing Access     179
Password Protection     180
Making an ACCDE Database     182
Backing-up Access Databases     183
Splitting a Database     184
Interacting with SharePoint     186
Index     187