TY - BOOK AU - AU - Andersen,Virginia AU - Anderson,Brenda Bryant TI - Microsoft Office Access 2003 quicksteps / SN - 9780072232295 AV - QA76.9.D3 C757 2004 PY - 2004/// CY - New York PB - McGraw-Hill/Osborne KW - Database management N1 - 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 ER -