|
Access 2000: Introduction (2 Day)
Prerequisites: Windows: Introduction or
equivalent knowledge
Lesson 1: Overview of Access 2000
- Introduction to database concepts and
terminology
- An 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
- Adding records
- Modifying the table design
- Finding and editing records
- Deleting, adding, and copying records and
values
- Filtering and sorting records
Lesson 4: Using select queries
- Selecting fields and sorting records
- Refining the results of a query
- Using queries to perform calculations
- Joining tables in a query
Lesson 5: Creating and using forms
- Creating a form
- Modifying the form design
- Using a form to locate and organize
information
- Multiple-table forms
Lesson 6: Creating and using reports
- Creating a report
- 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
Lesson 14: Customizing reports
- Customizing a report created by the Report
Wizard
- Working with subreports
|
