Access database designAccess

Access database structure for your data: tables, keys and links

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.

Access database structure for your data: tables, keys and links

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

Most small Access databases go wrong at the start: one huge table, the same customer typed in many rows, text fields used for dates and no keys linking anything. Describe what you track, attach your paper forms, a Word description or Excel lists, and we design the structure: tables, fields with Access data types, primary keys, the relationships between tables and the lookup lists. You get it as plain text with the steps to build it in Access, so the data stays clean as it grows.

What is included

  • What you getA database design as text on the order page: each table with fields, data types and keys, the relationships with their join rules, lookup lists and step-by-step build instructions for Access; from Standard, also CREATE TABLE SQL you can run.
  • Tables and fieldsWith Access data types and sizes
  • Keys and linksPrimary keys, foreign keys, referential integrity
  • Lookup listsStatuses, categories and units
  • Build stepsClick by click in Access
  • SQL scriptFrom Standard: CREATE TABLE code

How it works

  1. 1
    BriefYou describe what you track
  2. 2
    DesignWe split data into linked tables
  3. 3
    DeliveryYou get the design and build steps

What we need from you

What you want to track and who uses the database, your current paper forms, Excel lists or a description in Word (as files, screenshots or pasted text), the reports you need out of it and your Access version.

We will ask you:

  • What does the database need to track?
  • How many people will use it at the same time?
  • Which reports do you need from it?
  • Which Access version do you use?

Compare packages

PackagesBasic$12Standard$25Premium$49
What is includedUp to 5 tablesUp to 10 tables with SQLUp to 20 tables with queries
Deadline1 day2 days3 days
Revisions123
Tablesup to 5up to 10up to 20
SQL scriptNoYesYes
Starter queriesnoneup to 3up to 8
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 I send my .accdb file?

No, database files cannot be opened here. Send screenshots of the table design and relationships window, or export tables or queries to Excel and attach them (hide personal data first).

Is Access the right tool for us?

For a few users on one network it usually works well. If you expect many users or remote access, we note it so you can plan a move to a server database later.

Did not find your answer?

Packages