| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| Conventions Used in this Book | |
| |
| |
| |
| Stepping into Access | |
| |
| |
| Start Access | |
| |
| |
| Starting Access | |
| |
| |
| Use the Start Menu to Start Access | |
| |
| |
| Tour the Database Window | |
| |
| |
| Open a Database | |
| |
| |
| Open Older Databases | |
| |
| |
| Using Task Panes | |
| |
| |
| Change the Default Access File Format | |
| |
| |
| Find a Database | |
| |
| |
| Personalize Access | |
| |
| |
| Remove the Getting Started Task Pane | |
| |
| |
| Select a Toolbar to Display | |
| |
| |
| Customize a Toolbar | |
| |
| |
| Using Toolbars | |
| |
| |
| Show Full Menus | |
| |
| |
| Using the Keyboard in Access | |
| |
| |
| View Shortcut Keys | |
| |
| |
| Rearrange Object Windows | |
| |
| |
| Using the Keyboard in Windows | |
| |
| |
| Using Help | |
| |
| |
| Get Help | |
| |
| |
| Open Help | |
| |
| |
| End Your Access Session | |
| |
| |
| Close a Database | |
| |
| |
| Close Access | |
| |
| |
| |
| Creating a Database | |
| |
| |
| Create the Database Framework | |
| |
| |
| Use a Database Template | |
| |
| |
| Get Access Samples from Microsoft's Office Online | |
| |
| |
| Build a Database on Your Own | |
| |
| |
| Build the Framework with Tables | |
| |
| |
| Start the Table Wizard | |
| |
| |
| Selecting Tables and Fields from the Table Wizard | |
| |
| |
| Create a Table with Data Entry | |
| |
| |
| Build a Table in Design View | |
| |
| |
| Assigning a Primary Key | |
| |
| |
| Add Identifying Information | |
| |
| |
| Identify Relationships | |
| |
| |
| Define Relationships | |
| |
| |
| Relate Tables | |
| |
| |
| Enforce Referential Integrity | |
| |
| |
| |
| Modifying Tables and Fields | |
| |
| |
| Make Basic Changes to Tables and Fields | |
| |
| |
| Delete a Table | |
| |
| |
| Rename a Table | |
| |
| |
| Change Field Names | |
| |
| |
| Fine Tune the Fields | |
| |
| |
| Switching Views | |
| |
| |
| Choose a Data Type | |
| |
| |
| Change Display of Data Through the Format Property | |
| |
| |
| Create a Pattern for Data Entry with Input Masks | |
| |
| |
| Editing and Entering Input Masks | |
| |
| |
| Establish a Field's Default Value | |
| |
| |
| Limit Field Values with a Validation Rule | |
| |
| |
| Require Entry but Allow a Zero Length String | |
| |
| |
| Use the Caption Field Property | |
| |
| |
| Index a Data Field | |
| |
| |
| Add Smart Tags | |
| |
| |
| Use the Lookup Wizard | |
| |
| |
| Display and Create Subdatasheets | |
| |
| |
| View a Subdatasheet | |
| |
| |
| Create a Subdatasheet | |
| |
| |
| |
| Working in the Datasheet | |
| |
| |
| Enter and Edit Data | |
| |
| |
| Enter New Data in a Datasheet | |
| |
| |
| Use Keyboard Shortcuts in a Datasheet | |
| |
| |
| Moving Through Records | |
| |
| |
| Selecting Records, Fields, and Columns with the Mouse | |
| |
| |
| Insert Pictures | |
| |
| |
| Copy and Move Data | |
| |
| |
| Delete Records and Columns | |
| |
| |
| Find and Replace Text | |
| |
| |
| Verify Spelling | |
| |
| |
| Acquire Data | |
| |
| |
| Import Data from Outside Sources | |
| |
| |
| Paste Data into a Datasheet | |
| |
| |
| Arrange the Datasheet | |
| |
| |
| Insert Columns | |
| |
| |
| Adjust Column Width | |
| |
| |
| Changing How the Current Datasheet Looks | |
| |
| |
| Move a Column | |
| |
| |
| Rename a Column | |
| |
| |
| Hide and Unhide Columns | |
| |
| |
| Lock and Unlock Columns | |
| |
| |
| Adjust Row Height | |
| |
| |
| |
| Retrieving Information | |
| |
| |
| Sort Data | |
| |
| |
| Sort Records in a Datasheet | |
| |
| |
| Sort Records in a Form | |
| |
| |
| Filter Data | |
| |
| |
| Filter by Selecting a Value | |
| |
| |
| Choosing a Filter | |
| |
| |
| Filter by Form | |
| |
| |
| Deleting or Removing a Filter | |
| |
| |
| Filter for an Input | |
| |
| |
| Use Operators and Wildcards in Criteria | |
| |
| |
| Running and Modifying a Saved Advanced Filter | |
| |
| |
| Use Advanced Filters | |
| |
| |
| Work with Queries | |
| |
| |
| Create a Simple Query with a Wizard | |
| |
| |
| Create or Modify a Query in Design View | |
| |
| |
| Using the Expression Builder | |
| |
| |
| Set Query Properties | |
| |
| |
| |
| Creating Forms and Using Controls | |
| |
| |
| Create Forms | |
| |
| |
| Creating a Form Using AutoForm | |
| |
| |
| Get a Head Start with the Form Wizard | |
| |
| |
| Creating a Two-Table Form | |
| |
| |
| Create a Form in Design View | |
| |
| |
| Add Fields | |
| |
| |
| Explore the Toolbox Tools | |
| |
| |
| Using the Toolbox | |
| |
| |
| Modify the Form Design | |
| |
| |
| Choosing the Control Type | |
| |
| |
| Use Controls | |
| |
| |
| Add Bound Controls | |
| |
| |
| Add Unbound Controls | |
| |
| |
| Copy or Delete a Control | |
| |
| |
| Rearrange Controls | |
| |
| |
| Modify Controls | |
| |
| |
| Navigating in a Data Entry Form | |
| |
| |
| |
| Working with Reports | |
| |
| |
| Create Reports | |
| |
| |
| Viewing Reports | |
| |
| |
| Use AutoReport to Create a Report | |
| |
| |
| Use the Report Wizard to Create a Report | |
| |
| |
| Create a Report in Design View | |
| |
| |
| Modify Reports | |
| |
| |
| Group Data in Reports | |
| |
| |
| Calculate a Value | |
| |
| |
| Accomplishing Common Tasks in Reports | |
| |
| |
| Create a Subreport | |
| |
| |
| Create Labels | |
| |
| |
| Create a Report Snapshot | |
| |
| |
| Distribute a Report Snapshot | |
| |
| |
| |
| Preparing Your Data for Presentation | |
| |
| |
| Improve the Data's Appearance | |
| |
| |
| Modify Images | |
| |
| |
| Add a Chart | |
| |
| |
| Using the Formatting Toolbar | |
| |
| |
| Use Graphics | |
| |
| |
| Modify the Form or Report Design | |
| |
| |
| Print Your Data | |
| |
| |
| Set Up the Print Job | |
| |
| |
| Review Data Before Printing | |
| |
| |
| Output the Print Job | |
| |
| |
| Choosing What to Print | |
| |
| |
| |
| Securing and Administrating Access | |
| |
| |
| Establish User-Level Security | |
| |
| |
| Deciding Who Needs What Permissions | |
| |
| |
| Understand the User-Level Security Model | |
| |
| |
| Secure the Database with the User-Level Security Wizard | |
| |
| |
| Keeping Data Safe | |
| |
| |
| Apply Global Database Protection to a Database | |
| |
| |
| Use a Database Password | |
| |
| |
| Remove Database Objects from View | |
| |
| |
| Back Up and Restore a Database | |
| |
| |
| Database Administration | |
| |
| |
| Document a Database | |
| |
| |
| Compact and Repair a Database | |
| |
| |
| |
| Extending Access | |
| |
| |
| Use Advanced Data Analysis Tools | |
| |
| |
| Create a Crosstab Query with a Wizard | |
| |
| |
| Create a PivotTable in Forms | |
| |
| |
| Create the PivotTable Layout | |
| |
| |
| Create a PivotChart | |
| |
| |
| Share Data | |
| |
| |
| Export Access Data | |
| |
| |
| Link Files | |
| |
| |
| Working with OfficeLinks | |
| |
| |
| Integrate Web Technology | |
| |
| |
| Add a Hyperlink field to an Existing Table | |
| |
| |
| Creating a Hyperlink to a File or Web Page | |
| |
| |
| Save Database Objects as Static Web Pages | |
| |
| |
| Create a Data Access Page with a Wizard | |
| |
| |
| Create a User Interface | |
| |
| |
| Create a Custom Dialog Box | |
| |
| |
| Add Command Button Controls to a Dialog Box | |
| |
| |
| Set Dialog Box Properties | |
| |
| |
| Index | |