Exam 7: Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Explore all topics

In the expression Total Tax:[Invoice!QtySold]*[Tax!Rate] the exclamation mark is used to indicate that the columns are located on different ________.

(Multiple Choice)

4.8/5

(74)

Question 41

________ view allows you to sort records from left to right in an order that makes sense,and allows you to combine ascending and descending sorts.

(Short Answer)

4.9/5

(79)

Question 42

To format query fields in the query grid,you use the ________ properties sheet.

(Multiple Choice)

4.7/5

(69)

Question 43

Combining search criteria and aggregate functions in a single query can make troubleshooting more difficult due to the complexity of the query.

(True/False)

4.7/5

(67)

Question 44

The ________ logical operator is true if ONLY one of the criteria is met.

(Short Answer)

4.7/5

(83)

Question 45

A type of operator that compares the values in a table or query to a specific criteria value is called a(n)________ operator.

(Short Answer)

4.8/5

(80)

Question 46

When you sort by multiple fields,the first field you select to sort on is called the ________ sort field.

(Multiple Choice)

4.9/5

(67)

Question 47

When changing the field name assigned in an aggregate query,the field name in the query design grid must also be changed.

(True/False)

4.7/5

(74)

Question 48

A condition that is temporarily applied to a table or query to hide all unmatching records is called a filter.

(True/False)

4.8/5

(82)

Question 49

When looking for specific values in a record,you should use the ________ command to keep from scrolling.

(Multiple Choice)

4.8/5

(78)

Question 50

A(n)________ function performs operations such as figuring averages and totals on records displayed in tables or queries.

(Short Answer)

4.9/5

(69)

Question 51

When using multiple criteria in a query,you MUST also use logical operators.

(True/False)

4.8/5

(89)

Question 52

To perform calculations on selected fields and records in a query,use an aggregate function.

(True/False)

4.8/5

(87)

Question 53

The ________ occurs when Access joins two tables that do not have a common field.

(Multiple Choice)

4.8/5

(84)

Question 54

Using the ________ command,you can easily trade one value to another.

(Short Answer)

4.8/5

(75)

Question 55

In the ________ window,relationships between tables are represented by lines that connect the tables.

(Multiple Choice)

4.8/5

(77)

Question 56

A condition applied temporarily to a table or query is called a(n)________

(Multiple Choice)

4.7/5

(72)

Question 57

Access ignores unnecessary tables selected as part of a query,so it is ok to have unused tables in the query.

(True/False)

4.9/5

(71)

Question 58

The ________ effect occurs when you query two or more tables that do not have common fields.

(Short Answer)

4.9/5

(78)

Question 59

You can add tables to the query by dragging them from the ________.

(Short Answer)

4.9/5

(76)

Question 60

Showing 41 - 60 of 91

Exam 7: Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

In the expression Total Tax:[Invoice!QtySold]*[Tax!Rate] the exclamation mark is used to indicate that the columns are located on different ________.

________ view allows you to sort records from left to right in an order that makes sense,and allows you to combine ascending and descending sorts.

To format query fields in the query grid,you use the ________ properties sheet.

Combining search criteria and aggregate functions in a single query can make troubleshooting more difficult due to the complexity of the query.

The ________ logical operator is true if ONLY one of the criteria is met.

A type of operator that compares the values in a table or query to a specific criteria value is called a(n)________ operator.

When you sort by multiple fields,the first field you select to sort on is called the ________ sort field.

When changing the field name assigned in an aggregate query,the field name in the query design grid must also be changed.

A condition that is temporarily applied to a table or query to hide all unmatching records is called a filter.

When looking for specific values in a record,you should use the ________ command to keep from scrolling.

A(n)________ function performs operations such as figuring averages and totals on records displayed in tables or queries.

When using multiple criteria in a query,you MUST also use logical operators.

To perform calculations on selected fields and records in a query,use an aggregate function.

The ________ occurs when Access joins two tables that do not have a common field.

Using the ________ command,you can easily trade one value to another.

In the ________ window,relationships between tables are represented by lines that connect the tables.

A condition applied temporarily to a table or query is called a(n)________

Access ignores unnecessary tables selected as part of a query,so it is ok to have unused tables in the query.

The ________ effect occurs when you query two or more tables that do not have common fields.

You can add tables to the query by dragging them from the ________.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters