This discussion is closed.
two_headed_monk
Badges: 1
Rep:
?
#1
Report Thread starter 16 years ago
#1
im an ideot, and i need someone to help my feeble brain! pls give some sort of idea ona database coursework using excel-- anything!!!!!!
0
SaeedRehman
Badges: 0
#2
Report 16 years ago
#2
(Original post by 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
0
two_headed_monk
Badges: 1
Rep:
?
#3
Report Thread starter 16 years ago
#3
i cant do it on access, i have to use excel, but i just need an idea, i can do the rest easy!
0
SaeedRehman
Badges: 0
#4
Report 16 years ago
#4
(Original post by 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
0
nikk
Badges: 15
Rep:
?
#5
Report 16 years ago
#5
(Original post by 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.
0
PQ
Badges: 21
Rep:
?
#6
Report 16 years ago
#6
(Original post by 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.
0
nikk
Badges: 15
Rep:
?
#7
Report 16 years ago
#7
(Original post by 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
0
jstringer
Badges: 0
#8
Report 16 years ago
#8
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.
0
two_headed_monk
Badges: 1
Rep:
?
#9
Report Thread starter 16 years ago
#9
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...
0
PQ
Badges: 21
Rep:
?
#10
Report 16 years ago
#10
(Original post by 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.
0
nikk
Badges: 15
Rep:
?
#11
Report 16 years ago
#11
(Original post by 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.
0
Romeo
Badges: 0
#12
Report 16 years ago
#12
(Original post by 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.
0
emom100
Badges: 1
Rep:
?
#13
Report 16 years ago
#13
ok this will sound really thick but whats the difference between a database and a spreadsheet
0
PQ
Badges: 21
Rep:
?
#14
Report 16 years ago
#14
(Original post by 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.
0
Joey_Johns
Badges: 10
Rep:
?
#15
Report 16 years ago
#15
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.
0
jazford99
Badges: 0
#16
Report 16 years ago
#16
i really need help on my A2 database ICT coursework

can anyone send me an example of what they have dun to help me
0
Midge19852004
Badges: 2
Rep:
?
#17
Report 16 years ago
#17
(Original post by jazford99)
i really need help on my A2 database ICT coursework

can anyone send me an example of what they have dun to help me
If you get an example of a database made in access A2 ICT coursework would u please fwd it on to me at [email protected] - subject: ICT coursework!!
Much love and good luck
nickala xxx
0
X
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

If you do not get the A-level grades you want this summer, what is your likely next step?

Take autumn exams (103)
48.58%
Take exams next summer (31)
14.62%
Change uni choice through clearing (52)
24.53%
Apply to uni next year instead (20)
9.43%
I'm not applying to university (6)
2.83%

Watched Threads

View All