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

The Answer of creates a field to choose a value is...

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

The Answer of guides the user through the query design is...

Exam 31: Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Linking tables using common fields is a suggested guideline for successfully adding fields to a database.

(True/False)

4.8/5

(100)

Question 61

Match the following data types to their definitions:

Short Text

creates a field to choose a value from another table

Long Text

limits field values to on and off,for example

Yes/No

contains something created by another application

Correct Answer:

Verified

Short Text

Long Text

Yes/No

Lookup Wizard

OLE Object

(Matching)

4.7/5

(80)

Question 62

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

(Short Answer)

4.9/5

(84)

Question 63

Describe a wildcard in Access.Mention at least two wildcards that are available in Access.

(Essay)

5.0/5

(82)

Question 64

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

(Short Answer)

4.8/5

(65)

Question 65

Which of the following is TRUE about the NOT operator?

(Multiple Choice)

4.7/5

(65)

Question 66

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

(Essay)

4.8/5

(96)

Question 67

The ________ data type can be used for fields that contain monetary values.

(Short Answer)

4.8/5

(92)

Question 68

Which of the following statements is TRUE about how Access and Excel share data?

(Multiple Choice)

4.7/5

(99)

Question 69

Match the following terms to their meanings:

brackets ([ ])

guides the user through the query design process

related tables

matches for any number of characters

Simple Query Wizard

joined through a common field

Correct Answer:

Verified

brackets ([ ])

related tables

Simple Query Wizard

asterisk (*)

question mark (?)

(Matching)

4.9/5

(81)

Question 70

The ________ data type should be applied to fields that contain a combination of characters and will be 255 characters or less.

(Short Answer)

4.8/5

(82)

Question 71

What is one important limitation of the Simple Query Wizard?

(Essay)

4.8/5

(70)

Question 72

The Is Null expression is used to find blank fields.

(True/False)

4.8/5

(81)

Question 73

Match the following terms to their meanings:

number data type

can hold up to 255 characters

AutoNumber

creates a label more readable than a field

caption property

can be set to Integer

Correct Answer:

Verified

number data type

AutoNumber

caption property

field property

short text data type

(Matching)

4.9/5

(90)

Question 74

All Excel spreadsheets are ready to import into an Access database.

(True/False)

4.9/5

(72)

Question 75

Which of the following is FALSE about CamelCase notation?

(Multiple Choice)

4.9/5

(81)

Question 76

Which of the following query criteria would be used to produce results for Date/Time fields containing a date of December 12,2014?

(Multiple Choice)

4.8/5

(75)

Question 77

Creation of the order of fields within a table and specific field names given are significant because it's very difficult to change these after the database has been created.

(True/False)

4.8/5

(88)

Question 78

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

(True/False)

4.9/5

(84)

Question 79

Which of the following is NOT a way to create a table in Access?

(Multiple Choice)

4.7/5

(94)

Question 80

Exam 31: Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Linking tables using common fields is a suggested guideline for successfully adding fields to a database.

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

Describe a wildcard in Access.Mention at least two wildcards that are available in Access.

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

Which of the following is TRUE about the NOT operator?

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

The ________ data type can be used for fields that contain monetary values.

Which of the following statements is TRUE about how Access and Excel share data?

The ________ data type should be applied to fields that contain a combination of characters and will be 255 characters or less.

What is one important limitation of the Simple Query Wizard?

The Is Null expression is used to find blank fields.

All Excel spreadsheets are ready to import into an Access database.

Which of the following is FALSE about CamelCase notation?

Which of the following query criteria would be used to produce results for Date/Time fields containing a date of December 12,2014?

Creation of the order of fields within a table and specific field names given are significant because it's very difficult to change these after the database has been created.

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

Which of the following is NOT a way to create a table in Access?

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

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

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

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters