Working On A Database.

After analysing the Microsoft office tutorials and its explanation of how to create and maintain databases using Microsoft office access, an explanation of each tutorial is needed.
The tutorials include:

• Table that Data
• Tables, the building blocks of databases.
• Fields of Data
• Each record is unique
• It's all relative
• Practice
• Test Yourself
• Analyzing, viewing, and reporting data.
• Queries
• Forms
• Printed Reports
• Practice
• Test Yourself

Table that Data introduces how to create databases using tables and with which types of software, in this case Microsoft Office Access as well as gives us an insight of the different parts of the program which assists us, in creating a database.


Tables, the building blocks of databases explores the location of information situated in the table, for example records and fields as well as a reasonable definition of databases and once again records and fields. Tables store data, so they're essential building blocks of any database. The definitions given by this website are the following;
RECORD - a collection of facts about a particular person, event, CD or other item of interest.
FIELD - is a single kind of fact that may apply to each person, event or other record.


Fields of data explains how the information of databases can be changed, by manipulating the settings as well as the properties. This tutorial also assists us in understanding how to use the properties to manage the database with no difficulties or complex issues. This tutorial also gives an insight of an important settings in the case of fields which is the data type. The definition given from the website for this term is as follows;
DATA TYPE - limits and describes the kind of information in the field. The data type also determines the actions you can perform on a field and how much memory the data uses.

Each record is unique analyses the different fields and what information belongs in it. They introduce a field called the primary key field. This is an identifier such as a part of a number or employee ID, which is unique to each record.


It's all relative goes into more detail of the keys used in Microsoft office access such as primary key and a foreign key. Primary key allows you to enter into the power of a relational database, instead of working with a heavy amount of repetitive lists that are difficult to consist of and cannot cooperate.


Practice gives a link in which you can practice how to use Microsoft Office Access. Using the information, given by the website, I have attempted to create a database. Snapshots are featured below;