This discussion is now closed.

Check out other Related discussions

A-level ict coursework

im an ideot, and i need someone to help my feeble brain! pls give some sort of idea ona database coursework using excel-- anything!!!!!!

Reply 1

SaeedRehman

two_headed_monk

im an ideot, and i need someone to help my feeble brain! pls give some sort of idea ona database coursework using excel-- anything!!!!!!

u definately need some help

try using microsoft access

and make video rentals
audio rentals
library

check previous posts do a search

Reply 2

two_headed_monk

OP

1

i cant do it on access, i have to use excel, but i just need an idea, i can do the rest easy!

Reply 3

SaeedRehman

two_headed_monk

i cant do it on access, i have to use excel, but i just need an idea, i can do the rest easy!

video database? whats wrong with that

Reply 4

nikk

15

SaeedRehman

video database? whats wrong with that

So let me get this straight....your course is to produce some form of a database and so you opt to use excel which is a spreadsheet application not a database application.....ok.....good luck you will most definately need it.

two_headed_monk

i cant do it on access, i have to use excel, but i just need an idea, i can do the rest easy!

Excel isn't ideal for making a database...but with a pivot table or 2 and some nice formatting it's do-able (although I've no idea why any exam board would require you to bodge a database project thrugh using a spreadsheet instead of db software :shrug: )

You could create a database of anything - students in your school (complete with emergency contacts, subjects and exam results), staff in an imaginary company, stock control for an imaginary company etc etc.

Reply 6

nikk

15

NikNak

So let me get this straight....your course is to produce some form of a database and so you opt to use excel which is a spreadsheet application not a database application.....ok.....good luck you will most definately need it.

It's like if your teacher asked for an essay and you drew a picture because you couldn't write the essay!! lol

Reply 7

jstringer

if u have to do it on excel then its not a database its a spreadsheet

the posibilities of what you do are endless but for inspiration I sujest that you look at what other people in your class are doing and maybe you can do a similar one to them.

Reply 8

two_headed_monk

OP

1

no-one in my class has a clue.... i think some of them dont even speak english.... theyre still learning that vlookup crap.... i finished that early so now all i can do is sit around and try not to look at porn...

jstringer

if u have to do it on excel then its not a database its a spreadsheet

the posibilities of what you do are endless but for inspiration I sujest that you look at what other people in your class are doing and maybe you can do a similar one to them.

No you can produce a database using spreadsheet software - you can even produce a relational database of a sort using vlookups (sorry excel geek) and query the data using pivot tables (and if you use named pivot tables you can reference the query data to produce half decent reports). It's not ideal (mainly because there is no way of holding historic data without creating a dated duplicate and changing data on the copy) and it's slow to retrieve data compared to access but it's in theory possible.

Reply 10

nikk

15

two_headed_monk

no-one in my class has a clue.... i think some of them dont even speak english.... theyre still learning that vlookup crap.... i finished that early so now all i can do is sit around and try not to look at porn...

Have a go at access it is actually incrediably easy - espcially if you dont go including forms and reports. Do a search on google for access tutorials.

Reply 11

Romeo

two_headed_monk

im an ideot, and i need someone to help my feeble brain! pls give some sort of idea ona database coursework using excel-- anything!!!!!!

Ithink that you should not use a video rental one as this has been done so many times, as well as the liabrary.
A good idea is to design a database for your local shop, not something like Tesco as they already have there own perfect database.
A car hire area is also good, anything as long as its not a big company.

Reply 12

emom100

8

ok this will sound really thick but whats the difference between a database and a spreadsheet

emom100

ok this will sound really thick but whats the difference between a database and a spreadsheet

A relational database (like access) contains the equivalent of lots of spreadsheet like tables linked together...makes it possible to link (for example) multiple customers to one sales person without either having lots of different rows with the same saleperson or having customer 1 customer 2 customer 3 etc etc for each salesperson which is the way you would have to structure the same information on a spreadsheet.

Plus you can get more data in a database than you can in one excel worksheet.

Reply 14

Joey_Johns

10

Why do you have to do it on Excel?

I did A level computing. Your allowed to implement the project in any way you see fit. Id est you can do it on Access, Word, Excel or even programme it fully if you are capable. You are not restricted to Excel.