BIM Access 2 Review Practice Study Guide Test.
Access is a relational database program you can use to create tables that are ________ within the same database. - CORRECT ANSWER related or connected
What are the two general categories of database management systems? - CORRECT ANSWER file manag...
BIM Access 2 Review Practice Study
Guide Test.
Access is a relational database program you can use to create tables that are ________ within the same
database. - CORRECT ANSWER related or connected
What are the two general categories of database management systems? - CORRECT ANSWER file
management system and relational database management system
Which of the following features is found in a relational database management system but not in a file
management system? - CORRECT ANSWER the ability to define relationships between tables
A relational database management system eliminates the need for - CORRECT ANSWER data
redundancy. (Redundancy is repeating the same task over and over multiple times.)
Chapter 2 emphasizes that in planning your database and its related tables, it is important to consider -
CORRECT ANSWER what each table is "about".
The ability to relate, or ________, tables is part of what makes Access a relational database system. -
CORRECT ANSWER join
A database table can contain these two different types of keys. - CORRECT ANSWER primary and foreign
A table should be about ________ subject(s). - CORRECT ANSWER one
If a value is not entered in a field, Access actually enters a - CORRECT ANSWER null value.
When a table is opened, it is sorted by - CORRECT ANSWER the primary key field.
, A primary key field ________ contain the same value for different records. - CORRECT ANSWER cannot
For primary key fields, Access enforces entity integrity, meaning that - CORRECT ANSWER it expects a
value in the primary key field(s) for each record in the table.
What happens if you try to leave a primary key field blank? - CORRECT ANSWER Access will not let you
close the database until a value is filled in.
In which group will you find the Primary Key button? - CORRECT ANSWER Tools group on the TABLE
TOOLS DESIGN tab
In defining a primary key, which quick step do you complete just before you click the Primary key
button? - CORRECT ANSWER Click the desired field.
When a relationship is established between two tables, the primary key in one table is joined to the
________ key in the other table. - CORRECT ANSWER foreign
Data in a foreign key field ________ match data in the primary key field of the related table. - CORRECT
ANSWER must
Typically, a primary key field in one table becomes ________ in a related table. - CORRECT ANSWER the
foreign key field
The Show Table dialog box is used for - CORRECT ANSWER adding tables to the Relationships window to
create a relationship.
When you perform a join, you are - CORRECT ANSWER relating one table to another.
How does joining tables help ensure data integrity? - CORRECT ANSWER by forcing a record to be in the
primary table before it can be entered into a related table
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Nursewendo. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
