Access inventory baseAccess

Inventory database in Access: tables, queries and forms guide

Usually ready in 15 minutesRevisions includedQuality check
Packages
Payment protectionDetails
  • Revisions within the package are free.
  • If you do not respond within 3 days of delivery, the work is accepted automatically.

The money is reserved when you pay and released only once you accept the work.

Inventory database in Access: tables, queries and forms guide

Example result

Example for the Standard package

Access database structure for a small tool rental shop

Client: a tool rental shop that keeps everything in three Excel files. Task: an Access database design: tables, keys and links, with steps to build it.

TableFieldsKey
CustomersCustomerID, Name, Phone, Email, IDChecked (Yes/No)CustomerID
ToolsToolID, Name, Category, DailyRate, Deposit, StatusToolID
RentalsRentalID, CustomerID, RentDate, DueDate, ReturnDateRentalID
RentalItemsRentalID, ToolID, Days, PriceRentalID + ToolID

Links: Customers 1 → many Rentals; Rentals 1 → many RentalItems; Tools 1 → many RentalItems. Referential integrity is on, so a rental cannot point to a missing customer.

Query "Overdue today":

SELECT c.Name, c.Phone, t.Name AS Tool, r.DueDate
FROM ((Rentals r INNER JOIN Customers c ON r.CustomerID = c.CustomerID)
INNER JOIN RentalItems i ON r.RentalID = i.RentalID)
INNER JOIN Tools t ON i.ToolID = t.ToolID
WHERE r.ReturnDate IS NULL AND r.DueDate < Date();

Also delivered: steps to import the Excel files, a rental form plan and a daily report of tools out.

The client and all details are made up.

About this service

A small shop or warehouse needs to know what is on the shelf, what came in, what went out and when to reorder, and keeping it in one Excel sheet breaks as soon as two people edit it. Tell us how your stock moves and attach your current lists, and we design an inventory database for Access: products, locations, suppliers, stock movements in and out, a query that calculates stock on hand and a reorder report. You get the tables, SQL and step-by-step guide to the entry forms, so you can build and run it yourself.

What is included

  • What you getAn inventory database design as text on the order page: tables with fields and keys, CREATE TABLE SQL, a stock-on-hand query, a reorder query and report, and a guide to building the receiving and issuing forms. From Standard, also stock by location and a monthly movement report.
  • Core tablesProducts, suppliers, locations, movements
  • Stock on handCalculated from movements, not typed
  • Reorder reportItems below minimum, by supplier
  • Entry forms guideReceiving and issuing step by step
  • Batches and expiryIn Premium, if you track them

How it works

  1. 1
    BriefYou describe how stock moves
  2. 2
    DesignWe design tables, queries and reports
  3. 3
    DeliveryYou get SQL and build steps

What we need from you

How goods arrive and leave (deliveries, sales, returns, write-offs), your product list and any stock sheets as Excel files or screenshots, whether you track batches, expiry dates or serial numbers, the number of locations and your Access version.

We will ask you:

  • How do goods come in and go out?
  • How many products and storage locations do you have?
  • Do you track batches, expiry dates or serial numbers?
  • Which reports do you need every week?

Compare packages

PackagesBasic$15Standard$29Premium$55
What is includedSingle locationSeveral locationsWith batches and expiry
Deadline1 day2 days3 days
Revisions123
Tablesup to 6up to 10up to 14
Stock locations1up to 5up to 20
Batch and expiry trackingNoNoYes
Order BasicOrder StandardOrder Premium

Payment protection

You pay when you order, but the money is released only for accepted work.

  • Fixed priceThe package price does not change after you pay.
  • The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
  • Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
  • Free revisionsAsk for changes within your brief as many times as the package allows.
  • Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
  • Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
How it works →

Questions and answers

Do I get a ready database file?

No. Everything comes as text on the order page: table designs, SQL, VBA and steps. Building it in Access takes from minutes to an hour, depending on size.

Can it connect to my till or online store?

Not directly. We can describe an import of sales exported from your till or store as Excel, which you run regularly yourself.

Is it accounting software?

No. It tracks quantities and movements of goods. Costs and taxes stay in your accounting system.

Did not find your answer?

Packages