ANSWERS: 5
  • You can create a historical catagorization of lettuce variaties.
  • I assume since this question is in the "Microsoft Access" category, you want to know what the advantage is of using a typical relationship database is over using Microsoft Access. The main drawback of Access is that it is a desktop application, not a true client-server database. This makes things like concurrency (multiple people using the database at the same time) and scaling (lots of people using it) very difficult to achieve. In these sorts of scenarios, Access typically performs very slowly, or in some cases actually corrupts data. If you're interested in the advantages of a database over something like a flat file or Excel, please let me know and I'll try to answer that question as well.
  • The main advantage of a relational database over a flat-file system such as a spreadsheet is that it is relational, making it possible to easily manipulate data so that it is displayed in a more useful way.
  • Advantages It means all of the information is together. The information can be portable if on a laptop. The information is easy to access at any time. It's more easily retrievable. Many people can access the same database at the same time. Improved data security. Reduced data entry, storage, and retrieval costs.
  • A database program is useful for managing large lists of information such as a customer list, mailing list, catalog, personnel records, home inventory, collection or product inventory. Once the information is entered (typed) into the computer, the user can quickly and easily look up information and generate lists and reports. The computer makes it easy to add new records to your database or to edit existing records. The information about each item (or person) in the database is called a "record." The different types of information collected, such as name, address, phone number, are called "fields." When you fill in each of the fields, you have completed the record for that person, place or thing. When all of the records are stored together, the information is generally referred to as a "table." This information in the table is the database of information. The information can be viewed in three ways. The "table" view arranges the information into rows and columns, much like a spreadsheet or a telephone book. The "form" view places only one record at a time on the screen. You can arrange the placement of the fields on the screen to create a form that is easy to use. Two examples of form view are address cards and index cards. In "report" view, you can customize the arrangement of information for your printed report. The report can also be in the form of mailing labels, letters, envelopes, or a catalog. The reports may contain calculations such as totals or averages. You can browse the information in your database, sort the information, or locate information. If you were working with a large inventory database containing the stock number, quantity, make and model, cost and date received for the thousands of items you have in stock, you could, for example, ask the computer to show you a separate list containing only the items you have had in stock for a year or more. Or you could inquire about the quantity of a certain item. The entire process would take only a few seconds!

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy