Sample data · this browser only

Parking

A gate list: one stamp is In or Out. Not a car park that takes money, and not the Vehicles fleet book.

How to use this demo · What this demo shows · Demos

Parking (fmnuMain)

Start with Stays. That is the gate. Associates and Visitors are the people who have cars.

How to use this demo

This is a gate list, not a car park that takes money, and not the Vehicles fleet book.

A stay is one stamp: In or Out. Coming in and leaving later are two rows, not one visit with two times.

Start here

  1. On the first screen, click Stays. That is the gate.
  2. The left list is today’s stamps. Open hides inactive rows. All brings them back.
  3. Click a row. The right form is that stamp.

Sample rows already there:

  • Role A (staff), plate SAMPLE-A, spot B1, In at 08:00 and Out at 17:30 — two rows.
  • Role B (staff), SAMPLE-B, B2, In at 09:15.
  • Role A (visitor), SAMPLE-C, A1, In at 10:00.

Record someone arriving or leaving

  1. Click New.
  2. Driver is required. The list shows a person and a plate (the combo stores an ID).
  3. Pick a ParkingSpot (A1, A2, B1, B2) and Direction (In or Out).
  4. Set StayDate and StayTime.
  5. Click Save.

You do not pick “associate” or “visitor” on this form. That was decided when the car was added to the person.

If you change a field and leave, the page asks Do you want to save changes? Yes / No / Cancel.

Add a member of staff and their car

  1. Click Menu, then Associates (or Associates on the first screen).
  2. Click New. First name and last name are required. Save.
  3. Open the Vehicles tab. It stays grey until that person is saved. That is waiting, not broken.
  4. Type LicensePlate and Color (Make and Model are optional). Click Add vehicle.
  5. Two identical cars are told apart by plate and colour.

Add a visitor and their car

Same as associates, from Visitors. Visitors are people (first name / last name), not companies.

Once the car is saved, it appears in the Driver list on Stays.

If the page looks empty or odd

  • Reset seed puts the sample lot back. It asks first.
  • Data lives in this browser only. Another computer will not see your rows.
  • The Vehicles item in the site menu is a different demo (a fleet). Stay on this page for the gate.

What this demo shows

A Microsoft Access non-paying parking lot in the browser: staff, visitors, a vehicle (plate and colour), and an in / out stay.

  • Associates are employeestblEmployees matches Time Card.
  • tblVisitor is not tblCustomers — visitors are people (FirstName / LastName), not companies.
  • Not fleet Vehicles — plate and colour sit on tblDriver. Canonical tblVehicles is a fleet register.
  • Vehicles child tab — idle until the associate or visitor is saved. Two identical cars are told apart by plate and colour.
  • Unsaved changes — Yes / No / Cancel before leaving a dirty record.

Will this work when the data is in a database?

Yes. Stay, driver, associate, and visitor are separate tables with FKs. The source make/model/year catalog is omitted this pass.

Sample data only. Source: Parking Lot on access-diva.com.