+ Reply to Thread
Results 1 to 3 of 3

Database in Excel 2007 or Access 2007?

  1. #1
    Registered User
    Join Date
    09-01-2009
    Location
    Madrid, Spain
    MS-Off Ver
    Excel 2007
    Posts
    9

    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
    Last edited by Maria J; 10-09-2009 at 04:41 AM.

  2. #2
    Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    270

    Re: Database in Excel 2007 or Access 2007?

    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.
    "I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
    If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!

  3. #3
    Registered User
    Join Date
    09-01-2009
    Location
    Madrid, Spain
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Database in Excel 2007 or Access 2007?

    Thanks, I will give it a try.

    I'm a newbie in VBA, I will digg into the material.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1