Recommended practice for designing multitable queries

Assignment Help Operation Management

Reference no: EM132254766

1. Which object, by definition, allows you to ask questions about the data stored in a database, such as which customers live in New Orleans and Seattle?

Criteria

Form

Query

Table

2. When constructing criteria for a query, you should use

no delimiters for number data types.

quotes to enclose date/time data types.

single quotes for number data types.

the pound sign to enclose text data.

3. Which of the following is NOT true of a single-table query?

It can be created using the simple query wizard.

Queries can be created using the query design tool.

You can overwrite table data using the datasheet view of a query.

The top portion of the query design view displays the fields and criteria for two tables.

4. Which of the following is not a recommended practice for designing multitable queries?

Include only related tables in your query.

Remove join lines in query design to speed up query processing.

Related tables should be established before you design a multitable query.

Print a relationship report to guide you in selecting related tables.

5. A calculated field may contain the following elements except

an arithmetic operator.

a hyperlink.

a built in function with built in calculations.

a constant or value that doesn’t change.

6. Which of the following statements is true about queries?

Forms and queries are actually the same thing.

Queries can only be based on one table.

Queries can be based on one or more related tables.

The instructions to create a query are not stored in the database.

7. All the following are report views except

report.

design.

date.

layout.

8. You can add records through the

datasheet view of a table.

design view of a table.

report view.

All of the above

9. A yes/no data type is

a select query used to warn users of database changes.

always initiated by a user.

also a true or false statement.

used to add and edit database fields.

10. Which of the following is NOT an action query?

Append

Delete

Make table

Summarize

Reference no: EM132254766

Questions Cloud

Prevents the government from making laws abridging : The First Amendment to the U.S. Constitution prevents the government from making laws abridging our freedom of speech.

Explain the history and goals of the grievance process : Explain the history and goals of the grievance process, paying particular attention to labor arbitration.

How implementing situational leadership helps : Explain how implementing situational leadership helps with making decisions, and building commitments?

Motivation theories is not based on process perspectives : Which of the following motivation theories is NOT based on process perspectives? Perspectives focus on the source that triggers motivation: the “need.”

Recommended practice for designing multitable queries : Which of the following is NOT true of a single-table query? Which of the following is not a recommended practice for designing multitable queries?

Actively support the notion of feedforward communication : Which of the three friends is most likely to actively support the notion of feedforward communication?

Calculate the monthly payment for each : Calculate the monthly payment for each. Property taxes and insurance will add $1,000 per month to which ever mortgage they choose. What should Kathy and Stan do

Staffing level with the integer linear programming model : How to find the minimum staffing level with the Integer Linear Programming model?

Analyze the complexities of hris administration : Explain the differences between direct and indirect benefits and costs. Analyze the complexities of HRIS administration.

User Account

All Pages