Database - How To Movies
 
1. Setting up and creating tables and fields 2. Formatting Fields. 3. Creating Primary Key and Relationships 4. Searching and Creating Reports 5. Editing Reports
 
Home DatabaseUsing Information Internet NAB/Coursework Revision Legal Responsibilities

Database

For this section you are going to create your own data file.  When designing a data file the following steps must be carried out:

  1. Decide on a name for the data file
  2. Write down the field names that will be needed
  3. Decide what type of data will be entered into each field.

Field names

It is important when choosing field names that they are short and meaningful - short so that as many fields as possible will fit on reports, and meaningful so that you can quickly understand the data in the file.

Field types

Computers can store certain data using a smaller amount of memory than other types of data.  Therefore to make the most efficient use of memory, and make the file take up as little space as necessary on backing store, the type of data must be entered for each field when creating a new database.  Some common field types are explained below:

You are now going to create 2 related data files - the first will be a flight timetable for an airline company, containing information such as flight number, aircraft used, captain on the flight, departure airport & time, arrival airport & time. 

The second data file will contain more detailed information about each aircraft owned by the airline. 

You will be given the data to be included in the file, and you are required to create the file using the appropriate field names. 

Before deciding what data or format the fields will take it is best to view the data that will be input. Click here. (This will download to your desktop.)

Click here to complete the exercise to choose the correct field names for the Flight Timetable.

View the movie - Setting up the database and creating and naming tables, creating fields and field types.

Click here to complete the exercise to choose the correct field names for the Aircraft Table.

Now create the fields and field types for the Aircraft Table.

Formatting the Fields

Once you have an idea of the type of formatting that may be required view the movie then format the fields in your database in the same manner. The movie will only show you how to format fields for the flight timetable, you then have to consider which fields in the Aircraft table that you wish to format.

Format the fields for both tables before inputing the data. In the Aircraft table the only field that would be suitable for formatting would be the Type field. This would be a Restricted Choice with the following data:

Enter the data into both tables.

Create the Primary Key for both tables and form the Relationship between tables. View movie.

Carry out the following manipulations on the data

Querying the files

For each of the following queries create a new report for the records found, with a suitable title eg for the first query the title may be ‘Aircraft with more than 30 Business Class Seats’.  Add your name as a footer.

Click on the link to completed the Query sentences - when you have them all correct, print out or save so you can use them in the next exercises. Click here.

View the movie - creating a search and report from search results. Remember the heading! View movie.

Now create all your seaches and reports from your queries.

Practice

Download the 2 practice exercises - complete them in order.

  1. Driving School
  2. Motor Racing


 

 



 

Intermediate II Home
Database | Using Information | Internet | NAB/Coursework| Revision
Log into Glow | School Website | Contact Us