Access Chapter 1
A principle stating that techniques are used to ensure the accuracy of data entered into a table.
Second Principle of Good Data
To add on to the end of an object, such as to add records to the end of an existing table, is to
Append
The data type that describes a unique sequential or random number assigned by Access as each record is entered is
Autonumber
A field in one or more tables that stores the same data.
Common Field
The data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places is
Currency
Facts about people, events, things, or ideas.
Data
The characteristic that defines the kind of data you can store in a field is the
Data Type
An organized collection of facts about people, events, things, or ideas related to a specific topic.
Database
The window area that organizes the database objects and from which you open objects.
Navigation Pane
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
Tables, forms, queries, and reports are known as database
Objects
The basic parts of a database; for example tables, queries, forms, and reports.
Objects
The action of filling a database with records.
Populate
The field that uniquely identifies a record in a table is known as the
Primary Key
The object that retrieves or filters 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
Each row in a table represents a
Record
A more sophisticated type of database that stores multiple collections 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
The object that displays fields and records from a table or query in a printable format is a
Report
The Access view that displays data in columns and rows like an Excel worksheet is
Datasheet View
A single piece of information that is stored in every record and represented by a column in a table.
Field
Each column in a table represents a category called a
Field
A principle stating that data is organized in tables so that there is no redundant data.
First Principle of Good Data
A simple database file that is not related or linked to any other collection of data.
Flat Database
Data that is organized in a useful manner.
Information
The Access object that stores your data organized in an arrangement of columns and rows is called a
Table
The database object that stores the data and is the foundation of an Access database.
Table