Database Applications

Database applications allow you to organize and manipulate large amounts of data. Databases that allow you to relate tables and databases to one another are referred to as relational databases.

A relational database is a group of tables related to one another by common fields. A table (or datasheet) looks similar to a spreadsheet. Each row in the table contains all the data for a single record. Each column in the table represents a specific data value called a field. All records have the same fields.

For example, a table of employee data might include fields for Employee ID, Last Name, First Name, Address, City, State and Zip Code. Another table for tracking timesheets might have fields for Timesheet Number, Employee ID, Week, Hours Worked, and Total Pay. The two tables are related by the Employee ID field, so the database can generate reports combining information from the two tables.

Most database applications come with templates for common database categories, including project planning, employee timesheets, expense reporting, and inventory management. Rather than trying to design a complex database from scratch, try adapting one of the templates to suit your needs.

DBMS: Database Management System — refers to any application that stores data in multiple tables.

RDBMS: Relational Database Management System — refers to any application that stores data in related tables.

SQL: Structured Query Language — a "query" language used for data retrieval. Programs with a graphical user interface (like Microsoft Access) create SQL code for you when you create a query. Experienced database programmers may write queries directly in SQL code.

Database programs that you may encounter include Microsoft Access, FileMaker Pro, and Microsoft Visual FoxPro. Other database applications (including Web server databases), programs include My SQL, Microsoft SQL Server, Oracle, IBM DB2, and Sybase ASE. There are also numerous database applications for specific uses and industries.