Looking for an Access 2013 Expert
I need a travel database to track all flights for my small company. There would be multiple people submitting the information. I would like to embed the forms to a secure website if possible. I would like to have 3 forms. The first would have the ability to add a traveler and all their information needed to book a flight. The second form would be a flight request form. I would like it to use a drop down menu for the travelers name and pull from that database and autofill in the needed traveler information. There would be a drop down menu with how the flight would be coded for expenses. I would also like it to create a reference code. The third form would be the inputting of a booked flight with all flight information and cost that could relate back to the reference code of the flight request.
I need the database to report the following;
1. Difference between the flight request date and actual travel date
2. Follow up report to monitor a week before when travelers are due to take a flight either depart or return flight
3. A report that runs on a variable time period based on how flights are coded for expenses.
I need the database to have a professional look and feel. Please share your thoughts and ideas. I will select the one that best suits the requirements the above. Once a decision is made I will send over the exact data that is needed in the database.
I look forward to receiving your ideas.