What is LessonUp
Search
Channels
Log in
Register
‹
Return to search
Task 18a, Activity 18a, Task 18b
Objectives:
Practising how to create a flat- file database from an existing file
Knowing how to enter data using a data table.
Independently create a flat-file database on Activity 18a
1 / 17
next
Slide 1:
Slide
ICT
Secondary Education
This lesson contains
17 slides
, with
text slides
and
3 videos
.
Start lesson
Save
Share
Print lesson
Items in this lesson
Objectives:
Practising how to create a flat- file database from an existing file
Knowing how to enter data using a data table.
Independently create a flat-file database on Activity 18a
Slide 1 - Slide
Task 18a
Create a flat-file database from an existing file
Slide 2 - Slide
Slide 3 - Slide
How can we change these to database appropriate field names?
Slide 4 - Slide
bit.ly
Slide 5 - Link
Click Download
Slide 6 - Slide
0
Slide 7 - Video
The steps involved:
Open cars.csv in Excel
Change appropriate field names
Save file as cars1.csv
Slide 8 - Slide
0
Slide 9 - Video
Creating a flat-file database:
Import cars1.csv into Access using Text File under External Data tab.
Select the first row as heading in the import menu.
Change the appropriate data type through the Advanced Settings
Change to design view and set the decimal settings to 2.
Slide 10 - Slide
Enter Data Using a data table
Slide 11 - Slide
Slide 12 - Slide
Slide 13 - Video
Steps involved:
Input a new record below the table.
Input the data required by task 18b.
Slide 14 - Slide
Complete Activity 18a
bit.ly/activity18a (Task File)
bit.ly/activity18a-video (Video Tutorial)
Slide 15 - Slide
bit.ly
Slide 16 - Link
Slide 17 - Slide
More lessons like this
Unit 2 - Paper 1 Activity 1
April 2023
- Lesson with
29 slides
Computing ICT
Further Education (Key Stage 5)
Creating PowerShell Scripts for Importing AD Users from a CSV File
May 2023
- Lesson with
17 slides
Chapter 18.1 Field, Record, File, Flat-File and Relational Database
January 2020
- Lesson with
16 slides
ICT
Secondary Education
Databases - Exchanging Data
May 2023
- Lesson with
46 slides
Computing
Further Education (Key Stage 5)
Unit 2 - Paper 1 Activity 1
April 2023
- Lesson with
25 slides
Ilearningdeal@gmail.com
Primary Education
Mastering Queries: A Guide to Searching in Microsoft Database Access 2007
June 2023
- Lesson with
36 slides
Databases 1 van 5
October 2022
- Lesson with
30 slides
ICT
database
+3
MBO
Studiejaar 1
Data Types: Building Blocks of Database Development
August 2023
- Lesson with
18 slides