Turn on thread page Beta
    • Thread Starter
    Offline

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

    0
    ReputationRep:
    (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
    • Thread Starter
    Offline

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

    0
    ReputationRep:
    (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
    Offline

    2
    ReputationRep:
    (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.
    • Very Important Poster
    • PS Reviewer
    Offline

    21
    ReputationRep:
    Very Important Poster
    PS Reviewer
    (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.
    Offline

    2
    ReputationRep:
    (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
    Offline

    0
    ReputationRep:
    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.
    • Thread Starter
    Offline

    1
    ReputationRep:
    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...
    • Very Important Poster
    • PS Reviewer
    Offline

    21
    ReputationRep:
    Very Important Poster
    PS Reviewer
    (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.
    Offline

    2
    ReputationRep:
    (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.
    Offline

    0
    ReputationRep:
    (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.
    Offline

    1
    ReputationRep:
    ok this will sound really thick but whats the difference between a database and a spreadsheet
    • Very Important Poster
    • PS Reviewer
    Offline

    21
    ReputationRep:
    Very Important Poster
    PS Reviewer
    (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.
    Offline

    10
    ReputationRep:
    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.
    Offline

    0
    ReputationRep:
    i really need help on my A2 database ICT coursework

    can anyone send me an example of what they have dun to help me
    Offline

    2
    ReputationRep:
    (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
 
 
 
Poll
Who is most responsible for your success at university
Useful resources

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.