Microsoft Access 2003, 2002, 2000 Level 1

1 Day Training Class

Performance-based objectives of this Microsoft Access training class:

• Understand database concepts and terminology in Access.
• Design and create tables.
• Enter and manipulate data in tables.
• Use Access queries to select and analyze information in a table.
• Create data forms for viewing and inputting data.
• Create reports that summarize and group data.
• Perform database maintenance procedures.

Training Course Content:

Lesson 1: Overview of Access

• Introduction to database concepts and terminology
• An introduction to Access
• 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

What's Next?  DSOC0252 MS Access 2003, 2002, 2000 Level 2

Microsoft Access 2003 training classes in the Nashville Murfreesboro Tennessee area.