Access Chapter 1
Record
...
Record Selector Bar
...
Record Selector Box
...
Redundant
...
Relational Database
...
Report
...
Run
...
Second Principle of Good Database Design
...
Select Query
...
Simple Select Query
...
Single-record Form
...
Source File
...
Structure
...
Table
...
Tables and Related Views
...
Text Data Type
...
Truncated
...
Wizard
...
Caption
A property setting that displays a name for a field in a table, query, form, or report other than that listed as the field name
Flat Database
A simple database file that is not related or linked to any other collection of data
Field
A single piece of information that is stored in every record and formatted as a column in a database table
Navigation Area
An area at the bottom of the Access window that indicates the number of records in the table and contains controls (arrows) with which you can navigate among the records
Navigation Pane
An area of the Access window that displays and organizes the names of the objects in a database; from here, you can open objects for use
Object Window
An area of the Access window that displays open objects, such as tables, forms, queries, or reports; by default, each object displays on its own tab
Database
An organized collection of facts about people, events, things, or ideas related to a specific topic or purpose
Field Properties
Characteristics of a field that control how the field displays and how data can be entered in the field
Layout View
The Access view in which you can make changes to a form or report while the object is running - the data from the underlying data source displays
Form View
The Access view in which you can view the records, but you cannot change the layout or design of the form
Datasheet View
The Access view that displays data organized in columns and rows similar to an Excel worksheet
Populate
The action of filling a database table with records
Objects
The basic parts of a database that you create to store your data and to work with your data; for example, tables, forms, queries, and reports
Data Type
The characteristic that defines the kind of data that can be entered into a field, such as numbers, text, or dates
Primary Key
The field that uniquely identifies a record in a table; for example, a student ID number
Normalization
The process of applying design rules and principles to ensure that your database performs as expected
Import
The process of copying data from another file into a seperate file
Data Source
The table or tables from which a form, query, or report retrieves its data
Destination Table
The table to which import or append data
DBMS
An acronym for database management system
Database Template
A preformatted database for a specific purpose
Link
A connection to data in another file
AutoNumber Data Type
A data type that describes a unique, sequential, or random number assigned by Access as each record is entered and that is useful for data that has no distinct field that can be considered unique
Query
A database object that retrieves specific data from one or mor
Blank Database
A database that has no data and has no database tools - you must create the data and the tools as you need them
Common Field
A field in one or more tables that stores the same data
Multiple Items Form
A form that enables you to display or enter multiple records in a table
Permissions
Access for others to the files within your folder
Best Fit
An Access command that adjusts the width of a column to accommodate the column's longest energy
Currency Data Type
An Access data type that describes monetary values and numeric data that can be used in mathematical calculations involving data with one to four decimal places
Form
An Access object you can use to enter new records into a table, edit or delete existing records in table, or display existing records
Design View
An Access view that displays the detailed structure of a query, form, or report; for forms and reports, may be the view in which some tasks must be performed, and only the controls, and not the data, display in this view
First Principle of Good Database Design
Data is organized in tables so that there is no redundant data
Information
Data that is organized in a useful manner
Database Management System (DBMS)
Database software that controls how related collections of data are stored, organized, retrieved, and secured
Data
Facts about people, events, things, or ideas
Append
To add on to the end of an object; for example to add records to the end of an existing table
Export
To copy data from one file into another file
