How people use Access

Very simply, Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis.  Microsoft Access can help you overcome the limitations found when trying to manage large amounts of information in Microsoft Excel or other spreadsheet applications.

The value any database can provide is to store related information in one place, and then let you connect various different things together (sometimes called “entities” in database speak).  You store one version of the truth for any given thing, like a client, a DVD, or an order.  Some of the major benefits to using a database are:
  1. Fewer errors and inconsistencies.  Maintaining one version of the truth for the things you need to track minimizes the potential for duplication, errors, and inconsistent values.  In the Excel example above, customer names, contact phone numbers, and product names are misspelled, transposed, and abbreviated in different forms.  Imagine trying to create a report or graph in Excel that shows an accurate picture of your sales or other key performance indicators.
  2. Higher productivity. You and others working in your database need only change a single record and all other related things in your database will automatically “see” the change.   In our Excel example, you would need to change every occurrence of a customer’s name.  Find and replace wouldn’t necessarily catch that a customer’s name is spelled six different ways.  In a database, there is only one customer record to change.  Every other record (orders, contacts, etc) that relates to that customer record will never need to change because they are joined to the customer.

Microsoft Access works in the same manner any database does, by storing related information together, and letting you create connections (commonly called relationships) between different things.  The relationships between two different things in MSAccess can be very simple (such as a contact at a customer and the customer itself) or complex.  In the example below, the blue boxes represent the major things we’re tracking in our MS Access database tables, and the reports at right show how you can join the related information for analysis and reporting.

http://www.opengatesw.net/ms-access-tutorials/What-Is-Microsoft-Access-Used-For.htm

 

-Phil Loprete

 

 

About pl150105

NO-CARD
This entry was posted in Office 2013, Uncategorized. Bookmark the permalink.