|
|
|
Microsoft® Access for Power Users: Tables, Forms and Queries
|
Prerequisites
Basic Windows® skills and working knowledge of Access.
Course description
Custom Training Course Learn how to be more effective when using Access. This 1/2 day course is designed to review the three major parts of the software program that you need in order to be most successful.
Why take this course?
Save time and learn the basics of using Access while creating forms and tables. This course covers the building blocks of this powerful database program.
What you will learn
You will find out what Access can do for you, while learning the most popular techniques for organizing your data.
Topics covered include
THE ACCESS ENVIRONMENT
- Name Fields and Add Columns
- Create a Table with the Table Wizard
- Import a Table
- Add, Save, Sort, and Delete Records
- Filter a Table
- Create a Table in Design View
- Add a Lookup Column to a Table
FORMS
- Use AutoForm to Create a Form for a Table
- Work with Data in Form View
- Use the Form Wizard to Create a Form
- Modify Form in Design View
- Add and Format a Label
- Create a Relationship
- Create a Junction Table for a Many-to-Many Relationship
QUERIES
- Create a Select Query with the Simple Query Wizard
- Create a Summary Query
- Multiple-Table Queries
Follow up courses
|
Course details
Course: S 102
Duration: 1/2 Day
Fee:
| Members: |
|
112.00 |
| Non-Members: |
|
160.00 |
Instructor:
|
|
|
|
