Viewpoint
Datahandling for students

'How to' Guide

Invoices Tutorial

This tutorial gives a good all-round demonstration of the main relational features of Viewpoint (except SQL and Scripting).

Library Tutorial

The aim of this tutorial is to describe how to set up a simple but effective Library management system using relational techniques.

In it you will create a table to store the books, a table to store the people using the library and a table to store who borrowed what and when.

The relationship between the three tables is very simple but some time is spent creating difference layouts using the tables in different combinations

Queries Tutorial

This tutorial looks at queries. Queries are at the heart of any relational database, in that they allow you to view and update the data in your various tables in several important ways, namely:

• Sort
• Search
• Join tables or queries
• Summaries
• Update the database

With Viewpoint, you can explicitly construct and use queries, either by choosing them from a menu in browse mode, or by permanently attaching them to various layouts.

Queries are also automatically constructed by Viewpoint when you drag fields from one table to another to create a join, and when you create subviews.

Scripts Tutorial

Viewpoint supports script files, which can be used by external applications to call functions directly.

The script file is just a plain text file with a special file type or extension.

Look at the Script example database below, for a List of functions, classes and statements available to Viewpoint users

A Few Examples of Relational Databases

To download any file, right-click on the database name. You will then be given the option to 'Save this file to disk'. All files run with Viewpoint and should take only a few seconds to download.