Question 1

The maximum size of the ________ data type is ________ characters.

Accepted Answer

A)  Short Text; 25 
B)  Long Text; 1,024 
C)  Long Text; 255 
D)  Short Text; 255 
A)  Short Text; 25 
B)  Long Text; 1,024 
C)  Long Text; 255 
D)  Short Text; 255

Question 2

If a worksheet in an Excel workbook was named,Access uses the worksheet name as the database name.

Accepted Answer

A) True 
 B)False

Question 3

In field names,object names,and filenames,uppercase letters are used to distinguish the first letter of a new word in ________ notation.

Accepted Answer

The answer of In field names,object names,and filenames,uppercase letters are...

Question 4

Which of the following statements best describes a one-to-many relationship between two tables?

Accepted Answer

A)  A primary key in the first table matches several foreign keys in the second table. 
B)  A foreign key in the first table matches several primary keys in the second table. 
C)  A primary key in the first table matches exactly one foreign key in the second table. 
D)  Primary and foreign keys have multiple cross matches between a first and second table. 
A)  A primary key in the first table matches several foreign keys in the second table. 
B)  A foreign key in the first table matches several primary keys in the second table. 
C)  A primary key in the first table matches exactly one foreign key in the second table. 
D)  Primary and foreign keys have multiple cross matches between a first and second table.

Question 5

The Is Null expression is used to find blank fields.

Accepted Answer

A) True 
 B)False

Question 6

If you choose Append a copy of the records to the table as an option for incoming data,the data will be added to an existing table.

Accepted Answer

A) True 
 B)False

Question 7

Freezing fields disallows any user from changing the field name or any data within the field.

Accepted Answer

A) True 
 B)False

Question 8

Where do you change the order of query fields to change the order of query results?

Accepted Answer

A)  In the design grid of a query's Datasheet view 
B)  In the Criteria row of the Query Design view 
C)  In the Show row of the Query Design view 
D)  In the Relationship window of the Design view 
A)  In the design grid of a query's Datasheet view 
B)  In the Criteria row of the Query Design view 
C)  In the Show row of the Query Design view 
D)  In the Relationship window of the Design view

Question 9

Match between columns
                        Premises: Long Text
Lookup Wizard
OLE Object
Short Text
Yes/No

Accepted Answer

The Answer of can hold up to 255 characters and is...

Question 10

A query is a question asked about the data in a database.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is TRUE regarding the running of queries and the size of a database?

Accepted Answer

A)  Queries run slower in smaller databases of numeric data. 
B)  Queries run at the same speed in large or small databases. 
C)  The size of a database does not affect the speed at which queries run. 
D)  The queries in larger databases may take longer to run than queries in smaller databases. 
A)  Queries run slower in smaller databases of numeric data. 
B)  Queries run at the same speed in large or small databases. 
C)  The size of a database does not affect the speed at which queries run. 
D)  The queries in larger databases may take longer to run than queries in smaller databases.

Question 12

Access requires a primary key for every table.

Accepted Answer

A) True 
 B)False

Question 13

Jose is working on a database that stores stock information.He needs to design a field that will allow a user to connect to a graph created in Excel.Jose should apply a(n)________ data type.

Accepted Answer

A)  OLE Object 
B)  Number 
C)  Attachment 
D)  Calculated 
A)  OLE Object 
B)  Number 
C)  Attachment 
D)  Calculated

Question 14

A ________ query is a type of query that displays on records that match criteria entered in Query Design view.

Accepted Answer

A)  select 
B)  simple 
C)  one-to-one 
D)  multitable 
A)  select 
B)  simple 
C)  one-to-one 
D)  multitable

Question 15

Use the ________ tab to begin the process of importing an Excel worksheet.

Accepted Answer

The answer of Use the ________ tab to begin the...

Question 16

Which of the following statements is TRUE about data types and delimiters?

Accepted Answer

A)  Numeric fields require quotation marks as delimiters. 
B)  Date fields are enclosed in quotation marks. 
C)  Different data types require different delimiters. 
D)  All data types use the same delimiters. 
A)  Numeric fields require quotation marks as delimiters. 
B)  Date fields are enclosed in quotation marks. 
C)  Different data types require different delimiters. 
D)  All data types use the same delimiters.

Question 17

Calculated fields are frequently created with ________ data.

Accepted Answer

The answer of Calculated fields are frequently created with ________...

Question 18

A(n)________ query is a type of query that displays only the records that match criteria that you enter in Query Design view.

Accepted Answer

The answer of A(n)________ query is a type of query...

Question 19

Which of the following is FALSE about CamelCase notation?

Accepted Answer

A)  Use uppercase letters to distinguish the first letter of each new word. 
B)  Field name can be up to 64 characters. 
C)  Field names should include spaces when the name is more than one word. 
D)  Field names can include letters and numbers. 
A)  Use uppercase letters to distinguish the first letter of each new word. 
B)  Field name can be up to 64 characters. 
C)  Field names should include spaces when the name is more than one word. 
D)  Field names can include letters and numbers.

Question 20

________ queries contain two or more tables and allow users to take advantage of relationships that have been set between these tables.

Accepted Answer

The answer of ________ queries contain two or more tables...

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

The maximum size of the ________ data type is ________ characters.

If a worksheet in an Excel workbook was named,Access uses the worksheet name as the database name.

In field names,object names,and filenames,uppercase letters are used to distinguish the first letter of a new word in ________ notation.

Which of the following statements best describes a one-to-many relationship between two tables?

The Is Null expression is used to find blank fields.

If you choose Append a copy of the records to the table as an option for incoming data,the data will be added to an existing table.

Freezing fields disallows any user from changing the field name or any data within the field.

Where do you change the order of query fields to change the order of query results?

A query is a question asked about the data in a database.

Which of the following is TRUE regarding the running of queries and the size of a database?

Access requires a primary key for every table.

Jose is working on a database that stores stock information.He needs to design a field that will allow a user to connect to a graph created in Excel.Jose should apply a(n)________ data type.

A ________ query is a type of query that displays on records that match criteria entered in Query Design view.

Use the ________ tab to begin the process of importing an Excel worksheet.

Which of the following statements is TRUE about data types and delimiters?

Calculated fields are frequently created with ________ data.

A(n)________ query is a type of query that displays only the records that match criteria that you enter in Query Design view.

Which of the following is FALSE about CamelCase notation?

________ queries contain two or more tables and allow users to take advantage of relationships that have been set between these tables.

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

The maximum size of the data type is characters.