Task 18a, Activity 18a, Task 18b

• ICT
• Secondary Education

Objectives:

1. Practising how to create a flat- file database from an existing file
2. Knowing how to enter data using a data table.
3. Independently create a flat-file database on Activity 18a

Task 18a 

Create a flat-file database from an existing file

How can we change these to database appropriate field names? 

bit.ly

Click Download

0

The steps involved:

1. Open cars.csv in Excel
2. Change appropriate field names 
3. Save file as cars1.csv

0

Creating a flat-file database:

1. Import cars1.csv into Access using Text File under External Data tab.
2. Select the first row as heading in the import menu.
3. Change the appropriate data type through the Advanced Settings 
4. Change to design view and set the decimal settings to 2. 

Enter Data Using a data table

Steps involved:

1. Input a new record below the table. 
2. Input the data required by task 18b.

Complete Activity 18a

bit.ly/activity18a (Task File)

bit.ly/activity18a-video (Video Tutorial)

bit.ly