Microsoft Access 2003 Training near Nashville Tennessee
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
Microsoft Access 2003 training classes in the Nashville Murfreesboro
Tennessee area.
|
Please Consider our Schedule for Microsoft Access 2003 Training near Nashville Tennessee
Training Schedule
(DSOC0251)
Training for this course is not presently scheduled, but give us a call...
We may be able to schedule a training class for you |
