Question 1

In the Object Dependencies pane the ____ option button allows you to view the objects that affect the selected table.

Accepted Answer

A) Objects that I depend on 
B) Objects that depend on me 
C) Affected objects 
D) Things that cause dependencies 
A) Objects that I depend on 
B) Objects that depend on me 
C) Affected objects 
D) Things that cause dependencies

Question 2

An input guide is a predefined format used to enter and display data in a field.

Accepted Answer

A) True 
 B)False

Question 3

The figure above shows the Not logical operator with a(n)____________________ selection criterion.

Accepted Answer

The answer of   The figure above shows the...

Question 4

The ____________________ symbol is a concatenation operator that joins text expressions.

Accepted Answer

The answer of The ____________________ symbol is a concatenation operator...

Question 5

A pattern match uses ____________________ characters.

Accepted Answer

The answer of A pattern match uses ____________________ characters....

Question 6

____ display characters automatically appear in specific positions of a field value without users having to type them.

Accepted Answer

A) Absolute 
B) Relative 
C) Figurative 
D) Literal 
A) Absolute 
B) Relative 
C) Figurative 
D) Literal

Question 7

Property propagation is limited to field properties such as the ____ property.

Accepted Answer

A) Description 
B) Decimal Places 
C) Format 
D) All of the above 
A) Description 
B) Decimal Places 
C) Format 
D) All of the above

Question 8

In the Input Mask Wizard the practice area is called the ____ text box.

Accepted Answer

A) Sample 
B) Try It 
C) Practice 
D) Experiment 
A) Sample 
B) Try It 
C) Practice 
D) Experiment

Question 9

Match between columns
                        Premises: Uses the Like comparison operator

Accepted Answer

The Answer of field validation rule and Validation Text and is...

Question 10

Access uses unique icons to represent different types of queries.

Accepted Answer

A) True 
 B)False

Question 11

SQL stands for ____________________ and is a standard language used in querying updating and managing relational databases.

Accepted Answer

Structured

Question 12

The ____ represents any single digit.

Accepted Answer

A) # 
B) * 
C) @ 
D) (?) 
A) # 
B) * 
C) @ 
D) (?)

Question 13

When you resize a column to its best fit Access resizes the column so that the widest column heading and the visible field values fit the column width.

Accepted Answer

A) True 
 B)False

Question 14

How do you make a phone number appear as literal display characters such as 6174511970 appearing as (617)451-1970?

Accepted Answer

A) Create a form. 
B) Create an input mask. 
C) Run a query. 
D) Create a subdatasheet 
A) Create a form. 
B) Create an input mask. 
C) Run a query. 
D) Create a subdatasheet

Question 15

The best way to view the contents of Memo fields that contain a large number of characters is to use the ____ dialog box in a datasheet.

Accepted Answer

A) Insert 
B) Zoom 
C) View 
D) Column Width 
A) Insert 
B) Zoom 
C) View 
D) Column Width

Question 16

Which of the following statements is true?

Accepted Answer

A) Using a numeric range test with a Text field is not allowed. 
B) Enclosing numbers in quotation marks for a Test field range test will eliminate an error message. 
C) Enclosing numbers in quotation marks for a Test field range test will yield unpredictable results. 
D) All of the above 
A) Using a numeric range test with a Text field is not allowed. 
B) Enclosing numbers in quotation marks for a Test field range test will eliminate an error message. 
C) Enclosing numbers in quotation marks for a Test field range test will yield unpredictable results. 
D) All of the above

Question 17

Click the checkbox indicated in the above figure to display an overall totals column in the crosstab query.

Accepted Answer

A) True 
 B)False

Question 18

As the last step in creating a Top Values query you the ____ query.

Accepted Answer

A) evaluate 
B) retask 
C) automate 
D) run 
A) evaluate 
B) retask 
C) automate 
D) run

Question 19

The Object Dependencies ____ displays a collapsible list of the dependencies among the objects in an Access database.

Accepted Answer

A) window 
B) pane 
C) manager 
D) explorer 
A) window 
B) pane 
C) manager 
D) explorer

Question 20

If the value of ____ displays between the input mask characters ;; this indicates that literal display characters should be stored in the database.

Accepted Answer

A) 0 
B) 1 
C) 2 
D) 5 
A) 0 
B) 1 
C) 2 
D) 5

In the Object Dependencies pane the ____ option button allows you to view the objects that affect the selected table.

An input guide is a predefined format used to enter and display data in a field.

The figure above shows the Not logical operator with a(n)____________________ selection criterion.

The ____________________ symbol is a concatenation operator that joins text expressions.

A pattern match uses ____________________ characters.

____ display characters automatically appear in specific positions of a field value without users having to type them.

Property propagation is limited to field properties such as the ____ property.

In the Input Mask Wizard the practice area is called the ____ text box.

Access uses unique icons to represent different types of queries.

SQL stands for ____________________ and is a standard language used in querying updating and managing relational databases.

The ____ represents any single digit.

When you resize a column to its best fit Access resizes the column so that the widest column heading and the visible field values fit the column width.

How do you make a phone number appear as literal display characters such as 6174511970 appearing as (617)451-1970?

The best way to view the contents of Memo fields that contain a large number of characters is to use the ____ dialog box in a datasheet.

Which of the following statements is true?

Click the checkbox indicated in the above figure to display an overall totals column in the crosstab query.

As the last step in creating a Top Values query you the ____ query.

The Object Dependencies ____ displays a collapsible list of the dependencies among the objects in an Access database.

If the value of ____ displays between the input mask characters ;; this indicates that literal display characters should be stored in the database.

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing Integrating and Analyzing Data

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Excel: Developing an Excel Application

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters

Exam 1: Access: Creating Advanced Queries and Enhancing Table Design

In the Object Dependencies pane the ____ option button allows you to view the objects that affect the selected table.

An input guide is a predefined format used to enter and display data in a field.

The figure above shows the Not logical operator with a(n)____________________ selection criterion.

The ____________________ symbol is a concatenation operator that joins text expressions.

A pattern match uses ____________________ characters.

____ display characters automatically appear in specific positions of a field value without users having to type them.

Property propagation is limited to field properties such as the ____ property.

In the Input Mask Wizard the practice area is called the ____ text box.

Access uses unique icons to represent different types of queries.

SQL stands for ____________________ and is a standard language used in querying updating and managing relational databases.

The ____ represents any single digit.

When you resize a column to its best fit Access resizes the column so that the widest column heading and the visible field values fit the column width.

How do you make a phone number appear as literal display characters such as 6174511970 appearing as (617)451-1970?

The best way to view the contents of Memo fields that contain a large number of characters is to use the ____ dialog box in a datasheet.

Which of the following statements is true?

Click the checkbox indicated in the above figure to display an overall totals column in the crosstab query.

As the last step in creating a Top Values query you the ____ query.

The Object Dependencies ____ displays a collapsible list of the dependencies among the objects in an Access database.

If the value of ____ displays between the input mask characters ;; this indicates that literal display characters should be stored in the database.

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing Integrating and Analyzing Data

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Excel: Developing an Excel Application

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters