Zara should use a form to display one record at a time on her screen. True False

Question

Zara should use a form to display one record at a time on her screen.

True

False

A primary key uniquely identifies each record in a table.

True

False

A filter is used to arrange records in either ascending or descending order.

True

False

Excel worksheets can be imported into an Access database as new tables.

True

False

Referential integrity is a set of rules that prevents changes from being made to records that are related to other records.

True

False

1.Which database object is best for viewing and editing one record at a time?

Table

Form

Query

Report

2.What are short text, hyperlink, and numeric examples of?

Primary keys

Records

Queries

Data types

3.Which feature is used to display a subset of records?

Sort

Form

Property sheet

Filter

4.An Access relationship occurs between which of the following?

Tables

Forms

Queries

Reports

5.Breaking the field Name into two smaller fields, Firstname and Lastname, is part of which process?

Referential integrity

Establishing a relationship

Data normalization

None of these options

1.The names, addresses, and phone numbers for 5,000 customers are stored in a database as which of the following?

5,000 fields

5,000 records

5,000 tables

A single object

1.The names, addresses, and phone numbers for 5,000 customers are stored in a database as which of the following?

5,000 fields

5,000 records

5,000 tables

A single object

Explanation / Answer

1. Zara should use a form to display one record at a time on her screen.

True

False

Answer: True

Forms are used to display and edit one table record at a time on the screen.

-----------------------------------------------------------------------------------------------------------------------------------

2. A primary key uniquely identifies each record in a table.

True

False

Answer: True

it is a property of primary key that it uniquely identifies each record of a table.

-----------------------------------------------------------------------------------------------------------------------------------

3. A filter is used to arrange records in either ascending or descending order.

True

False

Answer: False

The filter in excel is used to filter data based on the user's given condition.

-----------------------------------------------------------------------------------------------------------------------------------

4. Excel worksheets can be imported into an Access database as new tables.

True

False

Answer: True

we have a method by which we can import excel data to access the database as a new table

-----------------------------------------------------------------------------------------------------------------------------------

5. Referential integrity is a set of rules that prevents changes from being made to records that are related to other records.

True

False

Answer: True

Referential integrity refers to the foreign key of another table. so it prevents changes from being made to records that are related to other records.

-----------------------------------------------------------------------------------------------------------------------------------

6. Which database object is best for viewing and editing one record at a time?

Table

Form

Query

Report

Ans: Form

Form is used Form is used for viewing and editing one record at a time

----------------------------------------------------------------------------------------------------------------------------------------

7.What are short text, hyperlink, and numeric examples of?

Primary keys

Records

Queries

Data types

Ans: Data Types

short text, hyperlink, and numeric are data types

--------------------------------------------------------------------------------------------------------------------------------------

8.Which feature is used to display a subset of records?

Sort

Form

Property sheet

Filter

Ans: Filter

Filtering is used to display the subset of records.

--------------------------------------------------------------------------------------------------------------------------------------

9.An Access relationship occurs between which of the following?

Tables

Forms

Queries

Reports

Ans: Tables

Access relationship occurs between different tables.

--------------------------------------------------------------------------------------------------------------------------------------

10. Breaking the field Name into two smaller fields, Firstname and Lastname, is part of which process?

Referential integrity

Establishing a relationship

Data normalization

None of these options

Ans: Data normalization

Data normalization is the process of breaking the field into smaller fields.

--------------------------------------------------------------------------------------------------------------------------------------

11. The names, addresses, and phone numbers for 5,000 customers are stored in a database as which of the following?

5,000 fields

5,000 records

5,000 tables

A single object

Ans: 5,000 records

--------------------------------------------------------------------------------------------------------------------------------------

Related Questions

Navigate

• Browse (All)
• Browse Z
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.