If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
database that contains employee travel details
I have an excel spread sheet that contains employees business travel details
with the headings: Traveller; Travel Date; Cost Centre; Division; Airport 1; Airport 2; Airport 3; Airline; Stadard Fare, Fare Offered; Fare Paid; Taxes; Savings accepted; Savings Declined. I would like to know if it is worthwhile in creating a database that that will allow me to produce reports such as 'who' 'when' 'where' etc. Any help will be greatly appreciated. |
#2
|
|||
|
|||
database that contains employee travel details
First you will want to 'normalize' your data. Databases are not Excel.
you will want tables something like Personnel PersonnelID *key stuff about people Divisions DivisionID *key stuff about divisions Trips TripID *key DateStart DateEnd CostCenter Division ReasonForTrip Other Stuff about the trip TripsLegs (1:M) to Trips TripLegId *key TripID *foreign key Departure date\time DepartureAirport Arrival Date\time ArrivalAirport other stuff about the leg Where you put the info about taxes and fairs depends on your information model, could be as part of a tripleg, if it that is the way you need to store it or it could be part of the overall trip (total amounts). You may also want to keep some information about lodging and lodging costs and misc costs related to parking\ taxi's \ tips\meals Ed Warren. "AJ" wrote in message ... I have an excel spread sheet that contains employees business travel details with the headings: Traveller; Travel Date; Cost Centre; Division; Airport 1; Airport 2; Airport 3; Airline; Stadard Fare, Fare Offered; Fare Paid; Taxes; Savings accepted; Savings Declined. I would like to know if it is worthwhile in creating a database that that will allow me to produce reports such as 'who' 'when' 'where' etc. Any help will be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query missing data | LHEMA | Running & Setting Up Queries | 8 | December 9th, 2005 01:15 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Transferring information from one table to another | jwr | Using Forms | 5 | August 6th, 2005 02:06 PM |
Referencing a newly created worksheet | Charyn | Worksheet Functions | 2 | May 2nd, 2005 04:13 AM |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |