Oct
21
Database for courier business – access?
By
ideaspclst questioned:
I want to start a courier business. I am plotting on only serving a select business type so I will have limited customers. I need to know if Access would be a excellent app to use to track courier activity as well as printing out forms based on the info entered in the database. I would need it to be accessible by a telecommuting employee to input data into my database. Any info or informative sites would be greatly appreciated!
Email Marketing & Email Sending
I want to start a courier business. I am plotting on only serving a select business type so I will have limited customers. I need to know if Access would be a excellent app to use to track courier activity as well as printing out forms based on the info entered in the database. I would need it to be accessible by a telecommuting employee to input data into my database. Any info or informative sites would be greatly appreciated!
Email Marketing & Email Sending
For remote use and scaleability Access is not excellent. You are better using a web based system like php and mysql. You will also need a fixed ip address on your connection for the remote access to work.
Access would work just fine — especially since you have a limited customer base.
I have used different versions of Access with web forms for years and have never experienced a single problem with it. Access is simple to use and simple to learn.
ยง
Any decent web hosting company will give you PHP and MySQL as databases… then, all you need is a excellent content-management system as the basis for your website, so you’re not re-inventing the wheel. Have a look at Drupal, here…
Access is really simple to set up and use, so it’ll probably work very well for you. Filemaker is also a excellent option.
If you want several people accessing the database at the same time, consider MS SQL Server Express Edition (free) with several people using Access (with linked tables) to work with the database. SQL Server is better suited to handling multiple users at the same time.