If you are thinking about using a database program like Microsoft Access instead of an Excel spreadsheet or storing data in lists, you might be wondering if Access will be able to meet all of your needs. The following are a few factors that you might want to consider:
Users
How many people will be using the database?
Even though the latest version of Access will support up to 255 concurrent users, it is more practical to select Access when there will only be approximately 15 to 20 concurrent users.
Location
Are all of your users located in one location?
It is more practical to select Access if the application will only be accessed by people in one centralized office.
Spreadsheet Size
How large is your spreadsheet?
A spreadsheet can generally handle approximately 65,000 rows. If your spreadsheet is approaching that limit, you might want to consider using a DBMS (Database Management System) like Microsoft Access.
Storing Large Amounts of Data
A single table in an Access database is capable of storing more than 1 million large to medium-width records or 5 million small-width records. Small width records are defined as those records that have 3-4 numeric or short text fields.
Budget
Are you on a tight budget?
Microsoft Access is a popular choice when there are monetary constraints to consider. Access is often the database of choice to fit a project’s budget due to the cost benefits.
As with all guidelines, there are always exceptions. Feel free to contact us to see if we can help fulfill your needs and determine the right solution for your business.