exam 2
The process of applying design rules and principles to ensure that a database performs as expected
Normalization
The window area that displays each open object on its own tab
Object window
In datasheet view, when sorting using multiple fields, the field that is used for the first level of sorting
Outermost
The action of filling a database with records
Populate
The object that retrieves specific data and then displays only the data that you specify is a
Query
A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea.
Record
A set of rules that ensures that the data between related tables is valid
Referential Integrity
The process in which access looks for records in a table based on the fields and criteria in the query design, finds those records, and then displays the records in a datasheet.
Run
A principle stating that techniques are used to ensure the accuracy of data entered into a table
Second principle of good database design
In datasheet view, clicking the plus sign displays the related records in this format
Subdatasheet
The database object that stores the data and is the foundation of an Access database.
Table
To add on to the end of an object, such as to add records to the end of an existing table, is to
append
A sorting order that arranges text alphabetically (A to Z) and number from the lowest number to the highest number
ascending
Sorting a field with the Text data type into alphabetical order (A to Z) is referred to as ___ order
ascending
The ___ data type assigns a unique sequential number to a record
auto number
the data type that describes a unique sequential or random number assigned by access as each record is entered is
auto number
The tables in a relational database are linked or joined to one another by a(n)
common field
The best data type to use for a field that will contain a monetary (dollar) amount is ___.
currency
the data type that describes monetary values and numeric data used in mathematical calculations invovoing data with on to four decimal places is
currency
The characteristic that defines the kind of data you can store in a field is the
data type
The Access view that displays data in columns and rows like an Excel worksheet is
database view
Sorting a field with the Text data type into reverse-alphabetical order (Z to A) is referred to as ___ order
descending
The ___ key is the field in the related (often the "many") table that is often connected to the primary key in the ("one") table.
foreign key
A ___ is the field that uniquely identifies every record in a table.
primary key
The field that uniquely identifies a record in a table is known as the
primary key
Each row in a table represents a
record
A set of rules that ensures that the data between related tables is valid is called
referential integrity
Including common fields in tables and then establishing relationships between those fields is a characteristic of a
relational database
An area where you can view the security and privacy settings for your access installation
trust center
A field in one or more tables that stores the same data
Common field
Facts about people, events, things, or ideas.
Data
An organized collection of facts about people, events, things, or ideas, related to a specific topic.
Database
A sorting order that arranges text in reverse alphabetical (Z to A) order and number from the highest number to the lowest number
Descending
A single piece of information that is stored in every record and represented by a column in a table
Field
Each column in a a table represents a category called a
Field
In the query design window, in the table area, the list of field names in a table
Field list
A principle stating that data is organized in tables so that there is no redundant data
First principle of good database design
A simple database file that is not related or linked to any other collection of data
Flat database
The primary key field is connected to this field in the related table to create a relationship
Foreign Key
Data that organized in a useful manner
Information
In datasheet view, when sorting using multiple fields, the field that is used for the second level of sorting
Innermost
The window area that organizes the database objects and from which you open objects
Navigation Pane
The visual cue in the relationships window that indicates tables are related by connecting common fields
join Line
The area directly below the ribbon that displays information such as security alerts
message bar
Tables, forms, queries, and reports are known as database
objects
The basic parts of a database; for example tables, queries, form, and reports
objects
The most common type of relationship in Access is
one to many
A relationship between two tables, where one record in the first table corresponds to many records in the second table
one to many relationship
a more sophisticated type of database that stores multiple connections of data that are related to one another; for example, data about the students, the courses, and the faculty members at a college is a
relational database
A ___ is an association established between two tables.
relationship
An association that you establish between two tables based on common fields
relationship
The object that displays fields and records from a table or query in a printable format is a
report
The process of arranging data in a specific order based on the data in a field
sorting
The process of placing data in a specific order is known as
sorting
The access object that stores your data organized in an arrangement of columns and row is called a
table
The best data type to use for a number/digit-based field (phone number, Social Security number, etc.) that will not be used in calculations is
text
