answersLogoWhite

0

Microsoft Access is used when you want to make a database. For example if you wanted to make a list of all the people you know and their addresses.

+++

You might use it or an ordinary address-book but it's a hopelessly inefficient way, and a .dbs file is far larger than the .xls one for the same data-set. Excel is far better for a simple, single table like an address-book, a simple inventory, straightforward accounting (one of its original purposes), and for mathematical and graph-plotting work. (Though MS has inexcusably now vandalised its own Excel graph routines!)

'

You would use Access when you need a database, which consists of two or more related and linked tables each holding a separate data set but with some relationship between sets. Access training gives a typical (but obviously fictitious) example, that of a grocery chain, with details of the food products in one table, manufacturers' addresses in another, branch staff names and locations in another, and so on.

'

It allows you to enter, store and retrieve selectively an enormous amount of data in several tables, using very easy-to-use entry forms and report-requests - though actually writing the database to do that is fiendishly difficult - of all the MS programmes, Access is probably the least intuitive and by far the hardest to learn, and very unforgiving if you make some small error.

'

Excel won't create linked tables or easy entry and retrieval forms - but as with anything else, you decide which is the better application for your purpose.

User Avatar

Wiki User

7y ago

What else can I help you with?

Related Questions

Where would the Gettysburg address be stored in a Microsoft access database?

It could be stored in a Memo field, but in reality you would not use Microsoft Access at all to store it. You would store in a Microsoft Word document.


What application software would use for lots of calculations?

Microsoft Access


What Microsoft office can you use to collect and track data?

You would probably be best to use Microsoft Access but you could also use Microsoft Excel, particuarly if there was a lot of numerical data.


Would be a name of a Microsoft Access file?

Type is Microsoft Access Database (.mdb)


Where do you use queries?

Microsoft Access


What is Microsoft access training?

Microsoft Access is a powerful database software application used to build relational databases. Thus, Microsoft Access training is a course for people to understand more about how to use and operate Microsoft Access.


What application software would you use for lots of calculations?

a spread sheet


Where would I be able to sign up for a Microsoft access course in New York?

Microsoft access courses are available in New York. You would be able to sign up for a Microsoft access course through Microsoft's official website or npyl.org.


How would use phrase your ability to use software applications on a resume?

"Extensive experience using Microsoft Office Products" , etc. "Advanced command of Microsoft Access", etc.


Is inventorywpd a Microsoft Access document?

No. A wpd extension is not one from Microsoft Access. It would be a word processing document.


Does Standard properties are unique to Microsoft Access documents?

No, you can use it with Excel and Microsoft word as well.


What are four database programs?

Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.