Creating Advanced Queries And Reports And Using Sql

This question bank verified by Studydeets

Questions Bank

Creating a Database and Tables
Using Design View, Data Validation, and Relationships
Creating and Using Queries
Creating and Using Forms and Reports
Templates, Advanced Relationships, and Macros
Creating Advanced Queries and Reports and Using SQL
Creating Advanced Forms
Integrating Applications
Designing and Managing Databases
Customizing Access and Using Skydrive and Office Web Apps

All Questions

Question 1

Free

True/False

When you create a database built from one of these templates,you must link it to a SharePoint server running Access Services.

Choose correct answer/s

True

False

Check answer

Question 2

Free

True/False

Most templates open with the Navigation pane closed.

Choose correct answer/s

True

False

Check answer

Question 3

Free

True/False

Design view is an available option for objects in web databases.

Choose correct answer/s

True

False

Check answer

Question 4

Free

True/False

For web databases,Access provides enhanced Datasheet view features as well as the Layout view functionality.

Choose correct answer/s

True

False

Check answer

Question 5

Free

True/False

After completing the Lookup Wizard,Access automatically creates a relationship between the two tables.

Choose correct answer/s

True

False

Check answer

Question 6

True/False

The Row Source Type and Row Source properties are not set automatically by the Lookup Wizard.

Choose correct answer/s

True

False

To unlock the question

Question 7

True/False

SQL is the underlying language in a relational database system.

Choose correct answer/s

True

False

To unlock the question

Question 8

True/False

A many-to-many relationship exists when one row of data in one table can be associated with many rows of data in a second table.

Choose correct answer/s

True

False

To unlock the question

Question 9

True/False

Relational databases,like Access,do not directly support many-to-many relationships.

Choose correct answer/s

True

False

To unlock the question

Question 10

True/False

The join type property determines how to match the data in the two related tables.

Choose correct answer/s

True

False

To unlock the question

Question 11

True/False

When a relationship is created,Access assigns it an inner join type.

Choose correct answer/s

True

False

To unlock the question

Question 12

True/False

Changing a relationship's join type only affects the way queries,and any object built from a query,work.

Choose correct answer/s

True

False

To unlock the question

Question 13

True/False

A macro is a database object that allows you to write and attach code to different objects and controls in your database.

Choose correct answer/s

True

False

To unlock the question

Question 14

True/False

Macros in Access are the same as the macros you may have created in Excel or Word.

Choose correct answer/s

True

False

To unlock the question

Question 15

True/False

Events are occurring all of the time when you use a database.

Choose correct answer/s

True

False

To unlock the question

Question 16

True/False

User interface macros are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface.

Choose correct answer/s

True

False

To unlock the question

Question 17

True/False

Comments affect the logic or functionality of macros.

Choose correct answer/s

True

False

To unlock the question

Question 18

True/False

A stand-alone macro is a separate Access object that appears in the Navigation pane.

Choose correct answer/s

True

False

To unlock the question

Question 19

True/False

An embedded macro is attached to one specific object or control on an object.

Choose correct answer/s

True

False

To unlock the question

Question 20

True/False

You can create a stand-alone macro that executes automatically when the database is first opened.

Choose correct answer/s

True

False

To unlock the question