Want to Make a Pizzeria DataBase Please Help any comments are appreciated

[helpmeT_T]

I am trying to make a pizzeria database. I am fairly new to access and I wanted to know how i could make an Orders table to record the customers purchases. The thing is I don't know how to make it so i can get 1. quantity of pizzas 2. type of pizza 3. size of pizza 4. cost of pizza. On top of that there are also drinks and sides the customer can purchase, I don't know how to approach this and i have been trying to come up with a solution for over 7 hours now. Any help is much appreciated.

 

[John Big Booty]

You may get some inspiration from one of the data models available here, check section 8. Restaurants.

 

[helpmeT_T]

thank you very much this helps a lot