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
Bookmarks