Question 1

If referential integrity is applied to a one-to-many relationship, what happens?
A) Connects tables
B) Prevents the creation of orphan records
C) Related fields are updated
D) Related fields are deleted

Accepted Answer

When referential integrity is applied to a one-to-many relationship, it prevents the creation of orphan records. This means that the record on the "many" side of the relationship cannot be created if there is no corresponding record on the "one" side of the relationship. This helps to maintain data integrity and avoids having incomplete or inaccurate data in the database.

Question 2

Database templates create sample tables and queries, but not forms and reports.

Accepted Answer

False

Question 3

If you change data in its original location and it is linked to an Access database, you must also update it in the Access database.

Accepted Answer

False

Question 4

You can establish referential integrity with a linked table.

Accepted Answer

The answer of You can establish referential integrity with a...

Question 5

If you link data to an Access database, data can be edited in the original file, but not in the Access database.

Accepted Answer

If you link data to an Access database, the data can be edited in both the original file and the Access database since they are linked and any changes made to one will automatically be reflected in the other.

Question 6

In the figure above, the relationship between the Courses and Materials tables is a(n) ____.
A) One-to-many relationship with referential integrity
B) Many-to-many relationship
C) Cascade Update Related Fields option
D) Cascade Delete Related Records option

Accepted Answer

The figure shows a Courses table and a Materials table with a one-to-many relationship. The relationship is indicated by the arrow from Courses to Materials, representing Courses as the "one" side and Materials as the "many" side. The presence of referential integrity ensures that there will be no orphan records in Materials when a related record is deleted from Courses. The other options, many-to-many relationship and cascade options, are not applicable in this scenario.

Question 7

Which of the following options means that if a value in the primary key field is modified, all values in the foreign key field are automatically updated as well?
A) Cascade Repeat Values
B) Cascade Application Parts
C) Cascade Delete Related Records
D) Cascade Delete Related Fields

Accepted Answer

The answer of Which of the following options means that...

Question 8

Databases created by templates can be modified for your specific needs.

Accepted Answer

Templates are created with a generic structure and can be adjusted and customized to fit the specific needs of an individual or organization.

Question 9

When you publish data to Word from Access, an RTF format document is created.

Accepted Answer

When publishing data from Access to Word, the document is saved in RTF (Rich Text Format) which allows for formatting like bold, underline, and font changes.

Question 10

One use of a database created by a database template is to help you learn more about Access.

Accepted Answer

By exploring a database template and how it was created, you can learn more about the features and functionality of Access.

Question 11

Importing is a process to quickly link to, but not copy data from an external source to an Access database.

Accepted Answer

The answer of Importing is a process to quickly link...

Question 12

Microsoft often changes and updates online templates.

Accepted Answer

Microsoft frequently updates their online templates to improve user experience and add new features.

Question 13

Cascade Update Related Fields automatically updates the data in the primary key field when the matching foreign key field is changed.

Accepted Answer

The answer of Cascade Update Related Fields automatically updates the...

Question 14

In the figure above, the Departments field list is probably a _____
A) Linked table
B) Many-to-many relationship
C) Cascade Update Related Fields option
D) Cascade Delete Related Records option

Accepted Answer

Based on the information given, there is no indication of any relationships or cascade options. The "Departments" field list is most likely a linked table, which refers to a table that is linked to the current table in the database.

Question 15

Enforce Referential Integrity helps prevent records in the "many" table that don't have a matching record in the "one" table.

Accepted Answer

Enforcing referential integrity ensures that any records in the "many" table that reference a record in the "one" table actually have a matching record in the "one" table, thus preventing orphaned records or inconsistencies in the data.

Question 16

Which of the following is NOT a way to set a startup form?
A) Use Access Options
B) Create an AutoExec macro
C) Name a form Startup
D) Each of these methods creates a startup form

Accepted Answer

The answer of Which of the following is NOT a...

Question 17

In the figure above, the relationship between the Courses and Materials tables does not include the enforce referential integrity option.

Accepted Answer

The answer of  In the figure above, the relationship...

Question 18

Cascade Delete Related Records automatically deletes all records in the ____ if the record with the matching key field in a "one" table is deleted.
A) "many" table
B) "one" table
C) database
D) primary key field

Accepted Answer

Cascade Delete Related Records automatically deletes all records in the "many" table if the record with the matching key field in a "one" table is deleted.

Question 19

Which type of template creates a traditional Access database?
A) custom Web app
B) Application Parts
C) custom desktop
D) desktop database

Accepted Answer

Desktop database templates create traditional Access databases that can be stored on a user's computer or shared on a network. Custom Web app and custom desktop templates are used to create more specialized and advanced database applications, while Application Parts allow users to add pre-built functionality to customize their databases.

Question 20

Exporting is the opposite of importing.

Accepted Answer

Exporting involves sending goods or services to another country, whereas importing involves receiving goods or services from another country. Therefore, the two concepts are opposite of each other.

Quiz 9: Importing and Exporting Data

If referential integrity is applied to a one-to-many relationship, what happens?

Database templates create sample tables and queries, but not forms and reports.

If you change data in its original location and it is linked to an Access database, you must also update it in the Access database.

You can establish referential integrity with a linked table.

If you link data to an Access database, data can be edited in the original file, but not in the Access database.

In the figure above, the relationship between the Courses and Materials tables is a(n) ____.

Which of the following options means that if a value in the primary key field is modified, all values in the foreign key field are automatically updated as well?

Databases created by templates can be modified for your specific needs.

When you publish data to Word from Access, an RTF format document is created.

One use of a database created by a database template is to help you learn more about Access.

Importing is a process to quickly link to, but not copy data from an external source to an Access database.

Microsoft often changes and updates online templates.

Cascade Update Related Fields automatically updates the data in the primary key field when the matching foreign key field is changed.

In the figure above, the Departments field list is probably a _____

Enforce Referential Integrity helps prevent records in the "many" table that don't have a matching record in the "one" table.

Which of the following is NOT a way to set a startup form?

In the figure above, the relationship between the Courses and Materials tables does not include the enforce referential integrity option.

Cascade Delete Related Records automatically deletes all records in the ____ if the record with the matching key field in a "one" table is deleted.

Which type of template creates a traditional Access database?

Exporting is the opposite of importing.