Help With Creating a Form Pickup Tracker Database (?)

[QueryKid123]

Hi -



Apologies in advance for some of my vague terminology.

I am looking for advice on how to build a database to essentially track "pickups" of forms from various offices across a large company. We primarily currently use an excel document (attached) to track how many documents are picked up from each room in the company on each day. Each day we create a new column in the excel document and input the number of forms picked up from each room. We could theoretically use the excel document forever, but I think it would be good to be able to create queries or reports to output which room usually has the most "pickups" a month.

Does anyone have any advice on how to start this? I've tinkered around a little bit, but am honestly getting a bit lost.

I would love to be able to create a button that when clicked will allow me to:

1. Enter the date the pickup was initiated
2. Bring me to a form? datasheet? that will allow me to enter in the number of forms picked up from each room

I do have a button that will allow me to search for a room i.e., "Room 1" and see a history of dates and pickups and will allow me to enter new information into a subform, but that is too time intensive to do one by one. I would really love to be able to type in a date and then on one "page" enter all the information in.

Would an access database even be appropriate for tracking this information or do you advise I stay with an excel sheet?

Thanks in advance.

[orange]

Can you give us an overview picture of what you are dealing with? This seems like a very small piece of processes supporting a business. So you pick up 5 forms from room 6--then what---what forms, subject,priority,.....

[mike60smart]

Hi
Here is your updated database with the structure normalised and tables related correctly.

Look at the Relationship Diagram to see how Rooms are related to Pickups

[ssanfu]

I was waiting for answers to orange's questions, but .......
So here is my attempt