• Home
• Microsoft Access Tutorial
• Microsoft Access Templates Tank Farm Management System Database

If you run a small business in tank farm, you should check this tank farm management database for microsoft access templates. This access template is for managing the sales and purchases records of your business. It is meant as small farm management access template, which will be suited for small tank farm company. This access template is more recommended for small tank farm business in managing the business. There are 3 main features and report feature. To getting started, it will be good to check the Products menu first because it is the master menu. After you input your products, you can run the Shipper (or supplier) menu and Customer menu. The result will be summarized in Reports menu. You can download this farm management access template in access-templates.com

SHIPPERS
The first menu from this best farm management access template. Shippers or more familiarly as supplier is the menu where you input the purchased product items. In the header is the detail of your shipper: name, email address and phone number.

 

 

In the lower form is the detail of your purchase transactions for your tank farm management system. You can select the product, which is taken from Products menu. If you want to purchase a new type of product, you have to visit the Product menu first. In this farm management access template, we simply think that the oil will be stored in tank. Every tanks have their own code. You can select the tank from drop down list. To add new one, you have to added it via Products menu. The next field is the quantity of oil purchased in Kbls. The farm management report form is simple and not much changed from the menu fields.

PRODUCTS

 

 

Next of the good menu for farm tank management, Products menu. This is the master form where you input the products for sale or purchase. First, input your product name and the price for each barrel. Next, put the code at the tank where the oil stored. Back to Shippers menu, it is possible to put the product into another tank if you're not careful. So, it is recommended to put the name of tank more specific, like Kerosene 1, or such. In this farm management access template report, it will automatically calculate the oil stock. The End Inventory is the summary from the oil that you have from the start, minus the sold oil, and added with purchased oil.

CUSTOMERS
Like the previous Shipper menu in this tank farm management access template, the header is about customer contacts and identity. In the lower form is the sales detail. You have to fill the date, the barrel quantity sold, and which tank it is. For your tank farm management, the report automatically calculated the total of sales. The sales total come from the multiplication of the sale quantity with the price from Products menu.

 

 

REPORTS
Lastly like always, the Report menu. There are 3 options of reports in this farm management access template, which all has been presented in previous pictures. You can select the report periods by fill the Start and End fields. You can download this microsoft access database from access-templates.com for free.