Handling meeting bookings in Access

Pankaj S 1 Reputation point
2021-05-25T18:06:16.99+00:00

I want to set up a simple meeting booking application in Access.

  • There are multiple people who can be booked
  • The slots have a defined duration of 30 mins
  • Each person has a schedule (days of week and times of day)
  • A person once booked for a slot can not be booked again

I am totally out of ideas of how to do this apart from creating a massive table with all the "available" slots. Any ideas?

Pankaj
https://www.hyperoffice.com

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
859 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. DBG 2,301 Reputation points
    2021-05-25T18:34:07.35+00:00

    Hi. This appears to be a cross post of this other thread at AWF.

    handling-bookings-in-access.317958

    You don't create one massive table. Instead, you create multiple related tables. Can you show us what you have tried so far?

    0 comments No comments