Inventory Tracker for Access Database Templates Tutorial



Small Business Inventory Tracker for Access Database Templates

Small Business Inventory Tracker for Access Database Templates - This is inventory database or inventory tracker for access database templates. Aside for keeping track of inventory, it can be used for invoice or recording transactions. Northwind inventory tracker is perfect for small business or retails. When you open the template, it will prompt to save new file location because it is split database. Save and rename the file. Open the new saved database (front-end). There will be pop-up window like this. You can check the inventory tracker with sample data provided in this template, or using right away with your own data.

 

Access Templates Inventory Tracker for Small Business

 



The inventory tracker menus are:

TEMPLATES DASHBOARD
Menu to preview the active orders and inventory for inventory tracker and quick edit.

GETTING STARTED
Menu for guiding and give information about how to use the template or tips and links for ways to track inventory. The only tabs to be filled is COMPANY INFO tab, which data used in invoice or reports.

 

Access Templates Inventory Tracker for Small Business (2)

 



ADVANCE
Menu for recording the databases that supports other menus.

CATEGORIES
Menu for recording categories for Products menu.

EMPLOYEES
Menu for recording employee login. You can set up password with this Login Report.

 

Access Templates Inventory Tracker for Small Business (3)

 



CUSTOMERS, SUPPLIERS, SHIPPERS
Menu to record the contact details that can be used in transaction menus or reports. The fields are same in all menus:

Fields

Data Type

ID

Autogenerated, numeric

First & Last Name

Strings

Company

Email

Job Title

Phone fields

Addresses fields

Notes

Web Pages

Hyperlink

Attachment

Attachment



INVENTORY PRODUCTS
Menu to record and display the Products in table list for quick add or editing.

 

Access Templates Inventory Tracker for Small Business (4)

 

If you double click or click New Product button, PRODUCT DETAILS dialog box will appear.

Fields

Data Type

Product Name

String

Product Code

String, primary key

Category

Lookup value

Supplier

(Purchase) Cost

Currency

(Sell) Price

Qty per unit

String

Discontinued

Checkbox, ticked products will not available for transactions

Description

String

Attachment

Attachment

 

Access Templates Inventory Tracker for Small Business (5)

 



ORDER and PURCHASE HISTORY
This menu display the transaction records regarding the products. INVENTORY tab provides the setting for inventory level amount in numeric. There is subform to input inventory shrinkage.

 

Access Templates Inventory Tracker for Small Business (6)

 


INVENTORY LEVELS
Submenu to display the inventory amount levels in table, which is the best way to track inventory. It can be used for quick edit.

 

Access Templates Inventory Tracker for Small Business (7)

 


NEEDS INVENTORY RESTOCKING
Submenu to display the inventory which amount in hand below the Target Level.

DISCONTINUED PRODUCTS
Submenu to display the products which discontinue checkbox ticked.

ORDERS
Menu to records sales order from customer.

 

Access Templates Inventory Tracker for Small Business (8)

 


If you double click the records or click New Order button, Order Form will appear. On the header, there are buttons for order status:
- Invoice Order: the order is fixed and confirmed. The invoice will be generated and can be printed and sent. Once clicked, you cannot change records in Order Details tab anymore. The order cannot be canceled too.
- Ship Order: marked that the order is shipped. Once clicked, you cannot change records in Shipping Information tab anymore.
- Complete: marked that the transaction is over.
There are tabs for:
- Order Details: records the transactions.
- Shipping Information: records the shipping company, date, and address.
- Payment: records payment status and information.

 

Access Templates Inventory Tracker for Small Business (9)

 


On the footer, you can click Update to display the totals if there is any changes.

PURCHASE
Menu to records purchase order made to supplier. Double click or click add new records to open the Details dialog box.

 

Access Templates Inventory Tracker for Small Business (10)

 


On the header, there are buttons for order status:
- Submit Order: the order is fixed, confirmed, and sent. Once clicked, you cannot change records in Purchase Details tab anymore.
- Complete: marked that the transaction is over. Once Clicked, all data cannot be changed.
There are tabs for:
- Purchase Details: records the transactions.
- Inventory Receiving: tab for confirm the received status
- Payment: records payment status and information.

REPORT CENTER
Menu to display and generate the summarized records into printable reports. The reports can be analyzed for sales or inventory tracker. There are 6 types of reports:
- Customer List
- Active Orders: Sales Order that has been in complete status
- Supplier List
- Yearly Sales
- Quarterly Sales
- Monthly Sales

The free inventory tracker is open source and can be modified. The inventory tracker can be downloaded at access-templates.com along with other useful microsoft access templates.


Frequently Asked Questions

Which Microsoft Access software version work with this database?

This database template will work optimally on MS access software version 2016 and the latest 2019 version. You can use the older version but it may caused bug or error.

How to Download This Access Database Template?

Simply go to our homepage and browse the template you want to use, you can also use search form function to get templates in specific keyword. You can Register Here and become our paid member if you want to get all templates without download limitation in unlocked version.

Is It Safe To Download This Database from This Website?

We've been serving our users since 2011, you can verify here. We are always committed to build a secure and user-friendly database for our users, and thats why we still exist in this business until today. You can also verify our website security using McAfee, and you can directly scan the downloaded database using VirusTotal or any other Antivirus software you have in your computer. All access databases and templates on this website are 100% free from virus, malmware or any other harmful objects.

Can I Modify The Database Template?

Yes, you can modify all of our templates to fit your needs as long its for personal, education or non-profit use only. If you want to modify and use it for commercial or business purposes, you have to buy extended licence separately. Read more: Terms of Use.

How to Download Microsoft Access 2016 or 2019 Software?

You can purchase Microsoft Office Access here:

Can I Request for Access Database Modification Service to Fit My Needs?

Yes, we are open for any kind of modification service on microsoft access templates and databases. You can send your access modification request here.

How Can I Contact Microsoft Access Programmer?

You can contact our programmer using the contact page on this website, or if you need faster response you can send us WhatsApp Message to +1-(786)-886-3099 (working hours only) and Priority support only available for paid members. If you don't get answer by phone due to heavy work-load on all of our staffs, we suggest you to send a whatsapp message or email admin@access-templates.com