Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

DBA 115 ch2 def

QuestionAnswer
best fit "Sizing a column so the column is just wied enough to display the longest visible value in the column, including the field name."
Byte A field Size property that stores whole numbers from 0 to 255 in one byte
cascade deletes option A referential integrity rule that permits a record in the primary table to be deleted and also deletes all records in related tables that have matching foreign key values
cascade updates option A referntial integrity rule that permits a change in value to the primary key and changes all the appropriate foreign key values in related tables.
compsit key A primary key that consists of two or more fields. Also know ans a concatenated key.
data redundancy A condition that occurs when you store the same data in more than one place; it wastes storage space and can cause inconsistencies.
data type The field property that determines what field values you can enter for the field and what other properties the field will have.
Decimal A field Size property that stores positive and negative numbers to precisely 28 decimal places and uses 12 bytes.
Decimal Places property The property that specifies the number of decimal places that will be displayed to the right of the decimal point.
delimited A type of text file in which fields of data are separated by a character such as a comma or a tab.
Description property The optional proerty you can use to enter a description for a field to explain its purpose or usage.
Design view The Access view you use to define or modify a table structure or the properties of the fields in a table.
Double A field Size property that stores positive and negative numbers to precisely 15 decimal places and uses eight bytes.
entity integrity "The condition that exists when a primary key has been specified for a table, whereby Access forces you to enter a value for the primary key field in every record in the table."
F1 Key "The function key you press to dislplay Help information, such as for the current property in the Table Design view"
F2 Key The function key you press to switch between navigation mode and editing mode
field list A small window listing the fields contained in a table
Field Properties pane The part of the Table window in Design view that contains the properties for the selected field.
Field size property "The property that edfines a field's maximum storage size for text, number, and AutoNumber fields."
import a process that allows you to copy the data from a source without having to open the source file
Integer The field size property that stores whole numbers from -32768 to 32767 in two bytes
join To relate tables through a common field
join line "In the relationship window, the line that connects the common field that joins two tables"
Long Integer The field size property that stores whole numbers from -2147483648 to 2147483647 in four bytes
null value The absence of a value in a partcular table entry
one-to-many relationship "A relationship between two tables in which each record in the primary table matches zero, one, or many records in the related table, and in which each record in the related table matches at most one record in the primary table"
orphaned record A records whose matching record in either the primary or related table has been deleted
primary table "The ""one"" table in a one-to-many relationship"
propagate To update field property changes made in Design view to the corresponding property on forms and reports that inclkude the modified field
properties The characteristics of each field in a table
referential integrity The rule that requires each nonnull foreign key value to match a primary key value in the primary table
related table "The ""many"" table in a one-to-many relationship"
Relationships window The Access window in which you define and view the relationships amount a database's table
Replication Id "A Field size property that establishes a unique identifier for replication of tables, records, and other objects in databases created using Access 2003 and earlier versions and uses 16 bytes"
set (a property) To select or enter a property for a field
Single A field size property that stores positive and negative numbers to precisely seven decimal places and uses four bytes
Table Design grid "The part of the Table window in Design view that contains the values for the Field Name, Data Type, and Description field properties"
Created by: saquania
Popular Computers sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards