getting started

J

jose

I work in a travel agency. Data is huge month to month.
Data includes Passanger name, invoice, $ amount, etc. For
a faster and cleaner search for a passanger's travel
information How can I transfer Excel worksheets into
Access for faster viewing of a specific passanger's
information on file?
 
A

Allen Browne

You can link or import an Excel spreadsheet in Access with:
File | Get External

However, it will involve many weeks of work to build a true database, with
the correct relational structure between passangers, travel schedules,
invoices, payments, groupings, suppliers, ..., and then build the forms for
entering data into these structures, and then build the queries to extract
the information you want and the reports that should be printed.

If you are doing this part time and learning Access as you go, it will take
you a couple of years to get create a workable piece of software.
 
Top