Ships from: Wilmington, NC
Usually ships in 1-2 business days
Ships from: Westminster, MD
Usually ships in 1-2 business days
Learn Instantly from Step-by-Step Graphics!
We know a picture is worth a thousand words—so we went heavy on pictures and light on words in this easy-to-use guide. Color screenshots and brief instructions show you how to use all the powerful Access features in no time. Follow along and learn to create and use databases, enter and retrieve data, present your information in forms and reports, and so much more. Each chapter’s “How to” list and color-coded tabs make it easy to flip straight to the tasks you need to do. Get the book that gets you started using Access right away.
In Each Chapter:
John Cronan has been writing and editing computer-related materials for more than 12 years and is the author of Microsoft Office Excel QuickSteps.
Virginia Andersen has written or contributed to more than 35 computer books, including Access 2003: The Complete Reference and How to Do Everything with Access 2003. She has more than 25 years of computer experience.
Brenda Bryant Anderson has spent more than 10 years training individuals on a wide range of Microsoft products. She is currently an instructor of beginner through advanced computer applications at the collegiate level.
| Acknowledgments | vi | |
| Introduction | xii | |
| Conventions Used in this Book | xii | |
| Chapter 1 | Stepping into Access | 1 |
| Start Access | 1 | |
| Starting Access | 2 | |
| Use the Start Menu to Start Access | 2 | |
| Tour the Database Window | 3 | |
| Open a Database | 5 | |
| Open Older Databases | 9 | |
| Using Task Panes | 10 | |
| Change the Default Access File Format | 10 | |
| Find a Database | 11 | |
| Personalize Access | 12 | |
| Remove the Getting Started Task Pane | 12 | |
| Select a Toolbar to Display | 12 | |
| Customize a Toolbar | 13 | |
| Using Toolbars | 14 | |
| Show Full Menus | 14 | |
| Using the Keyboard in Access | 15 | |
| View Shortcut Keys | 15 | |
| Rearrange Object Windows | 15 | |
| Using the Keyboard in Windows | 16 | |
| Using Help | 18 | |
| Get Help | 18 | |
| Open Help | 18 | |
| End Your Access Session | 19 | |
| Close a Database | 19 | |
| Close Access | 20 | |
| Chapter 2 | Creating a Database | 21 |
| Create the Database Framework | 21 | |
| Use a Database Template | 23 | |
| Get Access Samples from Microsoft's Office Online | 28 | |
| Build a Database on Your Own | 32 | |
| Build the Framework with Tables | 34 | |
| Start the Table Wizard | 34 | |
| Selecting Tables and Fields from the Table Wizard | 36 | |
| Create a Table with Data Entry | 39 | |
| Build a Table in Design View | 41 | |
| Assigning a Primary Key | 44 | |
| Add Identifying Information | 45 | |
| Identify Relationships | 45 | |
| Define Relationships | 45 | |
| Relate Tables | 46 | |
| Enforce Referential Integrity | 48 | |
| Chapter 3 | Modifying Tables and Fields | 49 |
| Make Basic Changes to Tables and Fields | 50 | |
| Delete a Table | 50 | |
| Rename a Table | 51 | |
| Change Field Names | 51 | |
| Fine Tune the Fields | 52 | |
| Switching Views | 53 | |
| Choose a Data Type | 53 | |
| Change Display of Data Through the Format Property | 54 | |
| Create a Pattern for Data Entry with Input Masks | 57 | |
| Editing and Entering Input Masks | 58 | |
| Establish a Field's Default Value | 60 | |
| Limit Field Values with a Validation Rule | 60 | |
| Require Entry but Allow a Zero Length String | 61 | |
| Use the Caption Field Property | 62 | |
| Index a Data Field | 63 | |
| Add Smart Tags | 64 | |
| Use the Lookup Wizard | 65 | |
| Display and Create Subdatasheets | 69 | |
| View a Subdatasheet | 69 | |
| Create a Subdatasheet | 70 | |
| Chapter 4 | Working in the Datasheet | 73 |
| Enter and Edit Data | 75 | |
| Enter New Data in a Datasheet | 75 | |
| Use Keyboard Shortcuts in a Datasheet | 77 | |
| Moving Through Records | 78 | |
| Selecting Records, Fields, and Columns with the Mouse | 80 | |
| Insert Pictures | 80 | |
| Copy and Move Data | 81 | |
| Delete Records and Columns | 83 | |
| Find and Replace Text | 84 | |
| Verify Spelling | 86 | |
| Acquire Data | 88 | |
| Import Data from Outside Sources | 89 | |
| Paste Data into a Datasheet | 94 | |
| Arrange the Datasheet | 95 | |
| Insert Columns | 95 | |
| Adjust Column Width | 96 | |
| Changing How the Current Datasheet Looks | 97 | |
| Move a Column | 98 | |
| Rename a Column | 98 | |
| Hide and Unhide Columns | 98 | |
| Lock and Unlock Columns | 98 | |
| Adjust Row Height | 99 | |
| Chapter 5 | Retrieving Information | 101 |
| Sort Data | 101 | |
| Sort Records in a Datasheet | 102 | |
| Sort Records in a Form | 104 | |
| Filter Data | 105 | |
| Filter by Selecting a Value | 105 | |
| Choosing a Filter | 106 | |
| Filter by Form | 107 | |
| Deleting or Removing a Filter | 108 | |
| Filter for an Input | 108 | |
| Use Operators and Wildcards in Criteria | 109 | |
| Running and Modifying a Saved Advanced Filter | 111 | |
| Use Advanced Filters | 111 | |
| Work with Queries | 113 | |
| Create a Simple Query with a Wizard | 113 | |
| Create or Modify a Query in Design View | 115 | |
| Using the Expression Builder | 119 | |
| Set Query Properties | 119 | |
| Chapter 6 | Creating Forms and Using Controls | 121 |
| Create Forms | 121 | |
| Creating a Form Using AutoForm | 122 | |
| Get a Head Start with the Form Wizard | 122 | |
| Creating a Two-Table Form | 126 | |
| Create a Form in Design View | 126 | |
| Add Fields | 128 | |
| Explore the Toolbox Tools | 129 | |
| Using the Toolbox | 130 | |
| Modify the Form Design | 130 | |
| Choosing the Control Type | 133 | |
| Use Controls | 133 | |
| Add Bound Controls | 133 | |
| Add Unbound Controls | 137 | |
| Copy or Delete a Control | 140 | |
| Rearrange Controls | 140 | |
| Modify Controls | 144 | |
| Navigating in a Data Entry Form | 146 | |
| Chapter 7 | Working with Reports | 147 |
| Create Reports | 147 | |
| Viewing Reports | 148 | |
| Use AutoReport to Create a Report | 149 | |
| Use the Report Wizard to Create a Report | 150 | |
| Create a Report in Design View | 154 | |
| Modify Reports | ||
| Group Data in Reports | 157 | |
| Calculate a Value | 158 | |
| Accomplishing Common Tasks in Reports | 159 | |
| Create a Subreport | 160 | |
| Create Labels | 162 | |
| Create a Report Snapshot | 164 | |
| Distribute a Report Snapshot | 166 | |
| Chapter 8 | Preparing Your Data for Presentation | 167 |
| Improve the Data's Appearance | 167 | |
| Modify Images | 168 | |
| Add a Chart | 170 | |
| Using the Formatting Toolbar | 173 | |
| Use Graphics | 173 | |
| Modify the Form or Report Design | 174 | |
| Print Your Data | 176 | |
| Set Up the Print Job | 176 | |
| Review Data Before Printing | 180 | |
| Output the Print Job | 183 | |
| Choosing What to Print | 184 | |
| Chapter 9 | Securing and Administrating Access | 187 |
| Establish User-Level Security | 187 | |
| Deciding Who Needs What Permissions | 188 | |
| Understand the User-Level Security Model | 188 | |
| Secure the Database with the User-Level Security Wizard | 188 | |
| Keeping Data Safe | 195 | |
| Apply Global Database Protection to a Database | 195 | |
| Use a Database Password | 196 | |
| Remove Database Objects from View | 198 | |
| Back Up and Restore a Database | 199 | |
| Database Administration | 203 | |
| Document a Database | 203 | |
| Compact and Repair a Database | 204 | |
| Chapter 10 | Extending Access | 205 |
| Use Advanced Data Analysis Tools | 205 | |
| Create a Crosstab Query with a Wizard | 205 | |
| Create a PivotTable in Forms | 208 | |
| Create the PivotTable Layout | 210 | |
| Create a PivotChart | 212 | |
| Share Data | 213 | |
| Export Access Data | 213 | |
| Link Files | 214 | |
| Working with OfficeLinks | 215 | |
| Integrate Web Technology | 217 | |
| Add a Hyperlink field to an Existing Table | 217 | |
| Creating a Hyperlink to a File or Web Page | 218 | |
| Save Database Objects as Static Web Pages | 218 | |
| Create a Data Access Page with a Wizard | 220 | |
| Create a User Interface | 221 | |
| Create a Custom Dialog Box | 222 | |
| Add Command Button Controls to a Dialog Box | 222 | |
| Set Dialog Box Properties | 222 | |
| Index | 223 |
Bird48327
Posted Tue Feb 17 00:00:00 EST 2009
A good review and restart for people who have used Access in the past. Easy to follow; good foundation builder.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
Learn Instantly from Step-by-Step Graphics!
We know a picture is worth a thousand words?so we went heavy on pictures and light on words in this easy-to-use guide. Color screenshots and brief instructions show you how to use all the powerful Access features in no time. Follow along and learn to create and use databases, enter and retrieve data, present your information in forms and reports, and so much more. Each chapter?s ?How to? list and color-coded tabs make it easy to flip ...