Access forms and reportsAccess

Access forms and reports: step-by-step setup guide 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.

Access forms and reports: step-by-step setup guide 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

Tables hold the data, but people work in forms and read reports, and a badly built form lets users type anything anywhere. Send screenshots of your tables and relationships and describe who enters what, and we write a step-by-step guide for your database: data entry forms with subforms, combo boxes and validation, a navigation or start form, and reports grouped and totalled the way you need them. Where a form needs a small piece of VBA, such as a search box or a button that opens a filtered report, we include the code.

What is included

  • What you getA written setup guide on the order page for each form and report: which wizard or design steps to use, the properties to set, validation rules, grouping and totals, plus VBA code where needed. It is a guide for you to follow; we do not edit your file.
  • Entry formsSubforms, combo boxes, default values
  • ValidationRules and messages that stop bad data
  • Start formButtons to open forms and reports
  • ReportsGrouping, sorting, totals, page layout
  • VBA where neededSearch boxes and filter buttons

How it works

  1. 1
    BriefYou send tables and describe the work
  2. 2
    GuideWe write steps for each form and report
  3. 3
    DeliveryYou build them by following the guide

What we need from you

Screenshots of the tables in design view and the relationships window, or a list of tables and fields typed out, who enters which data, the reports you need with an example of the layout (a photo of a paper report works) and your Access version.

We will ask you:

  • Which forms do you need, and who will use them?
  • Which reports do you need, and how should they be grouped?
  • Which mistakes do users make when entering data now?
  • Which Access version do you use?

Compare packages

PackagesBasic$12Standard$25Premium$49
What is included2 forms and 1 reportUp to 5 forms and 3 reportsUp to 10 forms and 6 reports
Deadline1 day2 days3 days
Revisions123
Formsup to 2up to 5up to 10
Reports1up to 3up to 6
VBA snippetsNoup 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

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).

Will you set it up in my database?

No, we do not connect to your computer or files. You get text, SQL and code on the order page with steps to apply them yourself.

Will the forms look modern?

We describe a clean, consistent layout with Access's own controls and themes. Custom graphics and images are not part of the guide.

Did not find your answer?

Packages