Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
32 Cards in this Set
- Front
- Back
|
Describes a collection of data organized in manner that allows access, retrieval, and use of that data. |
Database |
|
|
Software that allows you to use a computer to create a database; add, change, and delete data in the database; ask and answer questions concerning the data; and create forms and reports using the data |
|
|
|
A database consisting of a collection of tables, each of which contains information on a specific subject. The kind of database maintained by Access |
Relational Database |
|
|
What each row in the tables are OR information about a given person, product, or event |
Record |
|
|
What each column represents OR a specific piece of information within a record |
Field |
|
|
A way of uniquely identifying each record in the database |
Unique Identifier or Primary Key |
|
|
All the tables, reports, forms, and queries that you create are stored in a single file called a ______ |
Database |
|
|
Where do you work on objects such as tables, forms and reports? |
Access Work Area |
|
|
_____ Tabs for the open objects appear at the top of the work area |
Object |
|
|
List of all the objects in the database |
Navigation Pane |
|
|
The ______ is located at the bottom of the Access Window, presents info about the object, the progress of the current tasks, and the status of certain commands |
Status Bar |
|
|
View in which the table is represented as a collection of rows and columns |
Datasheet View |
|
|
Table and Field Name Rules Names can be up to ______ characters in length |
64 Characters |
|
|
Table and Field Name Rules Names cannot contain periods, exclamation points, _____, or square brackets. |
Accent Graves |
|
|
Table and Field Name Rules Each field in a table must have a ______ name |
unique |
|
|
Type of data that can be stored in the field |
Data Type |
|
|
A maximum number of 255 characters is allowed in a field whose data type is ______ |
Short Text |
|
|
The numbers can be either positive or negative and can be used in arithmetic operations |
Number |
|
|
The values will appear with currency symbols, such as, dollar signs, commas, and decimals |
Currency |
|
|
Integer value in the range of 0 to 255 |
Byte |
|
|
Integer value in the range of -32,768 to 32,767 |
Integer |
|
|
Integer value in the range of -2,147,483,648 to 2,147,483,647 |
Long Integer |
|
|
Numeric values with decimal places to seven significant digits - requires 4 bytes of storage |
Single |
|
|
Numeric values with decimal places to more accuracy than Single - requires 8 bytes of storage |
Double |
|
|
Special identifier required for replication |
Replication ID |
|
|
Number values with decimal places to more accuracy that Single or Double - requires 12 bytes of storage |
Decimal |
|
|
The view in which data is presented in rows and columns, similar to a spreadsheet |
Datasheet View |
|
|
View used to create or modify a table |
Design View |
|
|
property used to explain important details about the field |
Description |
|
|
Access will display this value rather than the field name, in datasheets and in forms |
Caption |
|
|
The small box that precedes the field |
Row Selector |
|
|
Buttons used to move within a table, found near the lower-left corner of the screen when a table is open |
Navigation buttons |
