Osel - Help with Access

An Access Database is a container. Within the container are objects which include tables, queries, forms and reports.

Objects can themselves be containers. For example a table contains columns (or fields) while forms and reports contain controls that display data.

While the data source for a form can be bound to a table, the controls on the form can be set to reference the columns in that table.

A form can then be set to show either one record of a table or a list of records from that table.

As you application progresses you will find it best to restrict user's access to the tables directly and ensure that they use the interfaces (forms) that you provide.

This will ensure that you can control the data that is entered or deleted. Forms allow you to apply validation to data that is entered to make sure it is, well, valid.