Click on a course
for more information.
MS Access 1
Objectives
At the completion of this training session, you will be able to:
- Design a simple database
- Normalize a database
- Use Access' Datasheet View and Design View
- Enter, edit, and view data
- Sort, find, and replace data
- Use Query by Example to query a database
- Work with field properties
- Create a look-up field
- Perform multi-table, calculated, total, and parameter queries
2 Days, $350
MS Access 2
Objectives
At the completion of this training session, you will be able to:
- Import, export, and link data
- Establish and edit permanent relationships
- Work with query joins
- Perform action queries such as insert into and update
- Run and modify the duplicate query wizard
- Run and modify the unmatched query wizard
2 Days, $350
MS Access 3
Objectives
At the completion of this training session, you will be able to:
- Learn to design and modify custom forms.
- Work with form properties.
- Learn to design and modify custom reports.
- Create reports with grouping, sorting and calculations.
- Work with control properties.
2 Days, $350
MS Access Programming
Objectives
At the completion of this training session, you will be able to:
- Automate Access using non-programming techniques
- Create macros
- Automate forms using Visual Basic for Applications (VBA)
- Use custom menus and toolbars
2 Days, $375
