Deck 17: Using Microsoft Access 2010

Question 1

Access opens a new database by creating a default table named Table A.

Answer 1

False

Question 2

Relationships can be defined in Microsoft Access by selecting the ________ tab in the ribbon.

A)Database Tools
B)External Data
C)Connections
D)Add-ins

Answer 2

A

Question 3

In Access,after creating a relationship between two tables,the user cannot and need not assign values for the ________.

A)primary key
B)tracker
C)foreign key
D)add-ons

Answer 3

C

Question 4

In Microsoft Access,the description of fields is used to ________.

A)document the details of each field
B)define rules for how each field should behave
C)define how the fields should behave in case of exceptions
D)characterize the fields in terms of their data types

Question 5

In Access,records can be deleted by clicking the down arrow next to Delete and selecting Delete Record,which is present in the Records section of the ________ tab.

A)Database Tools
B)Home
C)Fields
D)File

Question 6

To create a report with data from two or more tables,we must use the ________.

A)Report Wizard
B)Navigation tab
C)Report Design
D)Share Point lists

Question 7

Which of the following options in Microsoft Access can be used to make the data entry form more pleasing for the users?

A)Form
B)Tab Order
C)Property Sheet
D)Add-ins

Question 8

In Access,to create a relationship between two tables,users must ________.

A)drag the primary key in one table to the foreign key in another table
B)create a link between the foreign keys from both the tables
C)drag the foreign key in one table to the primary key in another table
D)create a link between the primary key in one table to the primary key in another table

Question 9

An underlined attribute is the primary key and an italicized attribute is a foreign key.

Question 10

Which of the following is the first activity to be performed on starting Microsoft Access?

A)creating a database
B)assigning field names
C)creating a primary ID
D)creating a table

Question 11

All modern DBMS products can process the ________ query language.

A)SQL
B)MySQL
C)DB10
D)HTML

Question 12

Which of the following tabs in Microsoft Access is used to generate reports?

A)Create
B)Data
C)Tools
D)Format

Question 13

Which of the following is one of the alternatives for creating a data entry form?

A)using the data definition tab
B)using the query wizard
C)using the property sheet
D)using the default table display

Question 14

In Microsoft Access,different attributes are referred to as ________.

A)data
B)keys
C)entities
D)fields

Question 15

Before using a DBMS,the user should have created a(n)________.

A)data model
B)database
C)identifier
D)attribute

Question 16

Which of the following statements is true about naming a new database in Microsoft Access?

A)A user must type the name of his new database in the blank provided under File Name.
B)A user must select the name of his new database from the drop down list provided next to the File name.
C)Access opens the new database with the default name,database 1.
D)Access opens the new database with the default name,database A.

Question 17

Access opens the new database by ________.

A)creating a default table named Table A1
B)creating a default table named Table A
C)creating a default table named Table 1
D)asking the user to name his/her table

Question 18

In Access,to modify the design of a default table,one must click View and select Design View in the upper right-hand corner of the Access window.

Question 19

Before using any DBMS,the user should have created a data model from the users' requirements.

Question 20

The step after creating a relationship between two tables is ________.

A)to create macros
B)to enter data
C)to provide descriptions to each of the tables
D)to create queries

Question 21

By default,for queries of two or more tables,Access shows only those rows that have value matches in both tables.

Question 22

In Microsoft Access,a report is created using a process similar to that for forms.

Question 23

Explain the procedure for establishing a relationship between two tables in Microsoft Access.

Question 24

In Microsoft Access,the option to generate a data entry form is present in the Create ribbon.

Question 25

Every field in Microsoft Access must have a description associated with it.

Question 26

In Microsoft Access,relationships can be defined by selecting the Database Tools tab.

Question 27

In Microsoft Access,a user has to define the relationships between fields before creating the tables.

Question 28

Explain the different alternatives provided by Microsoft Access for creating data entry forms.

Question 29

Unlike Microsoft Excel,users cannot key in data to Microsoft Access cells.

Question 30

The option to create reports can be found in the Database Tools ribbon of Microsoft Access.

Question 31

To create a report with data from not more than two tables,we must use the Report Wizard.

Question 32

How can a user generate reports in Microsoft Access?

Question 33

Microsoft Access can be used to process the SQL query language.

Question 34

In Microsoft Access,users must drag the foreign key in one table to the primary key in another table to enforce a relationship.

Question 35

The description field in Microsoft Access is used mainly for documentation.

Question 36

To create a query,one must drag columns out of the required tables into the grid in the lower part of the query definition form.

Question 37

Explain the procedure for creating a database using Microsoft Access.

Question 38

Microsoft Access provides a default table display for entering the data.

Question 39

Microsoft Access can be used to create and process queries.However,it does not provide a graphical interface for the queries.

Question 40

What steps must a database designer take before using a DBMS?