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.
Each row is one stamp: In or Out. Coming in and leaving later are two rows. Open hides inactive.
| ID | Plate | Spot | Dir | Date |
|---|
Stay
| ID | Name | Job | Phone |
|---|
Associate
Save this person first. The Vehicles tab stays grey until then — waiting, not broken.
| Plate | Color | Make | Model |
|---|
| ID | Name | Phone |
|---|
Visitor
Save this person first. The Vehicles tab stays grey until then — waiting, not broken.
| Plate | Color | Make | Model |
|---|
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
- On the first screen, click Stays. That is the gate.
- The left list is today’s stamps. Open hides inactive rows. All brings them back.
- 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
- Click New.
- Driver is required. The list shows a person and a plate (the combo stores an ID).
- Pick a ParkingSpot (A1, A2, B1, B2) and Direction (In or Out).
- Set StayDate and StayTime.
- 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
- Click Menu, then Associates (or Associates on the first screen).
- Click New. First name and last name are required. Save.
- Open the Vehicles tab. It stays grey until that person is saved. That is waiting, not broken.
- Type LicensePlate and Color (Make and Model are optional). Click Add vehicle.
- 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 employees —
tblEmployeesmatches Time Card. - tblVisitor is not tblCustomers — visitors are people (FirstName / LastName), not companies.
- Not fleet Vehicles — plate and colour sit on
tblDriver. CanonicaltblVehiclesis 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.