Teach Yourself Visually Access 2003

Chapter 1: GETTING STARTED. Introduction to Access. Start Access. Parts of a Database. Plan a Database. Create a Database Using the Database Wizard. Create a Blank Database. Open a Database. Using the Database Wizard. Rename a Database Object. Delete a Database Object. Minimize a Window. Display or Hide a Toolbar. Search for a Database. Back Up a Database. Getting Help. Chapter 2: CREATE TABLES. Create a Table in the Database View. Create a Table Using the Table Wizard. Open a Table. Change a Column Width. Rename a Field. Rearrange Fields. Add a Field. Delete a Field. Change the Appearance of a Table. Chapter 3: EDIT TABLES. Move Through Data. Select Data. Edit Data. Zoom Into a Cell. Display a Subdatasheet. Check Spelling. Move or Copy Data. Add a Record. Delete a Record. Change the Font of Data. Hide a Field. Freeze a Field. Chapter 4: DESIGN TABLES. Change the View of a Table. Add a Field. Delete a Field. Rearrange Fields. Display Field Properties. Add a Field Description. Change a Data Type. Select a Format. Change the Field Size. Change the Number of Decimal Places. Add a Caption. Set a Default Value. Data Entry Required. Add a Validation Rule. Create an Input Mask. Create a Field to Store Pictures. Create a Lookup Column. Create a Yes/No Field. Create a Hyperlink Field. Using Smart Tags. Chapter 5: ESTABLISH RELATIONSHIPS. View Object Dependencies. Set the Primary Key. Create Relationships Between Tables. Enforce Referential Integrity. Chapter 6: CREATE FORMS. Create a Form Using an AutoForm. Create a Form Using the Form Wizard. Open a Form. Move Through Records. Edit Data. Add a Record. Delete a Record. Chapter 7: DESIGN FORMS. Change the View of a Form. Move or Resize a Control. Delete a Control. Change the Size of a Form. Add a Field. Add a Label. Change Label Text. Bold, Italicize or Underline Data. Change the Font of Data. Change the Size of Data. Change the Color of a Control. Change the Alignment of Data. Undo Changes. Add a Picture. Apply Conditional Formatting. Apply an AutoFormat. Chapter 8: FIND DATA. Sort Records. Find Data. Replace Data. Filter by Selection. Filter by Input. Filter by Exclusion. Filter by Form. Chapter 9: CREATE QUERIES. Create a Query in the Design View. Create Query Using the Simple Query Wizard. Change the View of a Query. Open a Query. Rearrange Fields. Add Fields. Delete a Field. Hide a Field. Sort Query Results. Using Criteria to Find Record. Using Multiple Criteria to Find Records. Examples of Criteria. Display Highest or Lowest Values. Perform Calculations. Using Parameters. Summarize Data. Find Unmatched Records. Chapter 10: USING THE PIVOTTABLE AND PIVOTCHART VIEWS. Using the PivotTable View. Using the PivotChart View. Chapter 11: CREATE REPORTS. Create a Report Using the Report Wizard. Create a Report Using an AutoReport. Open a Report. Move Through Pages. Change the View of a Report. Zoom In or Out. Apply an AutoFormat. Add a Picture. Chapter 12: PRINT INFORMATION. Preview Before Printing. Change Page Setup. Print Information. Create Mailing Labels. Chapter 13: CREATE DATA ACCESS PAGE. Create a Data Access Page. Change the View of a Data Acces Page. Open a Data Access Page. Add a Title. Move Through records. Apply a Theme. Rename a Data Access Page. Delete a Data Access Page.