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
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 2007

Questions about Microsoft Access 2007

QuestionAnswer
In an Access table, data is saved automatically as soon as you leave the record or close the table. True
Once you enter data into a record, you cannot go back and make changes to the data. False
If you accidentally delete a record, click undo to retrieve the record back to its position in the table before the deletion. False
Tables can only be sorted by one column at a time. False
Creating a report in Access gives more control over how data is printed than printing directly from a table’s datasheet. True
Unlike other Microsoft applications, only one database can be open at a time. True
Double-clicking the column boundary performs the Best-Fit command. True
When viewing a table in Datasheet view and you click the Delete button, a message box appears asking you to confirm the deletion. True
The Field Size property can be used to limit the number of characters that are allowed in a field entry. True
The field in a table that makes each record unique is referred to as the constant key. False
Landscape orientation rotates the printout to print wider than it is taller. True
A query is an Access object designed to extract data from one or more tables. True
A form is composed of a series of objects referred to as controls. True
The button used to run a query contains the icon asterisk (*). False
Templates are databases that already have forms, reports, and tables created for you. True
If you have a database containing information about students, then all the information about one student would be referred to as a record
If you have a database containing information about students, then the student’s last name would be an example of a field
Press these keys to move to the first field of the first record in a table. Ctrl + Home
Within an Access table, each record is represented by one row
Within an Access table, each field is represented by one column
Each database must contain at least one table
Use this view to display a table in columns and rows. Datasheet view
The Edit Mode is turned on by pressing: F2
A relational database is one in which: tables are joined together within a database.
When using the Table Wizard to choose a field from the Sample Fields list box to include in your table, click the desired field and then click the button that contains which of the following symbol(s)? >
What task does the Query Run button perform? It displays the resulting records and fields produced by the query.
When using the Simple Query Wizard, to choose all fields from the Available fields list box to include in the Selected Fields, click the button that contains which of the following symbol(s)? >>
A ______ field is used when you want to restrict the data entered into the field to a list of values. lookup
Access is called a relational database management system because of the relationships that can be established among tables
Adding a ____ to the query design will cause Access to display only those records that meet the requirements. criterion statement
Created by: weever
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