Question 1

You work for a small pet shop and the store manager asks you to convert some of his paper records to an online system. A simple database exists and the owner wants to add to the existing database.
Assuming you can extend the database with every possible need for the store, what objects must be included in addition to the table(s) that make up the database?

Accepted Answer

The answer of You work for a small pet shop...

Question 2

Split view is a(n) _____________________ that displays the data entry form above the underlying datasheet.

Accepted Answer

The answer of Split view is a(n) _____________________ that displays...

Question 3

Match between columns
                        Premises: The column headings in the table.

Accepted Answer

The Answer of Query and Table and Field names and is...

Question 4

Describe the difference between a simple and a relational database.

Accepted Answer

The answer of Describe the difference between a simple and...

Question 5

You work for a small pet shop and the store manager asks you to convert some of his paper records to an online system. A simple database exists and the owner wants to add to the existing database.
Your supervisor wants a list of all the customers who purchased something recently from the store.  Can you do this with the current database design?

Accepted Answer

The answer of You work for a small pet shop...

Question 6

You work in the human resources department of a large company that uses Microsoft Access to track information before and after entering it into the company's administrative system.
Your supervisor has asked you to add a field description to a field in the table. How can you do this?

Accepted Answer

The answer of You work in the human resources department...

Question 7

You work in the human resources department of a large company that uses Microsoft Access to track information before and after entering it into the company's administrative system.
Your boss asks you for specific field values. What are field values?

Accepted Answer

The answer of You work in the human resources department...

Question 8

Describe how a database stores data.

Accepted Answer

The answer of Describe how a database stores data....

Question 9

Text boxes, check boxes and list arrows are all ___________________ controls.

Accepted Answer

The answer of Text boxes, check boxes and list arrows...

Question 10

Match between columns
                        Premises: A list of data organized in rows (records) and columns (fields).

Accepted Answer

The Answer of Table and Query and Form and Field is...

Question 11

The Report Wizard automatically creates a report based on settings that you specify and displays it in Display Preview.

Accepted Answer

The answer of The Report Wizard automatically creates a report...

Question 12

The simplest way to create a form is to click the Form button on the _______________ tab.

Accepted Answer

The answer of The simplest way to create a form...

Question 13

Match between columns
                        Premises: A summary of database information designed specifically for printing or distributing.

Accepted Answer

The Answer of Report and Table and Query and Field is...

Question 14

To close Access, click Close on the _________________ tab.

Accepted Answer

The answer of To close Access, click Close on the...

Question 15

Describe the operations you can perform when a table is in Design view.

Accepted Answer

The answer of Describe the operations you can perform when...

Question 16

Spotting statistical trends in a large database is usually easy.

Accepted Answer

Spotting statistical trends in a large database can be challenging, as it requires proper analysis and interpretation of the data. Large databases often contain complex and diverse information, making it harder to identify patterns and trends without the use of specialized tools and methods.

Question 17

Match between columns
                        Premises: A window that lets you view, enter, and edit data in a database one record at a time.

Accepted Answer

The Answer of Field names and Report and Table and is...

Question 18

Match between columns
                        Premises: A set of criteria (conditions) you specify to retrieve data from a database.

Accepted Answer

The Answer of Form and Field names and Report and is...

Question 19

In  _____________________ view, you can view records but cannot add, delete or edit records.

Accepted Answer

The answer of In  _____________________ view, you can view records but...

Question 20

You work for a small pet shop and the store manager asks you to convert some of his paper records to an online system. A simple database exists and the owner wants to add to the existing database.
Assuming that the existing database does not contain information related to sales in the table, how can you extend the database to track the purchases for each customer?

Accepted Answer

The answer of You work for a small pet shop...

Quiz 2: Access

Split view is a(n) _____________________ that displays the data entry form above the underlying datasheet.

Match each item with a statement below.

Describe the difference between a simple and a relational database.

You work in the human resources department of a large company that uses Microsoft Access to track information before and after entering it into the company's administrative system. Your supervisor has asked you to add a field description to a field in the table. How can you do this?

You work in the human resources department of a large company that uses Microsoft Access to track information before and after entering it into the company's administrative system. Your boss asks you for specific field values. What are field values?

Describe how a database stores data.

Text boxes, check boxes and list arrows are all ___________________ controls.

Match each item with a statement below.

The Report Wizard automatically creates a report based on settings that you specify and displays it in Display Preview.

The simplest way to create a form is to click the Form button on the _______________ tab.

Match each item with a statement below.

To close Access, click Close on the _________________ tab.

Describe the operations you can perform when a table is in Design view.

Spotting statistical trends in a large database is usually easy.

Match each item with a statement below.

Match each item with a statement below.

In _____________________ view, you can view records but cannot add, delete or edit records.