Lesson 1: Used cars

In this lesson, you will learn about some of the fundamentals of databases and data types by investigating and adding to a simple database.

Learning objectives

  • Know what a database is
  • Know what the main data types are
  • Be able to label a database table
  • Be able to add records to a table

Components of a table

Click on the hotspots on the image below for descriptions of the parts of a table.

Data types

In an Access database, there are several different data types that can be used. Here are the ones you will encounter first.

Data typeDescriptionExample
AlphanumericA data type that can consist of letters or numbers or both. Any text-based data can be put in an alphanumeric field, but you can’t do very much analysis of data in these fields.4 Willow Drive
NumericNumeric data stored as an integer or decimal which calculations can be performed on. Note that currencies and dates are also numeric data, with formatting applied to make them easier to understand.200, 49.53
CurrencyA numeric data type where numbers are formatted as money, usually with a currency symbol and two decimal places.$499.99, €10.00, ¥250.00
Date/timeA numeric data type used for storing dates. We always use British formatting: DD/MM/YY.01/01/2000, 31/12/2050
BooleanA data type that can only have two possible values.on/off, true/false, yes/no

Identifying numeric fields

Identify the five numeric fields in the table below by clicking on them.

Task: Used Cars

Download the lesson files below:

Instructions: open the Cars.accdb Access database and adding the five records from Used cars.pdf to the tbl_Cars table.

Find out how

Extension

Find at least three more cars to add to your table from ABC Car.

  • Convert the price into USD. 50 萬/wan = 500,000 NTD.
  • Make up a registration number using the following format: A00 AAA, e.g. B92 CLA.

Practice & consolidation

In preparation for next week’s lesson, make sure you have met the learning objectives by practising with the resources below.

Flashcards

Practice quiz