preview

Databases, Forms, and Reports

explanatory Essay
843 words
843 words
bookmark

Databases, Forms, and Reports

This paper will discuss databases, forms and reports. Why has the use of databases increased dramatically? What factors should be considered when designing a database and why? How would you go about designing forms and reports from scratch? In conclusion, a summation will be given along with closing thoughts.

Database Usage

A database is an organized collection of information or data. It is a collection of organized information in which a computer can easily select and display different fields of data. Databases have been in use since the earliest days of electronic computing, but the vast majority of these were custom programs written to access custom databases. Unlike modern systems which can be applied to widely different databases and needs, these systems were tightly linked to the database in order to gain speed at the price of flexibility. As computers grew in capability this tradeoff became increasingly unnecessary, as a number of general-purpose database systems emerged. With the implementation of relational and object-oriented databases, companies found that the use of databases were much more productive and cost effective. Productivity and cost effectiveness being two of the main factors as to why the use of databases has increased dramatically over the years. Most recently there has also become a growing interest in using company data to improve business performance. Queries around business performance analysis were the top datab...

In this essay, the author

  • Explains the use of databases, forms, and reports and enumerates the main reasons for the increase in use.
  • Explains the seven steps in the database design process. the first step is the mission statement and objectives, the second phase is to analyze the current database.
  • Explains that database design is a combination of planning and analysis. planning defines the goals of the database and analyses the requirements.
  • Explains that forms and reports are designed to display or collect data, while reports display static data only. when designing a form or report, certain considerations should be taken into account.
  • Explains that when designing a form or report, you should ask the following questions: • who will use it? • when is it needed and used?
  • Explains that a database is an organized collection of information or data. sql allows you to build, query information from the database, and create forms and reports. database data integrity determines the usefulness of your data input.
  • Cites utexas.edu's a data modeling as part of database design. agiledata.org. data modelling 101.
  • Explains msdn.microsoft.com. the data behind forms and reports.
Get Access