Deck 16: Microsoft Access 2010

Question 1

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

Answer 1

False

Question 2

Microsoft Access databases are stored using the file extension .accdb.

Answer 2

False

Question 3

The Microsoft Access window Close button is actually a close-and-exit button.

Answer 3

True

Question 4

Most Microsoft Access 2010 commands and tools are available on the tabbed Ribbon.

Question 5

In addition to the basic command tabs,Microsoft Access 2010 also has additional contextual command tabs.

Question 6

Microsoft Access 2010 uses the Access 2003 .mdb file format as the default file format for database files.

Question 7

The default Microsoft Access 2010 command tabs are Home,Create,Internal Data and Database Tools.

Question 8

In Microsoft Access,relationships between tables are created in the Relationships window.

Question 9

Microsoft Access is a personal database that combines a DBMS with an application generator.

Question 10

Each command tab contains a set of tools grouped into sets of related commands.

Question 11

Microsoft uses the term object as a general name for various parts of Microsoft Access 2010.

Question 12

In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.

Question 13

Microsoft Access uses the AutoNumber data type to create surrogate keys.

Question 14

Microsoft Access SQL commands are run within the SQL View of a Query window.

Question 15

Microsoft Access can run QBE queries,but not SQL queries.

Question 16

The Microsoft Access 2010 tabbed Ribbon contains a set of control tabs.

Question 17

Microsoft Access database objects are displayed in the Browser Pane.

Question 18

Microsoft Access 2010 uses the Microsoft Office Fluent User Interface.

Question 19

To start Microsoft Access 2010,use the Start | All Programs | Microsoft Office | Microsoft Access 2010 command.

Question 20

The Microsoft Access application generator provides the ability to create and store forms,reports,and queries.

Question 21

The Microsoft Access application generator is not responsible for:

A)creating forms.
B)creating reports.
C)creating queries.
D)creating tables.
E)storing queries.

Question 22

In Microsoft Access,the primary key must be set as a field property while the table is in Design View.

Question 23

In Microsoft Access,the relationship between two tables is not actually created until:

A)the OK button in the Create Relationships dialog box is clicked.
B)the Create button in the Create Relationships dialog box is clicked.
C)the OK button in the Edit Relationships dialog box is clicked.
D)the Create button in the Edit Relationships dialog box is clicked.
E)the Join button in the Edit Relationships dialog box is clicked.

Question 24

Microsoft Access 2010 database files are stored using the file extension of:

A).adb.
B).asp.
C).accdb.
D).mdb.
E).sql.

Question 25

Microsoft Access is a personal database system,and a personal database system is characterized by:

A)the DBMS removing the metadata from the database.
B)the DBMS product taking the role of the DBMS and the database application generator.
C)the database being stored inside the DBMS.
D)the DBMS product being limited to a maximum of ten tables in any given database.
E)the DBMS not supporting indexes.

Question 26

In Microsoft Access,tables are added to a Query window by:

A)selecting the tables from the Use Table dialog box.
B)selecting the tables from the Show Table dialog box.
C)selecting the tables from the Tables section of the Navigation Pane.
D)selecting the tables from the Queries section of the Navigation Pane.
E)selecting the tables from the Relationships window.

Question 27

In Microsoft Access,a relationship between two tables is created:

A)by entering the name of the foreign key in the appropriate table in Design View.
B)by entering the name of the primary key in the appropriate table in Design View.
C)by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window.
D)by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window.
E)by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window.

Question 28

In addition to the standard Ribbon command tabs,Microsoft Access 2010 also includes:

A)optional command tabs.
B)contextual command tabs.
C)quick access tabs.
D)gallery tabs.
E)template tabs.

Question 29

In Microsoft Access,relationships between tables are created:

A)by the Relationships button on the Create command tab.
B)by the Relationships button on the Home command tab.
C)in the Relationships window.
D)in the Table window of the table containing the primary key.
E)in the Table window of the table containing the foreign key.

Question 30

The Microsoft Access 2010 Ribbon contains which of the following command tabs?

A)Home
B)Create
C)External Data
D)Database Tools
E)All of the above.

Question 31

To start Microsoft Access 2010,use the command:

A)Start | Microsoft Access 2010.
B)Start | Microsoft Office | Microsoft Access 2010.
C)Start | All Programs | Microsoft Access 2010.
D)Start | All Programs | Microsoft Office | Microsoft Access 2010.
E)Microsoft Access 2010.

Question 32

Microsoft Access wizards allow easy building of forms and reports.

Question 33

To open a new Microsoft Access Query window:

A)click the New button on the Home command tab.
B)click the New Query button on the Home command tab.
C)click the Create Query button on the Create command tab.
D)click the New Query in Design view button on the Create command tab.
E)click the Query Design button on the Command tab.

Question 34

Microsoft Access is a good tool for forms and reports because:

A)the form and report generators do not exist within Access itself.
B)Access forms and reports are very simplistic.
C)Access wizards make it easy to create the forms and reports.
D)Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows.
E)Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets.

Question 35

The Microsoft Access data type of AutoNumber is used when there is a specific need for a:

A)foreign key.
B)primary key.
C)surrogate key.
D)spare key.
E)secondary key.

Question 36

To open a new Microsoft Access Query window,click the Query Design button on the Create command.

Question 37

Microsoft Access database objects are displayed in the:

A)Navigation Pane.
B)Browser Pane.
C)Object Browser Pane.
D)Gallery Pane.
E)Gallery.

Question 38

In Microsoft Access,referential integrity constraints are created:

A)by setting a property value on the primary key in the table which contains it.
B)by setting a property value on the foreign key in the table which contains it.
C)by setting a property value on the primary key in the Relationships window.
D)by setting a property value on the foreign key in the Relationships window.
E)by checking the Enforce Referential Integrity check box in Edit Relationships dialog box.

Question 39

Microsoft Access SQL commands are run in:

A)the SQL window.
B)the QBE window.
C)the Query View of an SQL window.
D)the Design View of a Query window.
E)the SQL View of a Query window.

Question 40

The Microsoft Access 2010 Close button is actually a:

A)Save and Close button.
B)Save and Exit button.
C)Close and Exit button.
D)Print and Close button.
E)Print and Exit button.

Question 41

Describe the Microsoft Access 2010 Navigation Pane.

Question 42

What is the Microsoft Office Fluent User Interface?

Question 43

Describe the tabbed Ribbon.

Question 44

What Microsoft Access file format is used by default in Microsoft Access 2010?

Question 45

Explain how to create a relationship in Microsoft Access.

Question 46

Microsoft Access is considered a "personal database" product.What is a personal database?

Question 47

What is a surrogate key and how does Microsoft Access 2010 create surrogate keys?

Question 48

Explain how to run an SQL query in Microsoft Access.