Microsoft Office Access 2003 quicksteps / John Cronan, Virginia Andersen, Brenda Bryant Anderson.

Includes index.

Acknowledgments p. vi
Introduction p. xii
Conventions Used in this Book p. xii
Chapter 1 Stepping into Access p. 1
Start Access p. 1
Starting Access p. 2
Use the Start Menu to Start Access p. 2
Tour the Database Window p. 3
Open a Database p. 5
Open Older Databases p. 9
Using Task Panes p. 10
Change the Default Access File Format p. 10
Find a Database p. 11
Personalize Access p. 12
Remove the Getting Started Task Pane p. 12
Select a Toolbar to Display p. 12
Customize a Toolbar p. 13
Using Toolbars p. 14
Show Full Menus p. 14
Using the Keyboard in Access p. 15
View Shortcut Keys p. 15
Rearrange Object Windows p. 15
Using the Keyboard in Windows p. 16
Using Help p. 18
Get Help p. 18
Open Help p. 18
End Your Access Session p. 19
Close a Database p. 19
Close Access p. 20
Chapter 2 Creating a Database p. 21
Create the Database Framework p. 21
Use a Database Template p. 23
Get Access Samples from Microsoft's Office Online p. 28
Build a Database on Your Own p. 32
Build the Framework with Tables p. 34
Start the Table Wizard p. 34
Selecting Tables and Fields from the Table Wizard p. 36
Create a Table with Data Entry p. 39
Build a Table in Design View p. 41
Assigning a Primary Key p. 44
Add Identifying Information p. 45
Identify Relationships p. 45
Define Relationships p. 45
Relate Tables p. 46
Enforce Referential Integrity p. 48
Chapter 3 Modifying Tables and Fields p. 49
Make Basic Changes to Tables and Fields p. 50
Delete a Table p. 50
Rename a Table p. 51
Change Field Names p. 51
Fine Tune the Fields p. 52
Switching Views p. 53
Choose a Data Type p. 53
Change Display of Data Through the Format Property p. 54
Create a Pattern for Data Entry with Input Masks p. 57
Editing and Entering Input Masks p. 58
Establish a Field's Default Value p. 60
Limit Field Values with a Validation Rule p. 60
Require Entry but Allow a Zero Length String p. 61
Use the Caption Field Property p. 62
Index a Data Field p. 63
Add Smart Tags p. 64
Use the Lookup Wizard p. 65
Display and Create Subdatasheets p. 69
View a Subdatasheet p. 69
Create a Subdatasheet p. 70
Chapter 4 Working in the Datasheet p. 73
Enter and Edit Data p. 75
Enter New Data in a Datasheet p. 75
Use Keyboard Shortcuts in a Datasheet p. 77
Moving Through Records p. 78
Selecting Records, Fields, and Columns with the Mouse p. 80
Insert Pictures p. 80
Copy and Move Data p. 81
Delete Records and Columns p. 83
Find and Replace Text p. 84
Verify Spelling p. 86
Acquire Data p. 88
Import Data from Outside Sources p. 89
Paste Data into a Datasheet p. 94
Arrange the Datasheet p. 95
Insert Columns p. 95
Adjust Column Width p. 96
Changing How the Current Datasheet Looks p. 97
Move a Column p. 98
Rename a Column p. 98
Hide and Unhide Columns p. 98
Lock and Unlock Columns p. 98
Adjust Row Height p. 99
Chapter 5 Retrieving Information p. 101
Sort Data p. 101
Sort Records in a Datasheet p. 102
Sort Records in a Form p. 104
Filter Data p. 105
Filter by Selecting a Value p. 105
Choosing a Filter p. 106
Filter by Form p. 107
Deleting or Removing a Filter p. 108
Filter for an Input p. 108
Use Operators and Wildcards in Criteria p. 109
Running and Modifying a Saved Advanced Filter p. 111
Use Advanced Filters p. 111
Work with Queries p. 113
Create a Simple Query with a Wizard p. 113
Create or Modify a Query in Design View p. 115
Using the Expression Builder p. 119
Set Query Properties p. 119
Chapter 6 Creating Forms and Using Controls p. 121
Create Forms p. 121
Creating a Form Using AutoForm p. 122
Get a Head Start with the Form Wizard p. 122
Creating a Two-Table Form p. 126
Create a Form in Design View p. 126
Add Fields p. 128
Explore the Toolbox Tools p. 129
Using the Toolbox p. 130
Modify the Form Design p. 130
Choosing the Control Type p. 133
Use Controls p. 133
Add Bound Controls p. 133
Add Unbound Controls p. 137
Copy or Delete a Control p. 140
Rearrange Controls p. 140
Modify Controls p. 144
Navigating in a Data Entry Form p. 146
Chapter 7 Working with Reports p. 147
Create Reports p. 147
Viewing Reports p. 148
Use AutoReport to Create a Report p. 149
Use the Report Wizard to Create a Report p. 150
Create a Report in Design View p. 154
Modify Reports
Group Data in Reports p. 157
Calculate a Value p. 158
Accomplishing Common Tasks in Reports p. 159
Create a Subreport p. 160
Create Labels p. 162
Create a Report Snapshot p. 164
Distribute a Report Snapshot p. 166
Chapter 8 Preparing Your Data for Presentation p. 167
Improve the Data's Appearance p. 167
Modify Images p. 168
Add a Chart p. 170
Using the Formatting Toolbar p. 173
Use Graphics p. 173
Modify the Form or Report Design p. 174
Print Your Data p. 176
Set Up the Print Job p. 176
Review Data Before Printing p. 180
Output the Print Job p. 183
Choosing What to Print p. 184
Chapter 9 Securing and Administrating Access p. 187
Establish User-Level Security p. 187
Deciding Who Needs What Permissions p. 188
Understand the User-Level Security Model p. 188
Secure the Database with the User-Level Security Wizard p. 188
Keeping Data Safe p. 195
Apply Global Database Protection to a Database p. 195
Use a Database Password p. 196
Remove Database Objects from View p. 198
Back Up and Restore a Database p. 199
Database Administration p. 203
Document a Database p. 203
Compact and Repair a Database p. 204
Chapter 10 Extending Access p. 205
Use Advanced Data Analysis Tools p. 205
Create a Crosstab Query with a Wizard p. 205
Create a PivotTable in Forms p. 208
Create the PivotTable Layout p. 210
Create a PivotChart p. 212
Share Data p. 213
Export Access Data p. 213
Link Files p. 214
Working with OfficeLinks p. 215
Integrate Web Technology p. 217
Add a Hyperlink field to an Existing Table p. 217
Creating a Hyperlink to a File or Web Page p. 218
Save Database Objects as Static Web Pages p. 218
Create a Data Access Page with a Wizard p. 220
Create a User Interface p. 221
Create a Custom Dialog Box p. 222
Add Command Button Controls to a Dialog Box p. 222
Set Dialog Box Properties p. 222
Index p. 223