Thread: Database in Excel 2007 or Access 2007?

I am looking for advice on creating a database in Access 2007 or Excel 2007.

Database features
- Type of data: client project information which includes logos (images), text, date, number fields. The data will be updated weekly. Will increase in size.
- Use of database: queries such as client name, revenue, type of industry, year. No reports for the time being.
- Number of people accessing database: many a time
- Number of people editing database: two
- Location of database: may possibly upload it to MS SharePoint
- Number of computers in business with Access: few
- Number of computers in business with Excel: all

I have some experience with Access and Excel. Currently, Excel is used frequently in the company, there is no Access database in use.

I would happy to receive some insight from experienced users of Excel and Access. In case you suggest Excel or Access 2007, do you know any useful free tutorials or websites that teach how to create a database with these programs?

Thank you in advance

I would recommend access.

Here is why:
You are the only one who "needs" access installed, you can create a deploy-able solution with developer tools. Ie they would open your database in Microsoft Access Runtime.

If you database is going to be constantly growing you will want to eventually move it to a SQL back end. Access has some great tools to assist you with this.

Most importantly, Job Security. As you said most people in your office can use excel. If it is done in Access, and you are the one who knows access/vba, and how it works, then they will be more likely to keep you around.

Data Pig - Lots of great examples.
Tech on the net - This is their functions page.

Those are just a few help full resources. Might be worth buying a book or two. I would suggest and Access 2007 VBA Bible.

This is my disclaimer those may not be the best prices, I do not endorse amazon, I just simply used them as a link to show you the book I am talking about.