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.
- 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.
In an Access database, there are several different data types that can be used. Here are the ones you will encounter first.
|Alphanumeric||A 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|
|Numeric||Numeric 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|
|Currency||A 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/time||A numeric data type used for storing dates. We always use British formatting: DD/MM/YY.||01/01/2000, 31/12/2050|
|Boolean||A 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.
Find out how
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.