- Shuffle
Toggle OnToggle Off
- Alphabetize
Toggle OnToggle Off
- Front First
Toggle OnToggle Off
- Both Sides
Toggle OnToggle Off
Front
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
PLAY BUTTON
PLAY BUTTON
23 Cards in this Set
- Front
- Back
|
What is the name of the database management system tht we are using this semester?
|
Microsoft Access XP (2003
|
|
What is the term used to describe a collection of data organized in a manner that allows access, retrieval, and use of that data?
|
database
|
|
In Access, a database consists of a collection of
|
tables
|
|
A ____________ is a collection of 8 bits.
|
character
|
|
A collection of related bytes is called a?
|
table
|
|
A collection of related fields is called a ?
|
record
|
|
A collection of related records is called a?
|
field
|
|
A database consists of rows and columns. Each row is a ____________, while each column represents ______________
|
record,
field |
|
What is the name of the software tool that can be used to create a database; add, change, and delete data in the database; sort and retrieve data; and create forms and reports using the data in the database?
|
database management system
|
|
In a database table, a(n)___________ contains a specific piece of information within a record?
|
field
|
|
What is the name of the field that is used as the unique identifier for each record?
|
Primary key
|
|
What happens when the mouse pointer is moved over a button on the toolbar?
|
The name of the button appears below it in a screen tip.
|
|
How do you get a shorcut menu to appear for a particular item?
|
by clicking a menu name on the menu bar
|
|
What are the four rules, according to your text, for field names?
|
1. Nme can be up to 64 characters in length.
2. Names can contain letters, digits, and spaces, as well as most of the punctuation symbols. 3. Name connot contain periods, exclamatoin point(!), accent graves (`), or square barckets [] 4. The same name cannot be used for two different fields in the same table. |
|
Describe a text field.
|
The text field can contain any characters. A maximum number of 255 characters is allowed in a field whose data type is Text.
|
|
Describe a Number field.
|
This field can contain only numbers.
|
|
Describe a Currancy field.
|
This field can contain only monetary data
|
|
Describe a Memo field
|
This field can store a variable amount of text or bombinations of text and numbers where the total number of characters may exceed 255.
|
|
Describe a Date/Time field.
|
This field can store dates and times
|
|
Describe an AutoNumber field
|
This field can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is coded.
|
|
Describe Yes/No field
|
This field can store only one of two values. The choices are yes/no, true/false, or on/off.
|
|
Describe an Object Linking and Embedded (OLE) Object field.
|
This field can store an OLE object, which is an object linked to or embedded in the table.
|
|
Describe a Hyperlink field
|
This field can store a value from another table or from a list of values by using a list box or combo box.
|
