Question 1

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

Accepted Answer

A form in Microsoft Access allows you to customize the way data is displayed and organized. You can add graphics, labels, and controls to create a more user-friendly interface for viewing and entering data. Tab order and property sheet are not relevant to changing the way data is displayed. A spreadsheet can be used in Access, but it does not offer as much flexibility in customizing the layout as a form does.

Question 2

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

Accepted Answer

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

Question 3

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.

Accepted Answer

The answer of To create a relationship between one row...

Question 4

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

Accepted Answer

A surrogate key is a unique identifier used to identify a record in a table, but it does not have any meaningful information or relationship to the user.

Question 5

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.

Accepted Answer

The answer of Which of the following statements is true...

Question 6

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

Accepted Answer

To delete data in Microsoft Access, the user should open the table and select the rows they want to delete, then press the Delete key on their keyboard. Alternatively, they can use the "Delete" option in the "Records" group on the "Home" tab of the ribbon. Double-clicking the table name will open the table, but will not allow the user to directly delete data.

Question 7

All relational database management system (DBMS)products can process the ________ query language.
A)SQL
B)PHP
C)DB10
D)HTML

Accepted Answer

SQL is the standard query language used for relational databases. While some DBMS products may have their own proprietary language, all of them are capable of processing SQL. Likewise, PHP, DB10, and HTML are not query languages for DBMS products.

Question 8

Microsoft Access can process SQL.

Accepted Answer

Microsoft Access can process SQL queries and commands.

Question 9

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

Accepted Answer

The "Home" tab in Microsoft Access contains the "Records" section, where users can find options to delete records.

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

This is known as an inner join, where only rows with matching values in both tables are shown. However, other types of joins like left join, right join, and outer join can also be used to display rows that may not have matching values in one of the tables.

Question 12

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

Accepted Answer

The answer of Which of the following is one of...

Question 13

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

Accepted Answer

The answer of Explain the procedure for establishing a relationship...

Question 14

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

Accepted Answer

The answer of Explain the different alternatives provided by Microsoft...

Question 15

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

Accepted Answer

To define relationships in Microsoft Access, you need to select the Database Tools tab and then click on the Relationships button. This will open up the Relationships window where you can create and manage your relationships between tables.

Question 16

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

Accepted Answer

In Microsoft Access, tables can be created first and then relationships can be defined between them. However, it is recommended to define relationships between tables in order to maintain data integrity and avoid errors.

Question 17

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

Accepted Answer

Microsoft Access does provide a graphical interface for creating and processing queries.

Question 18

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

Accepted Answer

After creating a relationship between two tables in Microsoft Access, the user does not need to manually assign values for the foreign key as it is automatically populated based on the values in the primary key of the related table. However, queries, primary keys, and add-ons may still need to be manually assigned and configured.

Question 19

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.

Accepted Answer

This statement is true. 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 20

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

Accepted Answer

After creating a relationship between two tables in Microsoft Access, the next step would be to enter data into the tables. This will ensure that the relationship between the tables is established properly and can be used for further analysis or queries. Creating macros or providing table descriptions can be done at any point, but entering data is the immediate next step after creating a relationship. Creating queries may come later in the process once data has been entered and relationships have been established.

Quiz 18: Using Microsoft Access 2013

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

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

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.

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

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

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

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

Microsoft Access can process SQL.

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