Deck 18: Using Microsoft Access 2013

Question 1

In the ________ tab in Access,the Record section contains the Delete option.

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

Answer 1

B

Question 2

Which of the following is a valid entry for Field Size if the Data Type of the field is "Number"?

A) 10
B) 10.5
C) long integer
D) character

Answer 2

C

Question 3

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

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

Answer 3

C

Question 4

Before using a DBMS,a user should create a(n)________.

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

Question 5

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

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

Question 6

Which of the following statements is true about a primary key in Microsoft Access?

A) Only one field in a table can be marked as the primary key.
B) The attribute which is italicized is the primary key.
C) A primary key should have its Required Field property set to "No."
D) A foreign key can be used as one of the fields for a primary key.

Question 7

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 8

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) specify the data types of the fields

Question 9

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

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

Question 10

In Access,to create a relationship between one row of a table and an unlimited number of rows in another table,users should ________.

A) drag the primary key in one table to the foreign key in another table
B) create a link between the foreign keys of 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 11

Which of the following statements is true about queries in Access?

A) Only rows with value matches in all tables are shown by default if more than one table is selected.
B) Only rows having "Number" Data Type can be used to arrange the results of a query in ascending order.
C) Queries can include fields from only one table.
D) The Query Design option is present in the DATABASE TOOLS tab.

Question 12

All modern DBMS products can process the ________ query language.

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

Question 13

Access opens a 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 14

Which of the following options in Microsoft Access can be used to present data in a more pleasing manner than the default table display?

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

Question 15

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

A) DATABASE TOOLS
B) EXTERNAL DATA
C) CONNECTIONS
D) ADD-ONS

Question 16

Which of the following statements is true about reports in Access?

A) The Report Wizard option is present in the Database Tools tab.
B) Report Wizard is required when data from more than one table is to be used.
C) Only the primary key's column width can be increased in a report.
D) A report can only show the data present in the database, it cannot present their sum or average values.

Question 17

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 key
D) creating a table

Question 18

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) SharePoint lists

Question 19

In Access,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 20

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

A) CREATE
B) DATA
C) TOOLS
D) FORMAT

Question 21

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

Question 22

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

Question 23

Before using any DBMS,a user should create a data model based on the users' requirements.

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

In Access,"Integer" is a valid entry for Field Size if the Data Type is "Text."

Question 29

In Microsoft Access,relationships can be defined by selecting the DATABASE TOOLS tab.

Question 30

In Access,an underlined attribute is a primary key and an italicized attribute is a foreign key.

Question 31

Microsoft Access can process SQL.

Question 32

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

Question 33

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

Question 34

To create a report with data from a single table,we must use the Report Wizard.

Question 35

Microsoft Access provides a default table display for creating a data entry form.

Question 36

In Access,a surrogate key has no meaning to the user.

Question 37

To create a relationship between one row of a table and an unlimited number of rows in another table using Access,users must drag the foreign key in one table to the primary key in another table to create a relationship.

Question 38

In Access,to modify the design of a default table,one must select the Relationships option in the DESIGN tab.

Question 39

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

Question 40

Any text entered as the Description of a field is displayed as help text on forms.

Question 41

The option to create reports can be found in the DATABASE TOOLS tab of Microsoft Access.

Question 42

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

Question 43

Explain the procedure for creating a new database using Microsoft Access.

Question 44

What steps must a database designer take before creating a database with Access?

Question 45

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

Question 46

In Microsoft Access reports,the Grouping & Totals section contains the options to display totals in a report.

Question 47

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

Question 48

How can a user generate reports in Microsoft Access?