Exam 2: Building a Database and Defining Table Relationships

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

(Short Answer)

4.9/5

(31)

Question 41

Identify the letter of the choice that best matches the phrase or definition. -A group of fields added all at once using the Data Type gallery.

(Multiple Choice)

4.9/5

(35)

Question 42

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

(Multiple Choice)

4.8/5

(26)

Question 43

Identify the letter of the choice that best matches the phrase or definition. -The process that occurs when the field Description (Optional)property is changed in Design View and the Property Update Options tool is used to update the entire database everywhere the field is used,including forms and reports.

(Multiple Choice)

4.9/5

(32)

Question 44

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

(True/False)

4.9/5

(34)

Question 45

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

(Multiple Choice)

4.8/5

(34)

Question 46

Field names in a table may only be changed in Design view. _________________________

(True/False)

4.9/5

(39)

Question 47

In order to define table relationships,each table being joined must contain a common field._________________________

(True/False)

4.8/5

(35)

Question 48

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

(Multiple Choice)

4.8/5

(31)

Question 49

Access does not require a table to have a(n)primary key._________________________

(True/False)

4.7/5

(38)

Question 50

Identify the letter of the choice that best matches the phrase or definition. -A record in a table that is related to a primary table but has no matching record established with the primary table.

(Multiple Choice)

4.9/5

(40)

Question 51

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

(Multiple Choice)

4.9/5

(30)

Question 52

The data type that allows both sequential and random numbering is the ____ data type.

(Multiple Choice)

4.9/5

(37)

Question 53

____________________ view allows the database designer to enter both the field names and define the field properties.

(Short Answer)

4.7/5

(37)

Question 54

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n)____________________ in the second table.

(Short Answer)

4.8/5

(26)

Question 55

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n)keyboard shortcut._________________________

(True/False)

4.9/5

(33)

Question 56

Access automatically assigns the Number data type to all new fields. _________________________

(True/False)

4.8/5

(39)

Question 57

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

(Multiple Choice)

4.8/5

(40)

Question 58

In a single table,all ____________________ must be unique within that table.

(Short Answer)

4.8/5

(38)

Question 59

Access does not allow data to be imported from sources other than another Access database. _________________________

(True/False)

4.9/5

(32)

Question 60

Showing 41 - 60 of 75

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

Identify the letter of the choice that best matches the phrase or definition. -A group of fields added all at once using the Data Type gallery.

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

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

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

Field names in a table may only be changed in Design view. _________________________

In order to define table relationships,each table being joined must contain a common field._________________________

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

Access does not require a table to have a(n)primary key._________________________

Identify the letter of the choice that best matches the phrase or definition. -A record in a table that is related to a primary table but has no matching record established with the primary table.

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

The data type that allows both sequential and random numbering is the ____ data type.

____________________ view allows the database designer to enter both the field names and define the field properties.

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n)____________________ in the second table.

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n)keyboard shortcut._________________________

Access automatically assigns the Number data type to all new fields. _________________________

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____.

In a single table,all ____________________ must be unique within that table.

Access does not allow data to be imported from sources other than another Access database. _________________________

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 Formsmodule

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