Question 1

When you sort data in a query, the records in the underlying table are actually rearranged.

Accepted Answer

A) True 
 B)False  False

Question 2

Explain the difference between an inner join and an outer join.

Accepted Answer

An inner join is a join that finds records from both tables that have identical values in matching fields. An outer join is a join that finds all the records in one table as well as the common records; that is, the records that share the same value in the join field. In a left outer join, all rows from the table on the left are included. In a right outer join, all rows from the table on the right are included.

Question 3

In the accompanying figure, Business Analyst Number is the ____ key.

Accepted Answer

A) major 
B) minor 
C) primary sort 
D) secondary sort 
A) major 
B) minor 
C) primary sort 
D) secondary sort A,C

Question 4

When you sort data, duplicates normally are included.

Accepted Answer

A) True 
 B)False

Question 5

To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet.

Accepted Answer

A) Statistics 
B) Add Total 
C) Insert Total 
D) Totals 
A) Statistics 
B) Add Total 
C) Insert Total 
D) Totals

Question 6

One reason to include a foreign key for a table is to eliminate duplicate records.

Accepted Answer

A) True 
 B)False

Question 7

You can use the asterisk (*)wildcard in a filter but not the question mark (?)wildcard.

Accepted Answer

A) True 
 B)False

Question 8

As an alternate to using the Find button shown in the accompanying figure, you can press ____ to search for a specific record.

Accepted Answer

A) CTRL+S 
B) CTRL+F 
C) CTRL+R 
D) CTRL+L 
A) CTRL+S 
B) CTRL+F 
C) CTRL+R 
D) CTRL+L

Question 9

The ____________________ is an Access tool that helps you create complex expressions.

Accepted Answer

The answer of The ____________________ is an Access tool that...

Question 10

To specify that a field is to be required, change the value for the _____ property from No to Yes.

Accepted Answer

A) Required 
B) No Blanks 
C) Necessary 
D) Completed 
A) Required 
B) No Blanks 
C) Necessary 
D) Completed

Question 11

To restrict the objects that appear on the Navigation Pane use the Restrict Bar.

Accepted Answer

A) True 
 B)False

Question 12

To change the design of a query that is not currently open, right-click the query in the Navigation Pane and then click  ____________________ on the shortcut menu.

Accepted Answer

The answer of To change the design of a query...

Question 13

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

Accepted Answer

A) True 
 B)False

Question 14

To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.

Accepted Answer

A) list 
B) value 
C) combo 
D) lookup 
A) list 
B) value 
C) combo 
D) lookup

Question 15

To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.

Accepted Answer

A) Franc?s 
B) Franc*s 
C) Franc#s 
D) Franc%s 
A) Franc?s 
B) Franc*s 
C) Franc#s 
D) Franc%s

Question 16

In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC76.

Accepted Answer

A) Sort 
B) Show 
C) or 
D) Criteria 
A) Sort 
B) Show 
C) or 
D) Criteria

Question 17

You can search for a record in Form view but not in Datasheet view.

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: Allows you to make the same change to all records.

Accepted Answer

The Answer of < and validation rules and append query is...

Question 19

To order the records in the answer to a query in a particular way, you ____ the records.

Accepted Answer

A) index 
B) sort 
C) arrange 
D) list 
A) index 
B) sort 
C) arrange 
D) list

Question 20

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

Accepted Answer

A) True 
 B)False

When you sort data in a query, the records in the underlying table are actually rearranged.

Explain the difference between an inner join and an outer join.

In the accompanying figure, Business Analyst Number is the ____ key.

When you sort data, duplicates normally are included.

To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet.

One reason to include a foreign key for a table is to eliminate duplicate records.

You can use the asterisk (*)wildcard in a filter but not the question mark (?)wildcard.

As an alternate to using the Find button shown in the accompanying figure, you can press ____ to search for a specific record.

The ____________________ is an Access tool that helps you create complex expressions.

To specify that a field is to be required, change the value for the _____ property from No to Yes.

To restrict the objects that appear on the Navigation Pane use the Restrict Bar.

To change the design of a query that is not currently open, right-click the query in the Navigation Pane and then click ____________________ on the shortcut menu.

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.

To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.

In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC76.

You can search for a record in Form view but not in Datasheet view.

To order the records in the answer to a query in a particular way, you ____ the records.

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

Microsoft Windows Internet Explorer 8 : Introduction to Internet Explorer

Office 2010 and Windows 7 : essential concepts and skills

Access : Databases and Database Objects : an Introduction

Discovering Computers: Introduction to Computers

Discovering Computers: the Internet and World Wide Web

Discovering Computers: Application Software

Discovering Computers: Operating Systems and Utility Programs

Discovering Computers: Computer Security and Safety, Ethics, and Privacy

Excel : Creating a Worksheet and an Embedded Chart

Excel : Formulas, Functions, and Formatting

Excel : What-If Analysis, Charting and Working With Large Worksheets

Powerpoint : Creating and Editing a Presentation With Clip Art

Powerpoint : Enhancing a Presentation With Pictures, Shapes and Wordart

Powerpoint : Reusing a Presentation With Adding Media

Word: Creating, Formatting, and Editing a Word Document With Pictures

Word: Creating a Research Paper With Citations and References

Word: Creating a Business Letter With a Letterhead and Table

Filters

Exam 4: Access: Querying a Database

When you sort data in a query, the records in the underlying table are actually rearranged.

Explain the difference between an inner join and an outer join.

In the accompanying figure, Business Analyst Number is the ____ key.

When you sort data, duplicates normally are included.

To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet.

One reason to include a foreign key for a table is to eliminate duplicate records.

You can use the asterisk (*)wildcard in a filter but not the question mark (?)wildcard.

As an alternate to using the Find button shown in the accompanying figure, you can press ____ to search for a specific record.

The ____________________ is an Access tool that helps you create complex expressions.

To specify that a field is to be required, change the value for the _____ property from No to Yes.

To restrict the objects that appear on the Navigation Pane use the Restrict Bar.

To change the design of a query that is not currently open, right-click the query in the Navigation Pane and then click ____________________ on the shortcut menu.

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.

To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.

In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC76.

You can search for a record in Form view but not in Datasheet view.

To order the records in the answer to a query in a particular way, you ____ the records.

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

Microsoft Windows Internet Explorer 8 : Introduction to Internet Explorer

Office 2010 and Windows 7 : essential concepts and skills

Access : Databases and Database Objects : an Introduction

Discovering Computers: Introduction to Computers

Discovering Computers: the Internet and World Wide Web

Discovering Computers: Application Software

Discovering Computers: Operating Systems and Utility Programs

Discovering Computers: Computer Security and Safety, Ethics, and Privacy

Excel : Creating a Worksheet and an Embedded Chart

Excel : Formulas, Functions, and Formatting

Excel : What-If Analysis, Charting and Working With Large Worksheets

Powerpoint : Creating and Editing a Presentation With Clip Art

Powerpoint : Enhancing a Presentation With Pictures, Shapes and Wordart

Powerpoint : Reusing a Presentation With Adding Media

Word: Creating, Formatting, and Editing a Word Document With Pictures

Word: Creating a Research Paper With Citations and References

Word: Creating a Business Letter With a Letterhead and Table

Filters