Question 1

Changing the order of fields in a database table is an example of changing a table's ____.

Accepted Answer

A) purpose 
B) structure 
C) data 
D) value 
A) purpose 
B) structure 
C) data 
D) value B

Question 2

A field in an Access database table that has no value is determined by Access to have a ____ value.

Accepted Answer

A) custom 
B) zero 
C) null 
D) number 
A) custom 
B) zero 
C) null 
D) number C

Question 3

Explain how a one-to-many relationship is created using an Access database with two or more tables.  Why is it useful to create a relationship between tables?

Accepted Answer

​ A one-to-many relationship exists between two tables  when one record in the first table matches zero, one, or  many records in the second table, and when one record  in the second table matches at most one record in the fi rst table. Here, the Owner and Animal tables have a  one-to-many relationship because an Owner can own  many animals, and each animal is associated with only  one owner. The two tables are still separate tables, but  because they are joined, you can use the data in them  as if they were one table.

Question 4

Access does not require a field description for every field included in a table.  
_________________________

Accepted Answer

A) True 
 B)False

Question 5

Match between columns
                        Premises: The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

Accepted Answer

The Answer of data redundancy and Cascade Delete Related Records is...

Question 6

Performing a(n)____________________ is the process of relating tables in a database based on a common field.

Accepted Answer

The answer of Performing a(n)____________________ is the process of relating...

Question 7

The default character length for the Short Text data type is ____ characters.

Accepted Answer

A) 55 
B) 255 
C) 64 
D) 15 
A) 55 
B) 255 
C) 64 
D) 15

Question 8

Field name display in database objects such as datasheets, forms, and reports is determined by the ____________________ property.

Accepted Answer

The answer of Field name display in database objects such...

Question 9

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.  
_________________________

Accepted Answer

A) True 
 B)False

Question 10

The default Field Size for the Short Text data type is ____________________ characters.

Accepted Answer

The answer of The default Field Size for the Short...

Question 11

The Address Quick Start selection adds a group of relationships related to an address including Address, City, State, etc. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: A group of fields added all at once using the Data Type gallery.

Accepted Answer

The Answer of Data Type gallery and Design and propagate is...

Question 13

By choosing the Definition Only option in the Import Objects dialog box, the ____ of a table is imported, but not the ____.

Accepted Answer

A) data, structure 
B) data type, structure 
C) structure, data 
D) structure, data type 
A) data, structure 
B) data type, structure 
C) structure, data 
D) structure, data type

Question 14

Which data type allows both positive and negative numbers as field values?

Accepted Answer

A) Number 
B) Date/Time 
C) AutoNumber 
D) Short Text 
A) Number 
B) Date/Time 
C) AutoNumber 
D) Short Text

Question 15

A database system determines how to store, display, and process field values based on which of the following?

Accepted Answer

A) field names 
B) field properties 
C) field captions 
D) field size 
A) field names 
B) field properties 
C) field captions 
D) field size

Question 16

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

Accepted Answer

A) there is no relationship between tables 
B) the Excel and Access caption property values to do not match 
C) the data was entered incorrectly 
D) the Access field names and the Excel worksheet column headings do not match 
A) there is no relationship between tables 
B) the Excel and Access caption property values to do not match 
C) the data was entered incorrectly 
D) the Access field names and the Excel worksheet column headings do not match

Question 17

When choosing field names, it is best to choose names that ____.

Accepted Answer

A) include both numbers and letters in the name 
B) use only uppercase characters 
C) describe the content or purpose of the field 
D) use only lowercase letters and no spaces 
A) include both numbers and letters in the name 
B) use only uppercase characters 
C) describe the content or purpose of the field 
D) use only lowercase letters and no spaces

Question 18

The "one" table in a one-to-many relationship is the ____________________ table.

Accepted Answer

The answer of The "one" table in a one-to-many relationship...

Question 19

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

Accepted Answer

The answer of The ____________________ Field Size property of a...

Question 20

Field value maximum storage size is defined by the Field Size property for the data types including Short Text, Number, and ____________________ only.

Accepted Answer

The answer of Field value maximum storage size is defined...

Changing the order of fields in a database table is an example of changing a table's ____.

A field in an Access database table that has no value is determined by Access to have a ____ value.

Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?

Access does not require a field description for every field included in a table. _________________________

Performing a(n)____________________ is the process of relating tables in a database based on a common field.

The default character length for the Short Text data type is ____ characters.

Field name display in database objects such as datasheets, forms, and reports is determined by the ____________________ property.

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________________________

The default Field Size for the Short Text data type is ____________________ characters.

The Address Quick Start selection adds a group of relationships related to an address including Address, City, State, etc. _________________________

By choosing the Definition Only option in the Import Objects dialog box, the of a table is imported, but not the .

Which data type allows both positive and negative numbers as field values?

A database system determines how to store, display, and process field values based on which of the following?

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

When choosing field names, it is best to choose names that ____.

The "one" table in a one-to-many relationship is the ____________________ table.

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

Field value maximum storage size is defined by the Field Size property for the data types including Short Text, Number, and ____________________ only.

Access-Module 1: Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 2: Building a Database and Defining Table Relationships

Changing the order of fields in a database table is an example of changing a table's ____.

A field in an Access database table that has no value is determined by Access to have a ____ value.

Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?

Access does not require a field description for every field included in a table. _________________________

Performing a(n)____________________ is the process of relating tables in a database based on a common field.

The default character length for the Short Text data type is ____ characters.

Field name display in database objects such as datasheets, forms, and reports is determined by the ____________________ property.

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________________________

The default Field Size for the Short Text data type is ____________________ characters.

The Address Quick Start selection adds a group of relationships related to an address including Address, City, State, etc. _________________________

By choosing the Definition Only option in the Import Objects dialog box, the ____ of a table is imported, but not the ____.

Which data type allows both positive and negative numbers as field values?

A database system determines how to store, display, and process field values based on which of the following?

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

When choosing field names, it is best to choose names that ____.

The "one" table in a one-to-many relationship is the ____________________ table.

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

Field value maximum storage size is defined by the Field Size property for the data types including Short Text, Number, and ____________________ only.

Access-Module 1: Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

By choosing the Definition Only option in the Import Objects dialog box, the of a table is imported, but not the .