21 data manipulation language structured query

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Automated or manual file storing definitions of data elements and their characteristics • Querying and reporting • • 5.21 Data manipulation language • Structured query language (SQL) • Microsoft Access query-building tools Report generation, e.g. Crystal Reports Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information Database Management Systems Access Data Dictionary Features Figure 5-9 Microsoft Access has a rudimentary data dictionary capability that displays information about the size, format, and other characteristics of each field in a database. Displayed here is the information maintained in the SUPPLIER table. The small key icon to the left of Supplier_Number indicates that it is a key field. 5.22 Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information Database Management Systems Example of an SQL Query Illustrated here are the...
View Full Document

This document was uploaded on 02/11/2014.

Ask a homework question - tutors are online