Match between columns Premises: data type foreign key data redundancy constant calculated field

The Answer of date of birth is a common field is...

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

Match the following terms to their meanings:

data type

date of birth is a common field example

foreign key

determine the type of entry that can be made into a field

data redundancy

produces a value from one or more existing,often numeric,fields

Correct Answer:

Verified

data type

foreign key

data redundancy

constant

calculated field

(Matching)

4.9/5

(88)

Question 41

Quotation marks before and after text in a text field and pound signs before and after a date in a date field are example of ________.

(Short Answer)

4.9/5

(70)

Question 42

The maximum size of the data type is characters.

(Multiple Choice)

4.8/5

(77)

Question 43

The ________ of the query design grid is used to set the rules that determine which records of a table will be selected.

(Short Answer)

4.9/5

(71)

Question 44

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.

(True/False)

5.0/5

(90)

Question 45

Why should you strive to avoid data redundancy in a database?

(Essay)

4.7/5

(92)

Question 46

The Run command appears as a red exclamation point in Design view.

(True/False)

4.7/5

(83)

Question 47

Using a field that contains a year of birth and a field that contains the current year to determine the age of a person listed in a database is called ________.

(Short Answer)

4.8/5

(76)

Question 48

"The primary key of a table plays a significant role when setting relationships." Describe why this statement is true.

(Essay)

4.7/5

(74)

Question 49

Which of the following is FALSE about multitable queries?

(Multiple Choice)

4.9/5

(86)

Question 50

Which of the following is NOT a type of relationship available in Access 2013?

(Multiple Choice)

4.9/5

(97)

Question 51

When referential integrity is enforced,you cannot enter a(n)________ key in a related table unless the primary key exists in the primary table.

(Short Answer)

5.0/5

(74)

Question 52

Which of the following statements is TRUE regarding multitable queries?

(Multiple Choice)

4.9/5

(85)

Question 53

You can set a(n)________ to create a label more readable than a field.

(Short Answer)

4.8/5

(95)

Question 54

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

(Multiple Choice)

4.9/5

(71)

Question 55

The value in a field with the ________ data type will be automatically increased each time a new record is entered.

(Multiple Choice)

4.8/5

(88)

Question 56

If a user selects the ________ Related Fields option while creating a relationship,Access will automatically modify all foreign key values in a related table to match any modifications made to the primary key.

(Short Answer)

5.0/5

(79)

Question 57

Referential integrity should be enforced in a database with related tables because it:

(Multiple Choice)

4.8/5

(74)

Question 58

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

(Multiple Choice)

4.8/5

(79)

Question 59

Two or more tables that contain duplicate data are an example of:

(Multiple Choice)

4.9/5

(80)

Question 60

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

Quotation marks before and after text in a text field and pound signs before and after a date in a date field are example of ________.

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

The ________ of the query design grid is used to set the rules that determine which records of a table will be selected.

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.

Why should you strive to avoid data redundancy in a database?

The Run command appears as a red exclamation point in Design view.

Using a field that contains a year of birth and a field that contains the current year to determine the age of a person listed in a database is called ________.

"The primary key of a table plays a significant role when setting relationships." Describe why this statement is true.

Which of the following is FALSE about multitable queries?

Which of the following is NOT a type of relationship available in Access 2013?

When referential integrity is enforced,you cannot enter a(n)________ key in a related table unless the primary key exists in the primary table.

Which of the following statements is TRUE regarding multitable queries?

You can set a(n)________ to create a label more readable than a field.

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

The value in a field with the ________ data type will be automatically increased each time a new record is entered.

If a user selects the ________ Related Fields option while creating a relationship,Access will automatically modify all foreign key values in a related table to match any modifications made to the primary key.

Referential integrity should be enforced in a database with related tables because it:

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

Two or more tables that contain duplicate data are an example of:

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

The maximum size of the data type is characters.