Access helpAccess

Microsoft Access queries and VBA for your database

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.

Microsoft Access queries and VBA for your database

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

Many small businesses still run on a Microsoft Access database that someone built years ago, and now a report is wrong or a new query is needed. Show us your tables with screenshots of the Relationships window and table design, or paste the field lists, and describe what you need. We write the SQL for your queries, explain the joins and criteria and, in Premium, add VBA code for a form button or a report.

What is included

  • What you getReady SQL for each query with steps to create it in Access and a plain note on how it works; from Standard also advice on table structure, and in Premium VBA code with installation steps. Everything comes as text on the order page; we do not send a ready spreadsheet file.
  • SQL queriesSelect, update, append and totals
  • Joins explainedWhy each join and criterion is there
  • Where to pasteSQL view steps for each query
  • Table adviceFrom Standard: keys, duplicates, field types
  • VBA codeIn Premium: for a form button or report

How it works

  1. 1
    BriefYou show the tables and describe the task
  2. 2
    QueriesWe write the SQL and VBA
  3. 3
    FixesIf something fails on your data, we fix it within your package

What we need from you

Screenshots of the Relationships window and the tables involved (or pasted field names and types), your Access version and what each query, form or report should do.

We will ask you:

  • Which Access version do you use?
  • What should the query or report show?
  • Which tables and fields are involved?
  • What result do you expect for one example?

Compare packages

PackagesBasic$12Standard$25Premium$49
What is includedUp to 3 queriesQueries and table adviceQueries with VBA code
Deadline1 day2 days3 days
Revisions123
Queriesup to 3up to 8up to 15
Table structure adviceNoYesYes
VBA codeNoNoYes
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

Can I send my .accdb file?

No, the form takes pictures and PDF, Word or Excel files. Send screenshots of the tables and relationships, or export a table to Excel.

Can you move my database to SQL Server or the cloud?

Not in this offer. We write queries and VBA for your existing Access database.

What if a query returns an error?

We cannot open your database. Tell us the error text and which query, and we fix it within your revisions.

Did not find your answer?

Packages