Access documentationAccess

Plain documentation of an existing Access 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.

Plain documentation of an existing Access 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

Inherited Access databases are often kept alive by one person who knows which form to open first and which query not to touch, and nobody else can safely change them. Send screenshots of the tables, relationships, forms and the SQL and VBA you can export, and we write plain documentation: what each table holds, how they link, what each query, form, report and macro does, and the order of everyday tasks. Risky spots, such as delete queries without criteria or code that runs on open, are listed separately.

What is included

  • What you getDocumentation as text on the order page: a table and relationship guide, a list of queries, forms, reports and macros with what each does, an everyday tasks guide and a risk list. You can paste it into a Word file to keep with the database.
  • Tables and linksWhat each holds and how they connect
  • Object catalogueQueries, forms, reports, macros
  • Code explainedWhat each VBA procedure does
  • Everyday tasksStep order for common jobs
  • Risk listDestructive queries and fragile code

How it works

  1. 1
    MaterialYou send screenshots, SQL and VBA
  2. 2
    ReadingWe trace what each object does
  3. 3
    DeliveryYou get the documentation text

What we need from you

Screenshots of the navigation pane, table designs and relationships window, the SQL of queries and VBA modules pasted as text or in a Word file, and what you know about how the database is used today.

We will ask you:

  • What is the database used for today?
  • Who will read the documentation?
  • Which parts are you afraid to touch?
  • Which Access version do you use?

Compare packages

PackagesBasic$12Standard$25Premium$49
What is includedUp to 10 tablesUp to 25 tablesUp to 40 tables
Deadline1 day2 days3 days
Revisions123
Tablesup to 10up to 25up to 40
Other objectsup to 15up to 40up to 80
VBA lines explainedup to 100up to 400up to 1,000
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).

Can Access print this documentation itself?

Its Database Documenter lists properties, but not what objects are for or how tasks flow. We explain purpose and order in plain words; the two work well together.

Will you fix the risky parts?

Not in this service. We list them with what could go wrong; fixes can be ordered as a separate error fix or query service.

Did not find your answer?

Packages