Rentals - Dev 23 Access Developer 23

Start of POS system - Dev 14 {1316}

1316 is Access Developer 14 until Alex comes back to edit that ;)

I am following the Access Developer 14 course but I have to consider thousands of books that will be sold to thousands of customers. We offer Trade Credit, teacher discounts, frequent buyer benefits, gift certificates and we pay cash to walk-in customers that want cash for their books. All of our stock is entered into a database and I perform queries that help me identify old stock. Yes, we have a program already but it was developed in Access 2003 and needs an overhaul. I'm trying to take on the challenge. Our developer is in England and although he was great at building the program when he worked in our store...he is not as accessible since he left the country. I'm in Canada.

Sounds like you just need a product that you can manually enter a price for. That will cover your negative sales (trade credit/gift certificates/cash payments). Frequent buyer you'll have to track somehow, either using a table or setting up code on the on-current event to apply a percentage deduction if they have a certain amount of orders, however you want to do it. Teacher discounts could be done in a manual field or with a checkbox in the customer information that they're a teacher, then use if/then to apply it to orders they make.

I've never worked in a used bookstore, but I understand most of the concepts. If there's something that you need to know that I haven't already covered in one of my other lessons, post it and I'll do my best to make a video on it.

Adam, all of our books are labeled with a sticker that indicates Category, Sub-Category, Author, Title, ISBN & Price. Hardcovers, Trades, and paperbacks all have different prices. By entering all this information into a database we can track how many we have (We have a warehouse store as well) and it allows us to know if the book is stale stock among many other things. The POS/Database that we currently have is like nothing else in this world that we know of. My original POS was built on Lotus123 and was the germ of the idea for the POS that we have now. HTTP://www.fairsfair.com or look us up on Google. Our main store is 9000+ square feet and our warehouse is close to the same.

Richard, I know your expertise would be invaluable. Thank you for being out there.

Sounds like your database is going to be very search intensive. Learn some SQL and you may want to look into my Search Seminar as well.

Hey tami, you say main location. Is this a SQL server setup or do other locations not use the db? Or what online option are you using now?

Ill second the search seminar you'll get a lot of use out of that.

9:51 PM 2021-08-21
Adam, we have a server. The two stores run independently of each other but enter books into the Main database. We can see what the other store has in stock. When our main store sells a book, our warehouse prints a Dup List of books that they pull and send back to us. On the hardware side, I leave that to our "Tech Geek" (term of endearment), Nan. I try to understand but I'm better at puzzles.  I will pull up the Search seminar, thank you. I followed along with the Invoice seminar today and it also taught me some new things :)

Sounds like a VPN solution, which will work OK for 2 maybe 3 locations with good Internet connections. I don't recommend them for databases that have a lot of activity though.