What is Microsoft Access Used For?

How is Microsoft Access used in Marketing/Business/Sales

I know nothing about what this program can do.

Update:

Yeah - but as far as storing information you can do that with EXCEL??? So what makes them different

7 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Microsoft Access is a database tool where you can create records to store information. For example, in sales, you can create a record for a particular customer which stores the customer's name, address, phone, etc. Sort of like a customer master. In Marketing, you can create a record for a product with information such as product name, description, price, etc. After the records are set up, you can use queries to produce reports against the customers or products. For example, you want a list of customers living in California so you can target them for a special promotion, etc.

    For more information, go to Microsoft's homepage on how to use Access:

    http://office.microsoft.com/en-us/access/FX1006469...

    • Login to reply the answers
  • 1 decade ago

    Microsoft Access is used to make databases. You can make like a database with information for example, a list of Phone numbers, or an inventory. Once you learn how to use MS Access, it's pretty easy after that. And learning how to use is simple.

    • Login to reply the answers
  • 1 decade ago

    Access is basically a flexible database tool. So, for marketing/sales, etc., it could be used as a database to store contacts, client data, etc.

    It is not as intuitive as some of the other Microsoft tools, in my opinion, and takes a bit of getting used to, as it's not "plug and play". That is, you have to learn some very basic things in order to "build" the template to show how you want each record to display.

    As an example, my company uses an Access database to hold information about all of our 350 locations around the country. So, when I want to know a store's address, phone number, opening date, other comments entered by my colleagues, etc., I type the "store number" (in this case) into a field and it instantly pulls up the record with the data I am looking for. Access also allows you to build reports. Again, that feature is very flexible (you can even export the reports into Excel format if you want), but it takes some getting used to.

    I hope this helps! :-)

    Source(s): 10 years of experience using Access
    • Login to reply the answers
  • 4 years ago

    Access is relational database program. It has full Visual Basic capability embedded into it so that it not only manages data, it can be used to design applications to link, collect, analyze, and report on data. Because it is relational, a database that is properly designed can maintain links or join relationships between various data from different sources or from various levels of data. Microsoft Access is at it best in a local environment (personal database) office application. That being said, Access can work reasonably well in a multi-user environment for small and medium size businesses. One approach is to split your database so that the data resides in a separate data-only database on a network, and users run local copies of the database (which contains all the design) with links to the "data" database. This minimizes design corruption that can sometimes occur over a network. Access has reasonable multi-level security controls albeit they take some getting used to. Newer versions of Access have a security wizard that helps with most aspects of securing a database. As to the type of data, virtually anything you can do with Excel you might be able to do more efficiently with Access. The downside of Access is a bit of a learning curve but once you get your tables, queries, forms, and reports set up the way you want them - the design is controlled and your data updating/reporting will be simplified. Have you ever had a chart or graph in Excel that you had to go back to update data ranges all the time? That's what Access can eliminate because it always crunches through all available data automatically. Reports and charts update any time based on new data entered. Actually the line between Excel and Access is a bit blurry. Excel can do database type things like forms, cell (data) validation, pivot tables, and queries (with mutliple data sources) thru MS Query. Similarly, Access is capable of almost all the calculations that Excel does - only the functions are embedded into queries, unbound fields in forms & reports, or VB code. Access can easily handle tens of thousands of records and related data if data is structured properly. Access easily handles data relationships and type, and full-blown reliable applications such as billing data, etc are possible IF you have somebody that knows database structure and VB code. In summary, for thousands of records of business and time critical data with multiple users, you probably need to be at least considering a server-class database like Oracle for reliability and server class performance. If number of users is small, and if some downtime is tolerable (in case you need to recover from a corrupt database), and if your data is dynamic (in other words Excel becomes cumbersome) then Access is a really useful option. Hope this answers your question which I think is about what kinds of things Access can do for a business like the one that that you're job seeking in.

    • Login to reply the answers
  • How do you think about the answers? You can sign in to vote the answer.
  • 4 years ago

    I would say Microsoft Access is used for database. For example you can make information about a person like what's their name, age, sex, eye color hair color, height, weight, birthday and ...

    And it's basically used for details or likes and dislikes and description of a person.

    • Login to reply the answers
  • Anonymous
    6 years ago
    • Login to reply the answers
  • Anonymous
    5 years ago

    If you want to make money online you have to use this method http://www.goobypls.com/r/rd.asp?gid=548.

    I'm using it myself with very good results. It's very easy to follow. It's good for newbies and experts.

    Bye

    • Login to reply the answers
Still have questions? Get your answers by asking now.