Question 1

Spaces should be included in field names.

Accepted Answer

A) True 
 B)False

Question 2

If data from an Excel worksheet is imported into Access and no column headings exist,the data will import using:

Accepted Answer

A)  Import1, Import2, Import3, etc. 
B)  Access1, Access2, Access3, etc. 
C)  Field1, Field2, Field3, etc. 
D)  FieldA, FieldB, FieldC, etc. 
A)  Import1, Import2, Import3, etc. 
B)  Access1, Access2, Access3, etc. 
C)  Field1, Field2, Field3, etc. 
D)  FieldA, FieldB, FieldC, etc.

Question 3

In most cases,it is advisable to enforce referential integrity in databases with related tables.

Accepted Answer

A) True 
 B)False

Question 4

What are the three ways to run a query?

Accepted Answer

You can run a query by clickin

Question 5

Match between columns
                        Premises: brackets ([ ])
Simple Query Wizard
asterisk (*)
question mark (?)
related tables

Accepted Answer

The Answer of matches any a single character in the is...

Question 6

When you add two or more tables to a query,you must manually create new join lines.

Accepted Answer

A) True 
 B)False

Question 7

What is one important limitation of the Simple Query Wizard?

Accepted Answer

The Simple Query Wizard guides

Question 8

The data type of a field determines the type of operations that can be performed on that field.

Accepted Answer

A) True 
 B)False

Question 9

A(n)________ relationship requires a table called a junction table.

Accepted Answer

The answer of A(n)________ relationship requires a table called a...

Question 10

Data redundancy may result in errors.

Accepted Answer

A) True 
 B)False

Question 11

A(n)________ produces a value from an expression or function that uses one or more fields in a database.

Accepted Answer

The answer of A(n)________ produces a value from an expression...

Question 12

You use the ________ view to create queries.

Accepted Answer

The answer of You use the ________ view to create...

Question 13

Multitable queries take advantage of table relationships in a database.

Accepted Answer

A) True 
 B)False

Question 14

Comparison operators include *,?,and [ ].

Accepted Answer

A) True 
 B)False

Question 15

Good database design begins with the forms of the database.

Accepted Answer

A) True 
 B)False

Question 16

Why might you want to import data rather than creating a new database from scratch?

Accepted Answer

If you have existing data in an Excel sp

Question 17

The ________ Wizard guides you through the query design process in Access.

Accepted Answer

The answer of The ________ Wizard guides you through the...

Question 18

The ________ data type is used for fields that will be used in mathematical calculations except those involving money.

Accepted Answer

The answer of The ________ data type is used for...

Question 19

Which of the following is NOT a guideline for adding fields to a database table?

Accepted Answer

A)  Consider the future use of the database. 
B)  Store data in their smallest parts. 
C)  Design to accommodate date arithmetic. 
D)  Link tables using foreign keys 
A)  Consider the future use of the database. 
B)  Store data in their smallest parts. 
C)  Design to accommodate date arithmetic. 
D)  Link tables using foreign keys

Question 20

Match between columns
                        Premises: NOT logical operator
null
OR logical operator
wildcard
AND logical operator

Accepted Answer

The Answer of query results will display records that match is...

Spaces should be included in field names.

If data from an Excel worksheet is imported into Access and no column headings exist,the data will import using:

In most cases,it is advisable to enforce referential integrity in databases with related tables.

What are the three ways to run a query?

When you add two or more tables to a query,you must manually create new join lines.

What is one important limitation of the Simple Query Wizard?

The data type of a field determines the type of operations that can be performed on that field.

A(n)________ relationship requires a table called a junction table.

Data redundancy may result in errors.

A(n)________ produces a value from an expression or function that uses one or more fields in a database.

You use the ________ view to create queries.

Multitable queries take advantage of table relationships in a database.

Comparison operators include *,?,and [ ].

Good database design begins with the forms of the database.

Why might you want to import data rather than creating a new database from scratch?

The ________ Wizard guides you through the query design process in Access.

The ________ data type is used for fields that will be used in mathematical calculations except those involving money.

Which of the following is NOT a guideline for adding fields to a database table?

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters

Exam 14: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Spaces should be included in field names.

If data from an Excel worksheet is imported into Access and no column headings exist,the data will import using:

In most cases,it is advisable to enforce referential integrity in databases with related tables.

What are the three ways to run a query?

When you add two or more tables to a query,you must manually create new join lines.

What is one important limitation of the Simple Query Wizard?

The data type of a field determines the type of operations that can be performed on that field.

A(n)________ relationship requires a table called a junction table.

Data redundancy may result in errors.

A(n)________ produces a value from an expression or function that uses one or more fields in a database.

You use the ________ view to create queries.

Multitable queries take advantage of table relationships in a database.

Comparison operators include *,?,and [ ].

Good database design begins with the forms of the database.

Why might you want to import data rather than creating a new database from scratch?

The ________ Wizard guides you through the query design process in Access.

The ________ data type is used for fields that will be used in mathematical calculations except those involving money.

Which of the following is NOT a guideline for adding fields to a database table?

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters