Introducing Approach
An overview of the power and benefits of computer databases.
Some terminology.
A tour of the Approach screen.


Relational Database
What they are and why relational database are useful.
How data in different tables can be related.


Tables & Relationships
Creating tables and fields.
Setting field attributes.
Creating, displaying and editing relationships.
One-to-one and one-to-many joins.


Forms
Using form and list views.
Creating forms.
Using controls such as radio buttons and check boxes for data entry.
Simple calculated expressions.


Data Entry & Editing
Adding and editing records.
Navigating through data.
Finding specific records, sorting and filtering.


Reporting
Creating simple reports.
Changing report definitions.
Printer set up and printing.
Summary reports.
Mail-merge documents and labels.


Queries
Building and using queries to select data.


Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

Course Overview:

As a new user, with little or no experience of Lotus Approach, the topics covered on this course will allow you to create and maintain a simple relational database.

Course Duration:

Course Pre-requisites:

• Create a basic database structure.
• Create standard forms for inputting and amending your data.
• Use simple queries to manipulate your data.
• Produce simple reports.

Price Band:

 Specialised