61 terms

Microsoft Access Chapter 1


Terms in this set (...)

To add on to the end of an object; for example, to add records to the end of an existing table
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
Best Fit
An Access command that adjusts the width of a column to accommodate the column's longest entry
Blank Desktop Database
A database that has no data and has no database tools-you must create the data and tools as you need them; the database is stored on your computer or other storage device
A property setting that displays a name for a field in a table, query, form, or report other than listed as the field note
Common Field
A field in two or more tables that stores the same data
Currency Data Type
An Access data type that describes monetary values and numeric data that can be used in mathematical calculations involving values with one to four decimal places.
Custom Web App
A database that you can publish and share with others over the Internet
Facts about people, events, things, or ideas
Data Source
The table or tables from which a query, form, or report retrieves its data
Data Type
The characteristic that defines the kind of data that can be stored in a field, such as numbers , text, or data's
An organized collection of facts about people, events, things, or ideas related to a specific topic or purpose
Database Management System (DBMS)
Database software that controls how related collections of data are stored, organized, retrieved, and secured; also know as DBMS
Datasheet View
The Access view that displays data organized in columns and rows similar to an Excel worksheet
An acronym for database management system
Design View
An Access view that displays the detailed structure of a table, 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, displays in this view
Destination Table
The table to which you import or append data
The process of copying data from one file into another file, such as an Access table into an Excel spreadsheet
A single piece of information that is stored in every record; represented by a column in a database table
Field Properties
Characteristics of a field displays and how data can be entered in the field
First Principle of a Good Database Design
A principle of good database design starting that dat is organized in tables so that there is no redundant data
Flat Database
A simple database file that is not related or linked to any other collection of data
An Access object you can use to enter new records into a table, edit or delete existing records in a table, or display existing records
Form View
The Access view in which you can view records, but you cannot change the layout or design of the form
The process of copying data from another file, such as a Word table or an Excel workbook, into a separate file, such as Access database
Data that is organized in a useful manner
Layout View
The Access view in which you can make changes to a form or report while the object is open-the data from the underlying data source displays
A connection to data in another file
Multiple-Items Form
A form that enables you to display or enter multiple records in a table
Navigation Area
An area at the bottom of the Access window that indicates the number of records in the table and contains controls in the form of arrows that you click to 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 open objects for use
The process of applying rules to a database design to ensure that information is divided into the appropriate tables
Number Data Type
An Access data type that describes numbers that might be used in calculations
Object Tab
In the object window, a tab that identifies the object and which enables you to make the open object active
Object Window
n area of the access window that displays open objects, such as tables, queries, forms, or reports; by default, each object displays on its own tab
The basic parts of a database that you create to store your data and to work with your data; for example; tables, queries, forms, and reports
The action of filing a database table with records
Primary Key
The field in a table that uniquely identifies a record; for example, a student ID number at a college
Primary Sheet
A list of characteristics-properties-for fields or controls on a form or report in which you can make precise changes to each property associated with the field or control
A database that retrieves specific data from one or more database objects-either tables or other queries-and then, in a single datasheet. displays only the data you specify
All of the categories of data pertaining to one person, place, event, thing, or idea; represented by a row in a database table
Record Selector Bar
The bar at the left edge of a record when it is displayed in a form, and which is used to select an entire record
Record Selector Box
The small box at the left of a record in Datasheet view that, when clicked, selects the entire record
In a database, information that is duplicated in a manner that indicates poor database design
Rational Database
A sophisticated type of database that has multiple collections of data within the file that are related to one another
A database object that summarizes the fields and record from a table or query in an easy-to-read format suitable for printing
The process in which Access looks at the records in the table(s) included in the query design, finds the records that match the specified criteria, and then displays the records in a datasheet; only the fields included in the query design display
Second Principle of Good Database Design
A principle stating that appropriate database techniques are used to ensure the accuracy and consistency of data as it is entered into the table
Secure Environment
A system that uses controlled servers to ensure that security and privacy of email, to control the storage and use of information and to protect against the loss of confidential data
Select Query
A type of Access query that retrieves (selects) data from one or more tables or queries, displaying the selected data in a datasheet, also known as a simple select query
A computer that provides services on a network such as email server or a file sever
A Microsoft application used for setting up websites to share and manage documents
Short Text Data Type
An Access data type that describes text, a combination of text and numbers, or numbers that are not used in calculations, such as a Postal Code
Simple Select Query
Another name for a select query
Single-Record Form
A form that enables you to display or enter one record at a time in a table
Source File
When importing a file, refers to the file being imported
In Access, the underlying design of a table, including field names, data types, descriptions, and field properties
A format for information that organizes and presents texts and data in columns and rows; the foundation of a database
Tables and Related Views
An arrangement in the Navigation Pane that groups objects by the table to which they are related
Refers to data that is cut off or shortened because the field or column is not wide enough to display all of the data or the field size is too small to contain all the data
A feature in Microsoft Office that walks you step by step through a process