Scribd
Upload
5 views1 page

Creating a Flat File Database in Excel

The document outlines a task to create a flat file database using Excel spreadsheets for class members. It requires inserting names and creating specific columns for personal information such as age, favorite movie, song, hobby, food, drink, aspiration, employment goal, and expected earnings. Participants must survey at least 10 people to gather the necessary data for the database.

Uploaded by

gruffy.wright
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views1 page

Creating a Flat File Database in Excel

The document outlines a task to create a flat file database using Excel spreadsheets for class members. It requires inserting names and creating specific columns for personal information such as age, favorite movie, song, hobby, food, drink, aspiration, employment goal, and expected earnings. Participants must survey at least 10 people to gather the necessary data for the database.

Uploaded by

gruffy.wright
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

INTRODUCTION TO USING FLAT FILE DATABASES – EXCEL SPREADSHEETS

Your task today is to introduce yourselves to EXCEL spreadsheets by creating a FLAT FILE DATABASE.

THE FLAT FILE DATABASE WILL BE FOR THE MEMBERS IN THE CLASS, SO YOU NEED TO INSERT
EVERYONES NAME INTO THE SPREADSHEET

YOU MUST THEN CREATE COLUMNS FOR [AGE] [FAVOURITE MOVIE] [FAVOURITE SONG]
[FAVOURITE HOBBY] [FAVOURITE FOOD] [FAVOURITE DRINK] [ASPIRATION] [ONE FUTURE
EMPLOYMENT GOAL] [EXPECTED EARNINGS GOAL]

You must then survey the room and retrieve that information for at least 10 people to populate your
flat file database.

AGE MOVIE SONG HOBBY FOOD DRINK ASPIRATION EMPLOYMENT EARNINGS

You might also like