Course Objectives
Approach is an end-user Windows database management system that has been designed to be powerful and yet easy to use. This one day course will give participants a firm grounding in Approach fundamentals, as well as providing a sound basis for, and encouraging, exploration of the product's more powerful features. All the standard database commands will be covered including creating, working with, querying, reporting and sorting data files.
Who Should Attend?
Those that are new to Approach and require an introduction to the application, and those who have been working with the package already but have not yet realised it's potential. Some understanding of using a Personal Computer will be expected, including some experience of operating windows based programs. The topics covered on our "Introduction to Windows" course are an adequate prerequisite for this course.
Course Content
What is Approach?
Connectivity/file formats.
- Direct access via Powerkeys
- Access via Import/Export
- Graphical file types
Database concepts.
- What is a database?
- What is a Database Management System (DBMS)?
- What is a relational database?
- What are records and fields?
Creating a new database.
Working with existing data.
Design mode.
- Aligning fields
- Adding graphics
- Adding text Drawing lines
- Adding colour
- Adding a check box
- Automatic data entry
- Read only field
- Value lists
Browse Mode.
- Entering and deleting records
Searching for data.
Relational joins.
Reports.
- Reports vs. Forms
- Form letters
- Mailing labels
- Summaries including calculated fields
Creating macros.
Security passwords.
Shortmenus.
