Select

Introducing Access 2000. Defining Database Terminology. Identifying Access Database Objects. Designing a Database. Launching Microsoft Access and Creating a New Database. Identifying Microsoft Access Screen Elements. Closing Your Database File and Exiting Microsoft Access. Project 1 Creating Access Tables. Opening an Access Database. Creating Tables. Naming Fields and Determining Data Types. Creating a Table Using Table Design View. Creating a Table Using the Table Wizard. Creating a Table by Importing Data from Excel. Adding Records to the Department Table. Creating an AutoForm to Display Records in the Employees Table. Project 2 Establishing Relationships and Modifying Tables. Adding a Lookup Field to the Time Cards Table. Creating and Modifying Relationships. Using the Relationships Window. Printing Relationships. Improving Data Accuracy Using Input Masks and Validation Rules. Adding a Lookup Field to a Table in Design View. Adding Records to the Time Cards Table Using Lookup Lists. Project 3 Manipulating Table Data. Navigating Among Table Records Using Datasheet View. Testing Validation Rules by Adding Records. Searching for Records. Updating Records in a Table. Updating Multiple Records in a Table Using Replace. Sorting Records. Filtering Records. Creating a Data Access Page. Viewing a Data Access Page on the Web. Project 4 Creating Queries. Creating Select Queries. Adding Fields to a Select Query. Creating a Query Displaying Data from Multiple Tables. Adding a Calculated Field to the Query. Defining the Sort Order for a Query. Specifying Query Conditions. Creating an AutoForm Based upon a Query. Project 5 Creating and Modifying Forms. Creating Forms. Creating a New Form Using Design View. Modifying a Form's Controls. Using ControlTips to Improve Data Accuracy. Adding Unbound Controls to a Form. Adding an Image to the Form Using an Unbound Control. Maintaining Table Data Using a Form. Project 6 Creating and Modifying Reports. Creating Reports. Creating a Report Using the Report Wizard. Viewing a Report in the Print Preview Window. Modifying the Report Design for Printing. Creating a Report Using Report Design View. Adding Sorting and Grouping Levels to the Report for Previewing and Printing. Adding a Calculated Control to the Report. Access 2000 Function Reference Guide. Glossary.