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

Access 2013

Tutorial 1-3

QuestionAnswer
A(n)_____ is a single characteristic of a person,place,object event or idea. field
You connect the records in two separate tables through a(n) _______ that appears in both tables common fields
a field, or a collection of fields, whose values uniquely identify each record in a table. no two records can contain the same value for this field. primary key
The primary key, whose values uniquely identify each record in table is called a(n)______ when it is placed in a second table to form a relationship between two tables. foreign key
The ______ is the area of the Access window that list all the objects in a database, and it is the main control center for opening and working with database objects Navigation Pane
The new blank table that access created is displayed in _________ ______. Datasheet view
A set of field values Record
The specific value, or content, of a field is called the what? field value
A collection of fields that describe a person, place, object, event, or idea table
A software program that lets you create databases and then manipulate data in them. Database management system
In a __________ __________ _________ _________, data is organized as a collection of tables. Relational database management system
A predesigned database that includes professionally designed tables, reports, and other database objects that can make it quick and easy for you to create a database. Template
To Copy the records from a table in one database to another table in a different database, the two tables must have the same _______ structure
A(n) _________ is a question you ask about the data stored in a database query
The quickest way to create a form is to use the ________ form tool
Which view enables you to see the total number of pages in a report and navigate through the report page? Print Preview
In the Navigation pane, each database object has a unique _______ to its left that identifies the object's type. Icon
________ a database rearranges the data and objects in a database to decrease its file size and enhance the speed and performance of the database Compacting
________ a database is the process of making a copy of the database file to protect the database against loss or damage Backing up
What is the purpose of the Data Type property for a field? it determines what field values you can enter for the field and what other properties the field will have
The _____ property specifies how a field's name is displayed in database objects, including table and query datasheets, forms and reports? caption property
For which three types of fields can you assign a field size? Text, number, and AutoNumber fields
The default field size property setting for a short text field is? 255 characters
In Design view, which key do you press to move from the table design grid to the field properties pane? f6
What is the keyboard shortcut for inserting the value from the same field in the previous record into the current record? CTRL
______ data is a process that allows you to copy the data from a source without having to open the source file. Importing
The _____ gallery allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually. data type
A(n) ____ text file is one in which fields of data are separated by a character such as a comma or tab. Delimited
The _____ is the "one" table in one-to-many relationship, and the ___ is the "many" table in the relationship primary table,related
____ is a set of rules that Access enforces to maintain consistency between related tables when you update data in a database. Referential integrity
insert or delete characters in a field value database editing mode
access selects an entire field value database navigation mode
Created by: Rainmaker2123
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