Microsoft Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. Access is much more involved and is a more genuine database application than other programs such as Microsoft Works.

First of all you need to understand how Microsoft Access breaks down a database. Some keywords involved in this process are: Database File, Table, Record, Field, Data-type.

Database File:
This is your main file that encompasses the entire database and that is saved to your hard-drive or floppy disk.
Example) StudentDatabase.mdb

Table:
A table is a collection of data about a specific topic. There can be multiple tables in a database.
Example #1) Students
Example #2) Teachers

Field:
Fields are the different categories within a Table. Tables usually contain multiple fields.
Example #1) Student LastName
Example #2) Student FirstName

Datatypes:
Datatypes are the properties of each field. A field only has 1 datatype.
FieldName) Student LastName
Datatype) Text

Query Form

Name :		Website :
Organisation :		Services Required :
Phone No. :		E-mail ID :
Query / Suggestions