How can I make a restaurant database using microsoft access?
Ok I have little experience with Microsoft Access and I need it as a school homework.
Please I don’t want it complicated and without queries cause I don’t even know what queries mean.
and if there is a kind of a guide on how to do it or even a picture on how it should look like.
You should decide on how it should look, not anyone else.
Write down what you think you need.
Do you need Customers for the restaurant? If so, make a table for customers. You will also need to work out what type of attributes (fields) the customers should have. Like name.
If you have customers, do they make bookings? If so, make a bookings table. This should include the promary key from customers so a customer can make a booking.
Do you want the customers to be able to make a booking for a table and/or a certain time. If so, you would have that information as well in the bookings table.
You may also need a tables table so you can say how many tables are available, and how many can sit at a table.
It could go on and on. You need to decide what to put in there. You can either make it large, or just small. It is totally up to you.
Without seeing what you are supposed to do for the homework, if it is clearly documented, then it is hard to say. If it is just to make a resraurant database, perhaps you could go to a local restaurant and explain what you are doing and ask what type of information they get.
Then with that type of information, you should be able to work out what tables and attributes (fields) you need or want.
As for a guide on how to build a database, access comes with help, so it should give you the information that you need. They are also wizards that allow you to make a database easier (or so it seems).
Good luck.
February 25th, 2010 at 12:37 pm
To create a restaurant database you will need to create multiple tables and the relationships between them.
For example in a animals table you may have 500 owners who own 3 pets on average giving you 1500 animals in the animals table. Each animal makes 3 visits to the vet giving you 1500 visits records. It goes on you need a vets database and a treatments table. The same idea applies with your idea.
It’s a big project read the quick key card below for Access and the down-loadablele manual on Access
References :
http://www.mousetraining.co.uk/ms-office-training-manuals.html
February 25th, 2010 at 1:04 pm
You should decide on how it should look, not anyone else.
Write down what you think you need.
Do you need Customers for the restaurant? If so, make a table for customers. You will also need to work out what type of attributes (fields) the customers should have. Like name.
If you have customers, do they make bookings? If so, make a bookings table. This should include the promary key from customers so a customer can make a booking.
Do you want the customers to be able to make a booking for a table and/or a certain time. If so, you would have that information as well in the bookings table.
You may also need a tables table so you can say how many tables are available, and how many can sit at a table.
It could go on and on. You need to decide what to put in there. You can either make it large, or just small. It is totally up to you.
Without seeing what you are supposed to do for the homework, if it is clearly documented, then it is hard to say. If it is just to make a resraurant database, perhaps you could go to a local restaurant and explain what you are doing and ask what type of information they get.
Then with that type of information, you should be able to work out what tables and attributes (fields) you need or want.
As for a guide on how to build a database, access comes with help, so it should give you the information that you need. They are also wizards that allow you to make a database easier (or so it seems).
Good luck.
References :