ms access need assistance (1 Viewer)

enoilgam

Moderator
Moderator
Joined
Feb 11, 2011
Messages
11,876
Location
Mare Crisium
Gender
Undisclosed
HSC
2010
There is a really good tutorial app you can get if you have an iPhone/iPad which can help (it has videos and stuff).

What will the DB be used for? Is it like a small business type thing (with customer details, orders etc)?
 

enoilgam

Moderator
Moderator
Joined
Feb 11, 2011
Messages
11,876
Location
Mare Crisium
Gender
Undisclosed
HSC
2010
yes small video store
Well, you're going to have a table with customer information and then one with rentals. Customers should each have a unique ID number (which will be the primary key) and the rental table should have a unique rental ID number (which will be it's primary key). In the rental table, you should also have a column for customer ID. In order to link them, you would have to create a one-to-many relationship from the customer information table (one) to the rental table (to many) which links customer ID.
 

nerdasdasd

Dont.msg.me.about.english
Joined
Jul 29, 2009
Messages
5,354
Location
A, A
Gender
Male
HSC
2012
Uni Grad
2017


Now explaining this.... Customers can rent videos and will be given an invoice

...

You can extend this to include returns and fines (for late videos)

....

That is just a sample database (very simple), you can make it as complex as you think you can handle
 

watermelondayo

Active Member
Joined
Nov 15, 2014
Messages
303
Location
watermeland
Gender
Male
HSC
N/A
I literally just handed in a relational database assignment today :p
What are your requirements? Any specific number of tables/forms? queries?
 

swagmeister

Active Member
Joined
Oct 4, 2014
Messages
524
Gender
Male
HSC
2015
I have a huge access project due this Friday so I have spent heaps of time learning Access, anything you need help with if its theory such as normalisation or even just the in and outs and tedious bits of access just sent me a direct message :)
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top