MS Access

ACCESS is a relational database allowing manipulation of data and presentation of reports. A database is a tool for collecting and organizing information. Databases can store information about people, products, orders, or anything else. Many databases start as a list in a word-processing program or spreadsheet. As the list grows bigger, redundancies and inconsistencies begin to appear in the data. Unless it has been specifically designed to use data or code from another source, an Access database stores its tables in a single file, along with other objects, such as forms, reports, macros, and modules. Using Access, you can:

  • Add new data to a database, such as a new item in an inventory
  • Edit existing data in the database, such as changing the current location of an item
  • Delete information, perhaps if an item is sold or discarded
  • Organize and view the data in different ways
  • Share the data with others via reports, e-mail messages, an intranet , or the Internet