cross

Task 18a, Activity 18a, Task 18b

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
1 / 17
volgende
Slide 1: Tekstslide
ICTSecondary Education

In deze les zitten 17 slides, met tekstslides en 3 videos.

Onderdelen in deze les

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

Slide 1 - Tekstslide

Task 18a 
Create a flat-file database from an existing file

Slide 2 - Tekstslide

Slide 3 - Tekstslide

How can we change these to database appropriate field names? 

Slide 4 - Tekstslide

Slide 5 - Link

Click Download

Slide 6 - Tekstslide

0

Slide 7 - Video

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

Slide 8 - Tekstslide

0

Slide 9 - Video

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. 

Slide 10 - Tekstslide

Enter Data Using a data table

Slide 11 - Tekstslide

Slide 12 - Tekstslide

Slide 13 - Video

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

Slide 14 - Tekstslide

Complete Activity 18a
bit.ly/activity18a (Task File)
bit.ly/activity18a-video (Video Tutorial)

Slide 15 - Tekstslide

Slide 16 - Link

Slide 17 - Tekstslide