Question 1

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.

Accepted Answer

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

Question 2

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

Accepted Answer

After creating a relationship between two tables in Access, the user does not need to assign values for the foreign key. The foreign key automatically gets created in the related table and is used to link the two tables together. The other options - tracker, query and add-ons - are not relevant to the scenario mentioned in the question.

Question 3

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.

Accepted Answer

By default, Access uses INNER JOINs in queries, which only show rows with matching values in all selected tables.

Question 4

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

Accepted Answer

The default table display in Microsoft Access can be used as a simple data entry form, allowing users to input data directly into the table's rows and columns.

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

This is known as an inner join, where only matching rows from both tables are displayed. However, Access also offers other types of joins such as left join, right join and full outer join, which can show additional rows from one or both tables.

Question 7

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 is the basic method of creating a query in Microsoft Access by selecting columns from the necessary tables and placing them in the query grid.

Question 8

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

Accepted Answer

Relationships can be defined in Microsoft Access by selecting the DATABASE TOOLS tab and then clicking on the Relationships button. This allows the user to create and manage relationships between tables in the database.

Question 9

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 10

In the ________ tab in Access,the Record section contains the Delete option.
A)Database Tools
B)File
C)Home
D)Fields

Accepted Answer

The Record section in Access is typically found in the Home tab, which includes various options such as New, Save, Delete, and View. The Database Tools tab contains tools for managing the database, while the File tab includes options for opening, saving, and printing the database file. The Fields tab is used for designing and modifying the fields in a table.

Question 11

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

Accepted Answer

The answer of Unlike Microsoft Excel,users cannot key in data...

Question 12

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

Accepted Answer

The user can create the tables first and then define the relationships between them in Microsoft Access.

Question 13

Microsoft Access can process SQL.

Accepted Answer

Microsoft Access can process SQL statements and can be used as both a database management system and a front-end application development tool.

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

Accepted Answer

Forms in Microsoft Access can be used to present data in a more visually appealing and organized manner than the default table display. Forms allow for customization of layout, design, and functionality, such as adding buttons or dropdown menus.

Question 15

All modern DBMS products can process the ________ query language.
A)DB10
B)MySQL
C)HTML
D)SQL

Accepted Answer

SQL (Structured Query Language) is the standard query language used by most modern DBMS products to manage and manipulate databases. DB10, MySQL, and HTML are not query languages for managing databases.

Question 16

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 17

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

Accepted Answer

A surrogate key is typically an auto-generated numeric value that is used as the primary key of a table for tracking and identifying records. It has no inherent meaning or significance to the end-user, as it is mainly used for identifying and linking relationships between tables in the database.

Question 18

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

Accepted Answer

Microsoft Access does provide a graphical interface for creating and processing queries through the query design view.

Question 19

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

Accepted Answer

Once a relationship has been created between two tables in Access, the next logical step is to begin entering data into the tables, as the relationship will help ensure data consistency and accuracy. Providing descriptions, creating macros, and creating queries can all be done at any point in the process of working with Access tables, but entering data is the most immediate next step after creating a relationship.

Question 20

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, known as the "Datasheet view".

Quiz 18: Using Microsoft Access 2013

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.

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

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

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