Exam 12: Managing and Securing a Database

Which Access feature is used to divide an Access database into two files: one file contains the tables of the database and the other file contains the queries,forms,reports,and other database objects.

(Multiple Choice)

4.7/5

(85)

Question 21

An outer query may also be referred to as a subquery.____________________

(True/False)

4.8/5

(74)

Question 22

A table that is stored in a file outside of the open database that can be updated from the open database.

(Multiple Choice)

4.8/5

(72)

Question 23

A query that is run first within another query before the parent query is run.

(Multiple Choice)

4.9/5

(85)

Question 24

A query that contains a subquery.

(Multiple Choice)

4.9/5

(81)

Question 25

Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business. Her database needs to be expanded and changed to meet the needs of the growing business. Her database includes tables for monogram styles,catalog products,orders,billing,customers,and vendors. -Marissa would like to add a picture of each catalog product to each record in the catalog table.Which data type should she use for the ProductDescription field?

(Multiple Choice)

4.9/5

(76)

Question 26

A filter may be saved as a query from the Advanced button in the Sort & Filter group on the Home tab.

(True/False)

4.8/5

(64)

Question 27

Which of the following is an example of a database containing the database tables created by the Database Splitter for the Sales database?

(Multiple Choice)

4.8/5

(75)

Question 28

Enables or disables the F11 key (show/hide the Navigation Pane),Ctrl+G (show/hide the Immediate window in VB editor),and Alt+F1 (start VB Editor).

(Multiple Choice)

4.8/5

(83)

Question 29

To display a multivalued field in expanded form so that each value is displayed on a separate row in a query,set the ____ property for the field.

(Multiple Choice)

4.8/5

(60)

Question 30

In order to isolate a subset of records from an open form or datasheet that will be needed only temporarily,a set of criteria may be placed on the records using a(n)____.

(Multiple Choice)

5.0/5

(85)

Question 31

An Access database created using Access 2007 or later may only be saved with the *.accdb filename extension and cannot be opened with versions of Access prior to 2007.____________________

(True/False)

4.9/5

(62)

Question 32

A second query included in a SQL SELECT statement beginning with a second SELECT statement.

(Multiple Choice)

4.9/5

(70)

Question 33

The database created when using the Database Splitter that includes all database objects except the tables of the database.

(Multiple Choice)

4.8/5

(84)

Question 34

Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager.He has been given specific requirements to narrow the data based on the information the manager needs.Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information. -Sheng also considers creating a second SQL SELECT statement within the query used to create the datasheet containing the filter he plans to save.If Sheng does this,he is creating a(n)____.

(Multiple Choice)

4.9/5

(84)

Question 35

Table design for tables in a split database may only be modified in the front-end database.____________________

(True/False)

4.9/5

(81)

Question 36

Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager.He has been given specific requirements to narrow the data based on the information the manager needs.Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information. -Using the Product Vendor form,Sheng would like to filter records that match multiple selection criteria;however,he does not need the filtered records to be sorted.Which type of filter should Sheng use for this task?

(Multiple Choice)

4.9/5

(68)

Question 37

The objects in a front-end database use tables in the ____.

(Multiple Choice)

4.9/5

(79)

Question 38

The primary purpose of the ____ is to optimize the performance of an Access database.

(Multiple Choice)

4.8/5

(79)

Question 39

Using Backstage View and Access Options,set the ____ property to change the title of the database that appears in the Access window title bar.

(Multiple Choice)

4.9/5

(90)

Question 40

Showing 21 - 40 of 75

Which Access feature is used to divide an Access database into two files: one file contains the tables of the database and the other file contains the queries,forms,reports,and other database objects.

An outer query may also be referred to as a subquery.____________________

A table that is stored in a file outside of the open database that can be updated from the open database.

A query that is run first within another query before the parent query is run.

A query that contains a subquery.

A filter may be saved as a query from the Advanced button in the Sort & Filter group on the Home tab.

Which of the following is an example of a database containing the database tables created by the Database Splitter for the Sales database?

Enables or disables the F11 key (show/hide the Navigation Pane),Ctrl+G (show/hide the Immediate window in VB editor),and Alt+F1 (start VB Editor).

To display a multivalued field in expanded form so that each value is displayed on a separate row in a query,set the ____ property for the field.

In order to isolate a subset of records from an open form or datasheet that will be needed only temporarily,a set of criteria may be placed on the records using a(n)____.

An Access database created using Access 2007 or later may only be saved with the *.accdb filename extension and cannot be opened with versions of Access prior to 2007.____________________

A second query included in a SQL SELECT statement beginning with a second SELECT statement.

The database created when using the Database Splitter that includes all database objects except the tables of the database.

Table design for tables in a split database may only be modified in the front-end database.____________________

The objects in a front-end database use tables in the ____.

The primary purpose of the ____ is to optimize the performance of an Access database.

Using Backstage View and Access Options,set the ____ property to change the title of the database that appears in the Access window title bar.

Creating a Database

Building a Database and Defining Table Relationships

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

Relational Databases and Database Design

Filters

Exam 12: Managing and Securing a Database

Which Access feature is used to divide an Access database into two files: one file contains the tables of the database and the other file contains the queries,forms,reports,and other database objects.

An outer query may also be referred to as a subquery.____________________

A table that is stored in a file outside of the open database that can be updated from the open database.

A query that is run first within another query before the parent query is run.

A query that contains a subquery.

A filter may be saved as a query from the Advanced button in the Sort & Filter group on the Home tab.

Which of the following is an example of a database containing the database tables created by the Database Splitter for the Sales database?

​Enables or disables the F11 key (show/hide the Navigation Pane),Ctrl+G (show/hide the Immediate window in VB editor),and Alt+F1 (start VB Editor).

To display a multivalued field in expanded form so that each value is displayed on a separate row in a query,set the ____ property for the field.

In order to isolate a subset of records from an open form or datasheet that will be needed only temporarily,a set of criteria may be placed on the records using a(n)____.

An Access database created using Access 2007 or later may only be saved with the *.accdb filename extension and cannot be opened with versions of Access prior to 2007.____________________

A second query included in a SQL SELECT statement beginning with a second SELECT statement.

The database created when using the Database Splitter that includes all database objects except the tables of the database.

Table design for tables in a split database may only be modified in the front-end database.____________________

The objects in a front-end database use tables in the ____.

The primary purpose of the ____ is to optimize the performance of an Access database.

Using Backstage View and Access Options,set the ____ property to change the title of the database that appears in the Access window title bar.

Creating a Database

Building a Database and Defining Table Relationships

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

Relational Databases and Database Design

Filters

Enables or disables the F11 key (show/hide the Navigation Pane),Ctrl+G (show/hide the Immediate window in VB editor),and Alt+F1 (start VB Editor).