Question 1

Using Microsoft Access to create a select query with multiple criteria (all of which you want satisfied at the same time), you should specify them on the same Criteria line of the query.

Accepted Answer

In Microsoft Access, when creating a select query with multiple criteria that must all be satisfied, you place them on the same Criteria line to apply the AND logic.

Question 2

A delete query in Microsoft Access is an example of an action query that enables you to delete all those records in a table satisfying specific criteria.

Accepted Answer

A delete query in Microsoft Access is indeed an action query designed to remove records from a table that meet the specified criteria, allowing for bulk deletion based on conditions.

Question 3

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

Accepted Answer

The answer of An update query in Microsoft Access is...

Question 4

Microsoft Access can create a well-functioning database for you using Wizards, and there is no need to understand database design or normalization.

Accepted Answer

Wizards in Microsoft Access guide users through the database creation process, making it possible to create a functional database without in-depth knowledge of database design or normalization.

Question 5

An append query in Microsoft Access is an example of an action query that enables you to systematically add the term "Jr." to individual names in a customer database.

Accepted Answer

An append query in Microsoft Access is used to add records to a table, not to modify existing data like adding "Jr." to names.

Question 6

Using Microsoft Access, "referential integrity" enables you to delete a record on the "one" side of a one-to-many relationship.

Accepted Answer

The answer of Using Microsoft Access, "referential integrity" enables you...

Question 7

In the Relationships window, Access uses this symbol to represent the "many" side of a "one-to-many" relationship:
A)&
B)N
C)√
D)∞

Accepted Answer

The "many" side of a "one-to-many" relationship in Microsoft Access is represented by the infinity symbol (∞). This symbol indicates that multiple records in one table can relate to a single record in another table.

Question 8

It is not possible to create queries for more than on table at a time.

Accepted Answer

SQL allows for the creation of queries that can join, merge, or compare data from multiple tables using JOIN operations, subqueries, and set operations, enabling complex data retrieval across more than one table at a time.

Question 9

An OR operation (query)in Microsoft Access requires you to use multiple Criteria lines to create the query.

Accepted Answer

An OR operation in Microsoft Access can be performed by entering criteria on the same Criteria line for a more inclusive search, or across multiple Criteria lines for separate conditions, but it does not require multiple lines by necessity.

Question 10

A dynaset is the total set of records in a database table.

Accepted Answer

A dynaset (dynamic subset) refers to a set of records that result from a query on a database, not the total set of records in a database table. It dynamically changes as the data in the database is updated.

Question 11

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:
A)Short Text
B)Number
C)Long Text
D)Percent
E)all of these are legitimate data types

Accepted Answer

Percent is not a distinct data type in Microsoft Access; instead, percentages are typically represented using the Number data type and formatted accordingly.

Question 12

Quotation marks that appear around a search criteria (e.g., "New York"), indicates an error.

Accepted Answer

Quotation marks around a search criteria, like "New York", are used to indicate an exact phrase search, ensuring that the search engine looks for the exact phrase within the quotes.

Question 13

It is not possible to conduct multi-table queries using Microsoft Access because each table in the system is independent of the others.

Accepted Answer

The answer of It is not possible to conduct multi-table...

Question 14

If you wish to create a select query with alternate criteria using Microsoft Access , you should specify them on separate Criteria lines of the query.

Accepted Answer

In Microsoft Access, alternate criteria for a select query can be specified on separate Criteria lines, which are interpreted as an OR condition.

Question 15

Foreign keys are necessary in a database because every record must have a foreign key.

Accepted Answer

Not every record in a database requires a foreign key. Foreign keys are used to establish relationships between tables, but not all records or tables need to be related in this way.

Question 16

A dynaset is the set of records that results from a query.

Accepted Answer

The answer of A dynaset is the set of records...

Question 17

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

Accepted Answer

When referential integrity is enforced in a one-to-many relationship in Microsoft Access, you can delete a record from the "many" side without violating referential integrity rules, as this action does not leave orphan records in the "one" side table.

Question 18

It is not necessary to spell accurately or correctly when creating queries in Microsoft Access because such matters as case or spelling are corrected automatically by the system's spell checker.

Accepted Answer

The answer of It is not necessary to spell accurately...

Question 19

Using Microsoft Access to create a select query with multiple criteria (all of which you want satisfied at the same time), you should specify them on separate Criteria lines of the query.

Accepted Answer

When creating a select query with multiple criteria in Microsoft Access, you should specify them on separate Criteria lines of the query to ensure that all criteria are satisfied at the same time.

Question 20

Validation rules are useful to prevent data entry errors in databases.

Accepted Answer

The answer of Validation rules are useful to prevent data...

Quiz 15: Organizing and Manipulating the Data in Databases