• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Epic Finances

Investment Blog Goal: 25% Return a Year

  • My Portfolio
  • Real Estate
  • About
  • Contact
  • Favorites

Microsoft Access Can Be Very Useful for Selling on Amazon

By Carmello on November 22, 2011

Microsoft Access Can Be Very Useful for Selling on Amazon

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:

not received

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.

Pages: Page 1 Page 2

Primary Sidebar

Archives

Article Categories

  • Amazon
  • Bonds
  • Butterfly Options
  • Cash Back
  • Ebay
  • ETF
  • Favorites
  • Gold
  • Guest Posts
  • Home Depot
  • Investing
  • Lowes
  • Options
  • Owning a Home
  • Personal Portfolio Update
  • Phone and Utilties
  • Product Reviews
  • Real Estate
  • Retirement Accounts
  • Saving Money
  • Silver
  • Stocks for the Long Run
  • Uncategorized

Copyright © 2021 · Smart Passive Income Pro on Genesis Framework · WordPress · Log in