chapter 2

append

To add on to end of an object ; for example to add records to the end of an existing table

link

a connection to data in another file

blank desktop database

a data base 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.

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

custom web app

a database that you can publish and share with others over the internet

common field

a field in two 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

database template

a preformatted database that contains prebuilt tables, queries , forms , and report a specific task , such as tracking events

first principle of good database design

a principles of good database stating the data is organized in tables so that the there is no redundant data

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

database management system

database software that controls how related collections of data are stored, organized , and secured ; also known as DBMS

data

facts about people , events,things, or ideas

layout view

the access view in which you can make changes to a form or report while the object is open - the data form the underlying data source displays

form view

the access view in which you can view 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 to an excel worksheet

data type

the characteristic that defines the kind of data can be stored in a field , such as numbers, text, or data

import

the process of copying data from another file , such as word table or an excel workbook , into a separate file, such as an access database

export

the process of copying data from one file into another file, such as an access table into an excel table into an excel spreadsheet

data source

the table or tables from which a query, form, or reports retrieves its data

destination table

the table to which you import or append data

information

data that is organized in a useful manner

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 ; represented by a column in a database table

best fit

an access command that adjusts the width of a column to accommodate the column's longest entry

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 decimals places

form

an access object you can use to enter new records into a table , edit or delete existing records in a table , or displays existing records

design view

an access view that displays the detailed structure of a table, query , form, or reports , 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.

DBMS

an acronym for database management system

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