Database Template question
Thread Starter
Joined: Jul 2000
Posts: 1,735
Likes: 21
From: Used to be God's own County
Database Template question
i think that's what I'm after......
looking to 'computerize' my flight quotes for ease of access etc
currently have sheets of paper with all the usual name, address, flight dates, flight costs, contact details etc.
what is the easiest way of collating data and being able to pull it up for use with quotes and subsequent invoices?
Everytime I start to build an access database I start losing the plot as it all seems over-complicated for what I need.
use MS office on laptop and need to sync with ipaq.
thanks
looking to 'computerize' my flight quotes for ease of access etc
currently have sheets of paper with all the usual name, address, flight dates, flight costs, contact details etc.
what is the easiest way of collating data and being able to pull it up for use with quotes and subsequent invoices?
Everytime I start to build an access database I start losing the plot as it all seems over-complicated for what I need.
use MS office on laptop and need to sync with ipaq.
thanks
Administrator
Joined: Mar 2001
Aviation Qualifications: PPL
Posts: 8,121
Likes: 686
From: Twickenham, home of rugby
If you find Access too daunting, you could try using Excel.
Please understand that using Excel as a "database" is much less robust, far less powerful and much more error-prone than Access, but it has the benefit of simplicity, and you can generally see exactly what you are doing.
Obviously, Excel does NOT provide you with the relational capabilities of Access, but if you get comfortable with Excel you may be able to use the work as a "stepping stone" into Access - especially if you begin to find Excel too limiting for what you want to achieve!
HTH
SD
Please understand that using Excel as a "database" is much less robust, far less powerful and much more error-prone than Access, but it has the benefit of simplicity, and you can generally see exactly what you are doing.
Obviously, Excel does NOT provide you with the relational capabilities of Access, but if you get comfortable with Excel you may be able to use the work as a "stepping stone" into Access - especially if you begin to find Excel too limiting for what you want to achieve!
HTH
SD
