I am currently working on a order system for a local takeaway. The main tasks i need it to do are store customers' details, allow the user to enter and save new customers' details, allow the user to select what food the customer wants and also calculate the total price of the order, and allow the user to print off an invoice.
So far i have the following tables with the following field names:
tbCustomer - CustomerID, title, first name, surname, address, town, postcode, telnumber
tbMenu - MenuID, food, price
tbOrder - OrderID, CustomerID, date, time
tbItem - ItemID, menuID, orderID, quantity
I have created a customer data entry form, a telephone number search form so that the user can enter the customers number and check whether they're already on the database, and a customer form which shows a list of existing customers. I have also created an order form which shows the customers details (those saved on the database) and what they've ordered.
When it comes to using Access, i'm no expert. I would appreciate it if someone would help me on where to go next. Am i going along the right lines?