Deck 18: Using Microsoft Access 2013

Question 1

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

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

Answer 1

B

Question 2

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

Answer 2

To create a new database,select Blank desktop database from the templates displayed in the centre of the opening screen.Then,type the name of the new database under File Name.Access will suggest a directory;change it if another one should be used,and then click Create.Access opens the new database by creating a default table named Table 1.

Question 3

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

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

Answer 3

B

Question 4

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

Question 5

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

Question 6

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

Question 7

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

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

Question 8

Access opens a new database by ________.

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

Question 9

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)Access opens the new database with the default name,database 1.
C)Access opens the new database with the default name,database A.
D)A user must select the name of his new database from the drop down list provided next to the File name.

Question 10

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

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

Question 11

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

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

Question 12

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

Question 13

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

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

Question 14

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

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

Question 15

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

Question 16

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

Question 17

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

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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

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

Question 23

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

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

Question 24

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

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

Question 25

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

Question 26

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

Question 27

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 28

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

Question 29

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

Question 30

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

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

Question 31

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

Question 32

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

Question 33

Microsoft Access can process SQL.

Question 34

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)Tab Order
B)Add-ins
C)Property Sheet
D)Form

Question 35

All modern DBMS products can process the ________ query language.

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

Question 36

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

Question 37

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

Question 38

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

Question 39

In Access,the step after creating a relationship between two tables is ________.

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

Question 40

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

Question 41

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

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

Question 42

How can a user generate reports in Microsoft Access?

Question 43

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

Question 44

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

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

Question 45

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

A)Report Design
B)SharePoint lists
C)Navigation tab
D)Report Wizard

Question 46

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

Question 47

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

Question 48

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