Skip to main content
13.7: Chapter Review - Key Terms
-
-
Last updated
-
-
Save as PDF
-
Key Terms
-
analytical database
-
a database used by an organization for analytics and decision-making
-
columnar layout
-
a form layout that shows a single record
-
criteria
-
expressions that a database management system uses to limit the results of a query based on matching field values
-
dark data
-
data that is typically not used for analysis and therefore may or may not be valuable to an organization
-
data lake
-
a place to store data that keeps raw copies of the original documents
-
data landscape
-
the entirety of data storage and sharing in an organization
-
data mart
-
a subset of a data warehouse, optimized for specific workgroups or functions
-
data warehouse
-
a large store of data within an organization, often holding historical information and used for decision-making
-
database
-
a structured set of data stored in a way that allows us to make use of it
-
datasheet layout
-
a form layout that lists all records as they would appear in a datasheet
-
Datasheet View
-
view that shows the result of a query in table form
-
Design View
-
view that shows a query in the form of a QBE (query by example) grid
-
development database
-
a database used for experimental testing so that problems can be found and resolved before being pushed to the production database
-
digital database
-
a computerized file that stores data in a structured or organized way and also allows users to make changes to transform data
-
digital platform
-
a place where users can interact with and explore the products and services offered by a company
-
flat files
-
individual digital files that have a tabular structure, such as spreadsheets, tables, and lists
-
group
-
heading that organizes data items that have something in common
-
join
-
a clause used to create a relationship or connection between two records in a table
-
justified layout
-
a layout showing a record-by-record form, arranged across the screen
-
key field
-
a field in a table that serves as a unique identifier for an individual record in a table
-
multiple-item form
-
a form that displays information about more than one record or item at a time
-
navigation form
-
a form that allows you to add formatting, text, and commands to act as an interface, or navigation area, for your database
-
NoSQL database
-
database that stores large amounts of data, including documents and images, in their original format, not in tables
-
object
-
an item in a relational database
-
page footer
-
the bottom section of a document page, which typically repeats across pages and contains information useful to the report reader
-
page header
-
the top section of a document page, which typically repeats across pages and contains information useful to the report reader
-
predefined queries
-
queries used to answer frequently asked questions that meet specific organizational needs
-
production database
-
a database that runs transactions related to an organization’s core business functions
-
query
-
a structured data request
-
record navigation buttons
-
options that open whenever records are shown, enabling users to execute commands in a database
-
relational database
-
a database whose design and structure enable it to communicate with other systems that hold data
-
relational database management system (RDBMS)
-
computer software that provides the functions for a relational database
-
relationship
-
the association between two or more tables based on common fields or columns. It represents the way data is related and connected across different tables within the database
-
report
-
formatted summary of specific information in a database
-
report detail
-
the area where data from the Access database is displayed for each record
-
report footer
-
the bottom section of a report that does not typically repeat across pages and contains the name and dates of the report
-
report header
-
the bottom section of a report that does not typically repeat across pages and contains the number of pages in the entire report
-
simple form
-
a form that displays and allows editing of a single record at a time
-
single point of truth (SPOT)
-
the idea that there is one place storing information that all business units agree is factual
-
split form
-
a form that has two functions; for example, it might display a single record as well as a view of the datasheet in which the record is held
-
SQL View
-
a view that shows a query in structured query language form
-
structured query language (SQL)
-
language used to create and run queries in many relational databases
-
table
-
the structure that holds individual data records in a database
-
tabular layout
-
a form layout that shows all records listed in columns, similar to a datasheet