Save
Upgrade to remove ads
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

Access Module 2

QuestionAnswer
Attribute Information about the entity.
Cardinality The number of instances of one entity that relates to one instance of another entity. Cardinality is expressed as one-to-many, many-to-many, or one-to-one.
Composite key A primary key composed of two fields.
Data type The characteristic that defines the kind of data that can be entered into a field, such as numbers, text, or dates.
Delimiter A character used in a text file to separate the fields; it can be a paragraph mark, a tab, a comma, or another character.
Entity Person, place, item, or event that you want to keep data about.
Field size The maximum length of a data field.
Foreign key The field that is included in the related table so the field can be joined with the primary key in another table for the purpose of creating a relationship.
Format How Access displays data.
Input mask A field property that determines the data that can be entered and how the data is displayed.
Join Create a relationship between two tables based upon a common field.
Junction table A table that breaks down the many-to-many relationship into two one-to-many relationships.
Many-to-many relationship A relationship between tables where one record in one table has many matching records in a second table, and a single record in the related table has many matching records in the first table.
Natural primary key A primary key that is a natural part of your data.
Normalization The process of minimizing the duplication of information in a relational database through effective table design.
Number data type A data type that can store only numerical data. The data field will be used in calculations.
Numeric key A primary key with a number data type. AutoNumber is often used for numeric keys.
One-to-many relationship A relationship between two tables where one record in the first table corresponds to many records in the second table—the most common type of relationship in Access.
One-to-one relationship A relationship between tables where a record in one table has only one matching record in the second table.
Primary key The field that uniquely identifies a record in a table.
Redundancy Data that is repeated in a manner that indicates poor database design.
Relationship An association that you establish between two tables based on common fields.
Text data type A data type that can store either text or numerical characters.
What are the initial design steps when designing a database? Identify your entities, identify the attributes and specify the relationships between the tables
A(n) __________ is a person, place, item, or event that you want to keep data about. Entity
Typically the attributes you define in the design process become __________ within your database. Fields
__________ are the characteristics that define the kind of data that can be entered into a field, such as numbers, text, or dates. Data types
Which of the following is true when cutting and pasting from Excel to Access? "Use Cut and Paste when you first export the data into Excel and make additions, columns must be exactly the same in Excel and Access and if you have any doubt about the files being compatible, you can use import to append the data to the table.
Created by: antoszewskim
 

 



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