Inventory Solutions

My job is selling vehicles to companies. However, we may not always have what they are looking for at moment’s notice. My solution:

Create an ongoing access database that hold’s the customers specifications and is linked to their contact information.

Upload the excel file with our current inventory so if something matches all the specs requested, it pulls a unit(s).

New to access, but I’m looking to document my process in solving this.

Any tips are greatly appreciated! 7/10 is day one.

submitted by /u/Merxari
[link] [comments]