Exam 3: Maintaining and Querying a Database

After creating the query,Jorge must set criteria to have the query return only those plants that need full sun. Entries for the Amount of Sun field include: partial sun,little sun,and full sun.How should Jorge enter the criteria for the exact match of full sun?

(Multiple Choice)

4.9/5

(50)

Question 41

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

(Multiple Choice)

4.8/5

(33)

Question 42

Arithmetic operations are performed on selected records in a database using Statistical functions.____________________

(True/False)

4.7/5

(36)

Question 43

To create a datasheet that lists all herbs that are Perennials,Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field?

(Multiple Choice)

4.8/5

(36)

Question 44

The process of rearranging records in a specified order or sequence is referred to as sorting.____________________

(True/False)

4.9/5

(32)

Question 45

The + symbol is an example of a(n)____ operator.

(Multiple Choice)

4.9/5

(38)

Question 46

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

(Multiple Choice)

4.8/5

(35)

Question 47

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

(Short Answer)

4.8/5

(39)

Question 48

The primary key of a table must be unique for each record; however,the ____ sort field does not have to be unique.

(Multiple Choice)

4.8/5

(28)

Question 49

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.____________________

(True/False)

4.9/5

(44)

Question 50

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

(Multiple Choice)

4.8/5

(29)

Question 51

When a question is asked of a database using a select query,the answer is returned as a data sheet.____________________

(True/False)

4.8/5

(33)

Question 52

To use an existing query as the basis for a new query,it is necessary to ____ the query before designing the new query.

(Multiple Choice)

4.8/5

(37)

Question 53

Results of a query are narrowed by using the Or logical operator.____________________

(True/False)

4.8/5

(34)

Question 54

The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

(Multiple Choice)

4.8/5

(32)

Question 55

A query based on more than one table is a(n)____query.

(Multiple Choice)

4.8/5

(26)

Question 56

A calculated field is formatted using the ____ for the field.

(Multiple Choice)

5.0/5

(32)

Question 57

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.____________________

(True/False)

4.8/5

(30)

Question 58

The contents of query datasheet are permanent.____________________

(True/False)

4.8/5

(35)

Question 59

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

(Multiple Choice)

5.0/5

(30)

Question 60

Showing 41 - 60 of 75

After creating the query,Jorge must set criteria to have the query return only those plants that need full sun. Entries for the Amount of Sun field include: partial sun,little sun,and full sun.How should Jorge enter the criteria for the exact match of full sun?

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

Arithmetic operations are performed on selected records in a database using Statistical functions.____________________

To create a datasheet that lists all herbs that are Perennials,Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field?

The process of rearranging records in a specified order or sequence is referred to as sorting.____________________

The + symbol is an example of a(n)____ operator.

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

The primary key of a table must be unique for each record; however,the ____ sort field does not have to be unique.

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.____________________

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

When a question is asked of a database using a select query,the answer is returned as a data sheet.____________________

To use an existing query as the basis for a new query,it is necessary to ____ the query before designing the new query.

Results of a query are narrowed by using the Or logical operator.____________________

The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

A query based on more than one table is a(n)____query.

A calculated field is formatted using the ____ for the field.

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.____________________

The contents of query datasheet are permanent.____________________

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters