Thursday, February 26, 2009

Lesson 1 Access Keywords

Database: A collection of data related to a particular topic.

Database Object: Tables, queries, reports, forms, and other objects that are the functional parts of an Access datab
ase.

Database Window: the window that appears when you first open an Access database.

Data sheet: In Access, data displayed in a row-and-column format in table, query, or form.

Data sheet View: In Access, an object view that displays records in a row-and-column format similar too a spreadsheet.

Design View: In Access, an object view that allows you to design and change tables, queries, forms, reports, and other objects.

Field: in Access, a field is displayed as a column in Data sheet view.

Form: An Access database object that holds controls for entering, editing, and displaying data from an underlying table or query.

Form View: In access, object view that usually displays data one record at a time, with added graphical elements for easier reading.

Print Preview: A document view that shows how your document will look when its printed.

Query: In Access, a database object that shows specific data you want to work with. The data may be drawn from multiple related tables, may have several filters applied and may include calculated expressions.

Record: Om Access. a set of information that belongs together, such as a customer's name and address information, or details about a product.

Record Selector: In access, the gray box at the left side of each record in Data sheet view or in
Form view. Click the record selector to select the entire record.

Relational Database: A type of database in which information is stored in separate but related tables, which allows for non redundant, more efficient data storage and retrieval.

Report: In access, a database object that presents data organized and formatted to your specifications.

Table: In Access, a collection of data with the same subject of topic. Data are stored in records (rows) and fields (columns).

No comments:

Post a Comment