Microsoft Access

Microsoft Access 2000 - Part One This course covers how to design and create databases, tables, queries, forms, reports and the basic skills necessary to use Access 2000. Lesson 1: Overview of Access 2000 Introduction to Database Concepts and Terminology Introduction to Access 2000 Database Planning and Design Lesson 2: Creating tables Examining a Table Creating a Table With the Table Wizard Creating a Table in Design View Types of Primary Keys Lesson 3: Working with tables Modifying a Table Using Design View Finding and Editing Records Filtering and Sorting Records Lesson 4: Creating and Using Select Queries Creating a Select Query to View Specific Fields Specifying Criteria in a Query to View Specific Records Using Queries to Perform Calculations Joining Tables in a Query Lesson 5: Creating and Using Forms Creating a Form With the Form Wizard Modifying the Form Design Using a Form to Locate and Organize Information Multiple-Table Forms Lesson 6: Creating and Using Reports Creating a Report With the Report Wizard Creating a Report That Contains Totals Lesson 7: Creating and Maintaining a Database Creating a Database Managing a Database and Its Objects Database Maintenance Lesson 8: Principles of Table Design Normalizing Data Normalizing Data for Fourth and Fifth Normal Forms Lesson 9: Principles of Table Relationships Analyzing Table Relationships Establishing and Testing Referential Integrity Lesson 10: Table Design Techniques Data Validation Techniques Indexing Techniques Lesson 11: Designing Select Queries Using Calculated Fields in Queries Creating Multiple-Table Queries Lesson 12: Customizing Form Designs Customizing the Form Design Performing Calculations on a Form Adding Combo Boxes to a Form Adding Unbound Controls Lesson 13: Working with Data Access Pages Creating Data Access Pages Integrating with Other Applications Lesson 14: Customizing Reports Customizing a Report Created by the Report Wizard Working with Subreports Creating a Report in Design View Microsoft Access 2000 - Part 2 This course teaches how to use complex query techniques, create efficient forms and reports, and create macros to automate their forms. In addition, the course covers Internet-related features, including hyperlinks and the Web toolbar. Lesson 1: Parameter and Action Queries Creating parameter queries Creating action queries Lesson 2: Query Joins and Crosstab Queries Joining tables and working with join properties Creating crosstab queries Editing limitations in query datasheets Lesson 3: Using Advanced Form Techniques Organizing field placement Using functions to control data entry Adding an option group to a form Using a form as the user interface Creating a form that contains a subform Lesson 4: Creating Basic Macros to Automate Forms Macro basics Attaching a macro to a command button Revising a macro Attaching a macro to an event in a form Lesson 5: Using Macros to Provide User Interaction and Automate Tasks Using a macro to provide user interaction Using macros to automate data entry AutoKeys and AutoExec macros Lesson 6: Using Advanced Report Techniques Customizing the appearance and functionality of a report Mailing and other types of labels Lesson 7: Web Capabilities and Data Integration Using hyperlinks Data integration