Deck 18: Using Microsoft Access 2013

Question 1

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

Answer 1

C

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 center of the opening screen.Then, type the name of the new database under File Name.Microsoft Access will suggest a directory; change it if another one should be used, and then click Create.Microsoft Access opens the new database by creating a default table named Table.

Question 3

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

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

Answer 3

A

Question 4

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

Question 5

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 6

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

Question 7

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 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, an underlined attribute is a primary key and an italicized attribute is a foreign key.

Question 10

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

Question 11

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

Question 12

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

Question 13

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 14

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

Question 15

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

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

Question 16

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 17

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

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

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

Question 21

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

Question 22

Ramona works for City Hospital.She wants to fill in details of the hospital staff into the database, but she does not want to use the default table display.She prefers a design that would be easier to use and view.Which of the following options would suit Ramona's requirements?

A)form
B)tab order
C)property sheet
D)table

Question 23

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

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

Question 24

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

Question 25

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 26

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

Question 27

Russell works on two tables in Microsoft Access.One is for contractual employees, whereas, the other is for permanent employees.He creates a relationship between the two tables.Which of the following steps should Russell take next?

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

Question 28

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 29

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

Question 30

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

Question 31

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 32

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

Question 33

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

Question 34

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

Question 35

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 36

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 37

Microsoft Access can process SQL.

Question 38

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

Question 39

Jane is performing a monthly check on her company's database.She finds records of a number of employees who are no longer working with the company and whose details need to be deleted.To delete the records, Jane would have to select the Records section in the ________ tab.

A)Database tools
B)Home
C)Fields
D)External Data

Question 40

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

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

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

Question 43

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)The 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.

Question 44

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

Question 45

Leonard, a librarian, needs to create a report using data from a table that lists books on management studies and another that lists books on law.Which of the following tools will help Leonard create his report?

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

Question 46

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

Question 47

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

Question 48

How can a user generate reports in Microsoft Access?