I.T Database H/W (GCSE)[+REP]

[Fifteen]

Annoying thing is.. If I was on a computer with MS access I could probably do it.

Just it's confusing having to write it down
+ Im basically like :S on how to link up to say they like horror - Show them all horror movies

I think it will be easier if I draw the realtionships first..
so I think it will looksomething like this:


Probably wrong titles Já + obviously have more titles etc. But I think that's right "/

you could have a genre field then do a query looking up all horror movies?

[Abbie.]

I HATE ACCESS LOL.


the relationships is the easy part
im going forms atm

its easy, but y cant it just not be in a spreadsheet LOL.

[Con]

I HATE ACCESS LOL.


the relationships is the easy part
im going forms atm

its easy, but y cant it just not be in a spreadsheet LOL.

ino but im like..
At school - Able to work
At home - unable to work

[Abbie.]

yeaa i know what you mean

i ask my teacher for help every 2 mins, no joke lmao.

[Con]

Oo I think it's coming back to me :S

I have wrote:

Tbl_customers
Customer ID - Autonumber
First Name - Text
Last Name - Text

Tbl_DVD
dvdID - Autonumber
DVD Title - Text
Genre - Text

Tbl_rental
Order number - ? Unsure whether it is autonumber or not.
Order date - Time and date
customer ID - Lookup wizard?
DVD ID - Lookup wizard?

I think that's like.. right?


Then for relationships I have to split it all up or w.e

[Fifteen]

Oo I think it's coming back to me :S

I have wrote:

Tbl_customers
Customer ID - Autonumber
First Name - Text
Last Name - Text

Tbl_DVD
dvdID - Autonumber
DVD Title - Text
Genre - Text

Tbl_rental
Order number - ? Unsure whether it is autonumber or not.
Order date - Time and date
customer ID - Lookup wizard?
DVD ID - Lookup wizard?

I think that's like.. right?


Then for relationships I have to split it all up or w.e

Tbl_customers
Customer ID - Autonumber [Primary key]
First Name - Text - Field size 4 - Validation rule: 'Mr' or 'Mrs' or 'Miss' or 'Ms' - combo box ( Mr;Mrs;Miss;Ms )
Last Name - Text - field size 30

Tbl_DVD
dvdID - Autonumber [Primary Key]
DVD Title - Text - Field size 100
Genre - Text - Field size 50

Tbl_rental
Order number - number
Order date - Time and date
customer ID - Lookup wizard
DVD ID - Lookup wizard

[Con]

Tbl_customers
Customer ID - Autonumber [Primary key]
First Name - Text - Field size 4 - Validation rule: 'Mr' or 'Mrs' or 'Miss' or 'Ms' - combo box ( Mr;Mrs;Miss;Ms )
Last Name - Text - field size 30

Tbl_DVD
dvdID - Autonumber [Primary Key]
DVD Title - Text - Field size 100
Genre - Text - Field size 50

Tbl_rental
Order number - number
Order date - Time and date
customer ID - Lookup wizard
DVD ID - Lookup wizard

okay I love you
I don't think we have done validation box's tbh, + I'm not sure if we have really doe much about field size. But I love you for helping me anyways

I can just take in what I have done and show the teacher tomorrow + see if I have done it right or not
again, THANKYOU!

[Fifteen]

okay I love you
I don't think we have done validation box's tbh, + I'm not sure if we have really doe much about field size. But I love you for helping me anyways

I can just take in what I have done and show the teacher tomorrow + see if I have done it right or not
again, THANKYOU!

ehhe bye have a good day tomorrow
xo