
Queries are amazing. They can be anything you want them to be. I personally have several, but one in particular I use a ton. A query named “Not Received Yet”, for inbound packages from eBay that will be my inventory later. Basically I asked the database to show me when the “Date Received” is blank. It then reports this:
So when I have a 4th generation silver iPod sitting on my desk to be listed, I can record the item as being received.
You might also noticed I record the last 4 of the serial number – this is to prevent “yankee swapping”. People commonly break their personal property – then find sellers online that have the same fungible (similar / can’t tell the difference) item online and order it. When it arrives they tell the seller it arrived broken, but in reality the sellers item arrived unharmed. They then send back their personal broken item and keep the functional item. It’s very common sadly.
Back to Access. Access can be an amazing tool – sadly I’m not going to go through even a fraction of its capabilities (reports, P&L, and basically everything else you can think of when it comes to accounting), but if you are in the business – it’s worth checking out.