Travel Database



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.

Skills: Microsoft Access

See more: how to create a travel website, expert microsoft access, access database expert, microsoft share, microsoft professional, how to pull data from a website, expert travel, travel report, travel request, access database track travel, expenses report, travel expert, report variable, create database travel website, access receiving database, cost code database, form drop database, access create database, create flight website, travel database ideas, access database track time, track time access database, travel access database, database track travel, professional looking database

Project ID: #4439397