Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
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

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/23

Click to flip

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.