getting started

  • Thread starter Thread starter jose
  • Start date Start date
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top