Deck 18: Using Microsoft Access 2013

Question 1

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

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

Answer 1

D

Question 2

Which of the following is the first activity to be performed while creating a database using Microsoft Access?

A)naming the database
B)assigning field names
C)creating field description
D)creating a table

Answer 2

A

Question 3

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

Answer 3

True

Question 4

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 5

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

Question 6

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

A)A user must type the name of the 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)Microsoft Access opens the new database with the default name,database 1.
D)Microsoft Access requires a user to name the new database before selecting a Blank desktop database.

Question 7

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 8

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

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

Question 9

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

Question 10

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

Question 11

Which of the following is a valid entry for field size if the data type of the field is Number?

A)Alphanumeric
B)Special characters
C)Long integer
D)Character

Question 12

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

Question 13

Before using any database management system (DBMS),a user should create a data model based on users' requirements.

Question 14

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 15

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

Question 16

In Microsoft 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 17

In Microsoft Access,one must select the relationships option in the Design tab to modify the design of a default table.

Question 18

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

Question 19

Microsoft Access opens a new database by creating a ________.

A)new Word document in the cloud
B)default Microsoft spreadsheet named A1
C)default table named Table
D)shared storage space in the server

Question 20

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

Question 21

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)spread sheet

Question 22

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

Question 23

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

Question 24

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

Question 25

Which of the following statements is true about queries in Microsoft 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 26

To delete data in Microsoft Access,a user should double-click the table name in the left hand pane.

Question 27

All relational database management system (DBMS)products can process the ________ query language.

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

Question 28

Microsoft Access can process SQL.

Question 29

To delete a record in Microsoft Access,a user has to select the Records section in the ________ tab.

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

Question 30

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

Question 31

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

Question 32

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

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

Question 33

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

Question 34

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

Question 35

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

Question 36

In Microsoft Access,a user has to define the relationship between two tables before creating them.

Question 37

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

Question 38

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

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

Question 39

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 40

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

A)create macros
B)enter data
C)provide table description
D)create queries

Question 41

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

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

Question 42

How can a user generate reports in Microsoft Access?

Question 43

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

Question 44

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 45

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

Question 46

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

Question 47

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

Question 48

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

A)Reports can be created by using the sections 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 cannot be used to present the sum or average of values stored in a database.