I'm new to Microsoft Access and have enrolled in Richard's courses. While they've been great, I need to set up a database asap. I'm looking for someone who can help create this database for me, and <B>I'm prepared to pay</B>.
If you're interested and capable of assisting, please let me know.
Here's what I'm aiming for:
'I need a database to manage my inventory, which will also serve as a point of sale (strictly cash-based).
'I'd like to incorporate a table that tracks the various locations where I make sales, especially since I participate in multiple trade shows. Ideally, I'd like a report that details what was sold at each location, helping me with reorders.
On the "sales" tab, once I've set the location and date (which would change daily), I'd like the capability to input 10-15 line items per transaction. For each transaction, I'd input:
'Quantity
'Customer Name
'Phone
'Email
'Stock#
From these entries, I'd expect the system to populate the Description and Price (from the product table), as well as generate a date and time stamp for the transaction. Furthermore, I'd like it to calculate the total transaction amount, inclusive of tax. Once I input the cash amount received, I'd need the system to calculate the change due before I proceed to the next sale.
Additionally, I'd appreciate it if:
'A receipt could be emailed to me.
'A receipt could be texted to the customer, if feasible.
For reference, here are the details of the tables I envision:
Customer Table:
'First Name
'Last Name
'Email
'Phone
'Address
'City, State, Zip
'Active Status
'Notes
Product Table:
'I already have this set up and populated with my inventory. I can share it if needed.
CraftFair Table:
'Fair Name
'Contact First Name
'Contact Last Name
'Phone
'Address
'City, State, Zip
'Notes
Supplier Table:
'Supplier Name
'Contact First Name
'Contact Last Name
'Phone
'Address
'City, State, Zip
'Notes

My email is [email protected] please reach out if interested.