Category Archives: Office 2013

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.

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

I have no experience of using Access at work. The first time I use Access was in high school. I was helping the teacher to print out all the admission letters to the new transfer students, and actually the template of the letters are the name, we just left the name blank. We had already input all the name in a Access document, then we link the word doc and the access doc together, then we just need to simply type in the student id numbers and the printer will automatically print out all the letter respectively with the names.

I have never used Access before. I hope as time goes by i learn how it works and how it makes work more efficient. I did see on the Internet some of its benefits.

In general, Access stores data in its own format. It can also import or link directly to data stored in other applications and databases. Software developers can also use Access for developing application software, good for solving problems and making life easier. Access is also user friendly, meaning that even a person of little experience can contribute to their job. It facilitates work by allowing users to use templates.

Microsoft Access is used to create and manage computer-based databases on desktop computers as well as connected computers. Microsoft Access can be used for personal information management, in a small business to organize and manage data, or in an enterprise to communicate with servers.

http://www.functionx.com/access/Lesson01.htm

Kevin Meltzer

Even though I don’t use this program at work, I know some things about it. When used properly Microsoft Access is a very powerful tool, It can organize and give you instant answers to things like: “e-mail lists of all male clients”, so that we can let all the male clients know about a sale on guys pants in a store.

Microsoft Access is an important tool to get the job done!.

While interning for a finance firm, I constantly exposed to Microsoft Access for keeping track of customer information. I use the basic access database to input Names, Address, Phone number, Account information and other valuable data. It also has the tools built in to help me create relevant groupings in queries so that all data is clear and up-to-date. Then I can transform any necessary data into query to create spreadsheet that cater to my financial advisor’s needs. For example, If my advisor wants to sort out clients whose incomes are less than $200,000. I can use this data to create spreadsheet that only contain clients whose incomes are less than $200,000 .

I don’t use access at all. I found the following information about how access is used.

Microsoft Access is a computer application used to create and manage computer-based databases on desktop computers and/or on connected computers (a network). Microsoft Access can be used for personal information management (PIM), in a small business to organize and manage data, or in an enterprise to communicate with servers.

Sonila Cela

We do not use Access very much at work.  We have a database set up with all of our client information (location address, contact names, telephone #’s e-mail addresses, etc) which is used to create contact lists.  I personally use it weekly in conjunction with Microsoft Word’s mail merge feature to create labels and paycheck receipts for the payroll distribution.

Joe Frasca