Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010
    Posts
    2

    what are some benefits of a DBMS like MS Access?

    i know this question sounds dumb, but what are some benefits and disadvantages in dealing with data files? i know the question might sound dumb to you but please help. so far i have that you can easily create reports and forms from thousands of data entries by a simple click of the mouse....plz healp people

  2. #2
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    21
    You can store up to 2 gigs of data in an MS Access database. Also it is relational which allows you to relate data together. This makes querying data a breeze and allows easy creations of subforms. Access is a RAD tool also and is good for cleaning up data brought in from other sources.

  3. #3
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    imagine the telephone book with all the entries random....that would be working with data with no database....

    imagine the telephone book with all the entries manually sorted alphabetically - but then you need to add a couple more names - Adams, Booker, Charles....do you want to manually go thru it and figure out where to insert them?? that would be working with data but with no database....

  4. #4
    jbarrum is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2009
    Location
    Houston, Tx
    Posts
    164
    Example,

    If you are using Xcel to keep track of sales being made by sales managers, what products they are selling, and what region they are selling to then in Xcell each time you enter a new record will need to include the Sale Managers name, the region or territory that the sale was made in and what product he sold making data entry very redundant.

    With access you simple house your sales managers in one table, your territories in another table and products in it's own table. This allows you to enter the data once, in one place and relate back to it when entering recoreds that rely on this information saving both time and space.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums