What do I want to get out of the tool / What problem I'm trying to solve
- The idea is to import the list of bookings that we are getting from our in-house system on a daily basis to an Access database.
- Have a form to enter the applicable rates by our team for each bookings.
- Ease of maintaining data as it will be placed in one database instead of hundreds of excel workbook.
- Since the all records is in one place, it will be easier to update a record rather than going through hundreds of excel workbooks.
- More control of how the users enter the data (i.e. validations) to make sure all inputs are consistent.
- Ease of generating daily/weekly reports.
What do you have to put into the tool?
- Daily booking list that we are getting from our in-house system it's in a .csv format
- Applicable rates for each bookings
Current workflow -
1. Download the booking list from our in-house system (csv format)
2. Copy the list and paste it to the excel template
3. Populate the excel workbook with applicable rates that can be found in our in-house system.
4. Send the completed excel workbook to the reservations team.
Basically, the data that will go to 'reservations' table is already predefined. So what I do think is that it will not be necessary to normalize the 'reservations' table and break it down to multiple tables. The idea is, instead of the team putting the booking list to an excel workbook, it will be instead imported in an Access database. From there, a form will be served for them to populate with it the applicable rates which will be stored to a different table and the ref_id will be the key identifier.