Upgrade to remove ads
Only $35.99/year

NC 5.02 Database Terms

Terms in this set (17)

Query
a database object created by placing filters and selecting multiple criteria to extract information from one or more tables.
Advantages of a Query
1. can be saved 2. One table can be associated with multiple queries 3. Can perform specialized operations
Difference between a Query and a Filter
A filter is a one time deal and a query is reusable.
Conditional Operators
And & Or
Form
a database object that is used to create a user-friendly format for data entry and retrieval.
Advantages of a Form
1. Expedites the search and data entry processes 2. Easy to read and understand 3. Allows information to be censored
Common Elements of a Form
Graphics, Data, Calculations, Controls, Descriptive text, Subforms
Subforms
forms within and related to a main form through a common field
Report
a database object used to organize, summarize, and print some or all of the data from one or more database tables or queries
Advantages of Reports
1. Can group data from multiple tables, use the data in calculations, and add headings and other format enhancements 2. Can be saved and updated 3. Can be printed in landscape or portrait orientation.
Report Components
Report header, Page header, Group header, Detail section, Group footer, Page footer
Report header
appears once a the beginning of at report and usually contains items such as the company name, address, and logo.
Page header
appears at the top of every page and usually contains field names
Group header
lists the field names in which the data is grouped
Detail section
contains the report details or content information; required
Group footer
used to display sums, counts, or averages of groups of data
Page footer
used to display page numbers and dates
Recommended textbook explanations

Java Methods: Object-Oriented Programming and Data Structures

3rd EditionGary Litvin, Maria Litvin
285 explanations

C++ for Engineers and Scientists

4th EditionGary J Bronson
732 explanations

Data Structures and Abstractions with Java

3rd EditionFrank Carrano
402 explanations

C++ How to Program (Early Objects Version)

9th EditionHarvey M. Deitel, Paul J. Deitel
624 explanations