| |
| |
| The Missing Credits | |
| |
| |
| Introduction | |
| |
| |
| What's a Database? | |
| |
| |
| About Access Databases | |
| |
| |
| About This Book | |
| |
| |
| The Very Basics | |
| |
| |
| Example Databases | |
| |
| |
| About Missing | |
| |
| |
| Manuals.com | |
| |
| |
| Safari Enabled | |
| |
| |
| |
| Building a database | |
| |
| |
| |
| Creating Databases 15 | |
| |
| |
| A Tour of an Access Database | |
| |
| |
| The Access Window | |
| |
| |
| Tables | |
| |
| |
| Forms | |
| |
| |
| Queries | |
| |
| |
| Reports | |
| |
| |
| Putting It All Together | |
| |
| |
| Creating a New Database | |
| |
| |
| Starting with a Wizard | |
| |
| |
| |
| Choosing Your Template | |
| |
| |
| |
| Choosing Table Fields | |
| |
| |
| |
| Choosing Styles for Forms and Reports | |
| |
| |
| |
| Adding a Title and a Picture | |
| |
| |
| Modifying the Wizard's Database | |
| |
| |
| Opening a Database | |
| |
| |
| Navigating with the Switchboard | |
| |
| |
| Adjusting Table Designs | |
| |
| |
| Adding Records Using a Form | |
| |
| |
| Printing a Report | |
| |
| |
| Starting from a Blank Database | |
| |
| |
| |
| Creating Tables to Hold Data 53 | |
| |
| |
| Planning Your Tables | |
| |
| |
| Creating Tables with the Wizard | |
| |
| |
| |
| Starting the Table Wizard | |
| |
| |
| |
| Choosing Fields for Your Table | |
| |
| |
| |
| Naming Your Table and Setting a Primary Key | |
| |
| |
| |
| Creating Your Table | |
| |
| |
| Creating Tables in the Design Window | |
| |
| |
| Adding Fields | |
| |
| |
| Choosing Data Types | |
| |
| |
| Setting Field Properties | |
| |
| |
| Adding and Editing Table Data | |
| |
| |
| Adding Records to a Datasheet | |
| |
| |
| Editing Records in a DatasheetChanging How a Table Displays Data | |
| |
| |
| |
| Creating Forms to Add and Display Data 89 | |
| |
| |
| Form Basics | |
| |
| |
| Form Layouts | |
| |
| |
| Controls | |
| |
| |
| Properties and the Property | |
| |
| |
| SheetCreating AutoformsCreating Forms with the Form Wizard | |
| |
| |
| |
| Choosing a Record Source | |
| |
| |
| |
| Choosing Fields | |
| |
| |
| |
| Choosing a Form Layout | |
| |
| |
| |
| Choosing a Form Style | |
| |
| |
| |
| Naming and Saving the FormModifying the Form Design | |
| |
| |
| Editing the Labels | |
| |
| |
| Adding a Title in the Form Header | |
| |
| |
| Dragging a Control | |
| |
| |
| Creating Forms in Design View | |
| |
| |
| |
| Starting Your Design | |
| |
| |
| |
| Choosing a Data Source | |
| |
| |
| |
| Adding Fields to the Form | |
| |
| |
| |
| Adding Images to the Form | |
| |
| |
| |
| Adding a Form Style | |
| |
| |
| |
| Naming and Saving the Form | |
| |
| |
| |
| Linking Tables to Combine Data 123 | |
| |
| |
| Why Relate? | |
| |
| |
| A Relational Database Tour | |
| |
| |
| Common Fields | |
| |
| |
| Subdatasheets and Subforms | |
| |
| |
| Linking Tables in the Relationships Window | |
| |
| |
| Adding Tables to the Relationships Window | |
| |
| |
| Adding Relationships Between Tables | |
| |
| |
| Modifying or Deleting Relationships | |
| |
| |
| Printing Relationships | |
| |
| |
| Using Subdatasheets to View Related Items | |
| |
| |
| Creating Subforms | |
| |
| |
| Adding Information in a Subform | |
| |
| |
| |
| Organizing information | |
| |
| |
| |
| Sorting and Filtering 153 | |
| |
| |
| Sorting Database Records | |
| |
| |
| Ascending Sorts | |
| |
| |
| Descending Sorts | |
| |
| |
| Sorting on Multiple Fields | |
| |
| |
| Saving Your Sorting Choice | |
| |
| |
| Finding Data with Filters | |
| |
| |
| Filtering by Selection: The Quick Way to Filter | |
| |
| |
| Filtering by Form | |
| |
| |
| Filtering with Wildcards, Operators, and Expressions | |
| |
| |
| Using Advanced Filter/Sort | |
| |
| |
| |
| Finding Data with Queries 183 | |
| |
| |
| Types of Queries | |
| |
| |
| Select Query | |
| |
| |
| Crosstab Query | |
| |
| |
| Parameter Query | |
| |
| |
| Action Query | |
| |
| |
| Autolookup Query | |
| |
| |
| SQL Query | |
| |
| |
| Setting Query Properties | |
| |
| |
| Creating Queries with the Query Wizard | |
| |
| |
| Creating a Simple Query | |
| |
| |
| Creating a Crosstab Query | |
| |
| |
| Using a Query to Check for Duplicate Records | |
| |
| |
| Creating a Find Unmatched Query | |
| |
| |
| Saving, Deleting, and Printing Queries | |
| |
| |
| |
| Creating Custom Queries 219 | |
| |
| |
| Creating Queries in the Query Design Window | |
| |
| |
| Using Criteria in Queries | |
| |
| |
| Crafting a Custom Query Using the Query Design Window | |
| |
| |
| Tweaking Your Custom Query | |
| |
| |
| Getting Sums, Totals, and Averages from Your Database | |
| |
| |
| Using Expression Builder | |
| |
| |
| |
| Generating Reports 257 | |
| |
| |
| Report BasicsHow Reports Differ from Forms | |
| |
| |
| Types of Access Reports | |
| |
| |
| Two Ways to Create Reports | |
| |
| |
| Displaying and Printing Reports | |
| |
| |
| Parts of a Report | |
| |
| |
| Report Design Sections | |
| |
| |
| Using the Report Wizard | |
| |
| |
| Starting the Wizard | |
| |
| |
| Choosing the Report Type | |
| |
| |
| Choosing the Data Source | |
| |
| |
| Choosing the FieldsGrouping the Report Data | |
| |
| |
| Sorting the Report Data | |
| |
| |
| Choosing a Report Layout | |
| |
| |
| Choosing a Report Style | |
| |
| |
| Adding a Report Title | |
| |
| |
| |
| Appendixes | |
| |
| |
| |
| Help and Installation 287 | |
| |
| |
| Installing Access 2003 288 | |
| |
| |
| Access Help | |
| |
| |
| Visiting Microsoft Office Online | |
| |
| |
| |
| Access FAQ 313 | |
| |
| |
| Importing and Exporting | |
| |
| |
| Validation | |
| |
| |
| Finding Find | |
| |
| |
| |
| Access 2003, Menu by Menu 337 | |
| |
| |
| File Menu | |
| |
| |
| Edit Menu | |
| |
| |
| View Menu | |
| |
| |
| Insert Menu | |
| |
| |
| Format Menu | |
| |
| |
| Records Menu | |
| |
| |
| Tools Menu | |
| |
| |
| Window Menu | |
| |
| |
| Help Menu | |
| |
| |
| Index | |