Database Applications

Elements of a database application:

• Tables — Create and enter records.
  • Records are represented by rows.
  • Fields are represented by columns.
• Relationships — Define how records in tables relate to one another.
• Forms — Graphical interface for entering record data.
• Queries — Extract or retrieve related data from different tables based on relationships between the tables.
• Reports — Format tables or queries for printing.

As a database user, you usually see only one aspect of the database - a form. Database forms use a graphical interface to allow a user to enter record data. For example, when you fill out an order form online, you are probably interacting with a database. The information you enter becomes a record in a database table. Your order is matched with information in an inventory table (keeping track of which items are in stock) through a query. When your order is filled, a database report can be generated for use as an invoice or a bill of lading.