910142058

What is the main purpose of a composite primary key in a table?

to uniquely identify a record using two or more fields

Which properties can be defined for a lookup field in Access?

- Row Source - Limit to List - Column Heads

What is the primary purpose of Information Systems in business?

To facilitate the processing of data into useful information

What actions are necessary to create a relationship between two tables in Access?

- Link the tables through the Relationships window - Define a primary key - Locate foreign key

What data type is used to store text up to 255 characters?

Short Text

An operating system like Windows or Linux is an example of what component of an information system?

Software Component

What data type stores large blocks of text?

Long Text

What data type automatically generates unique values for each record?

Autonumber

What data type stores monetary (relating to money) values?

Currency

A foreign key can have duplicate values in a table. True or False

True

What is known as a request for information from a database?

Query

The Date() function is most appropriately used as a default value when...

Setting the current date as a default for new orders

Sorting records in descending order means arranging them from the smallest to the largest value. True or False

False

Which property should be set to ensure that a Number field cannot be left blank?

Required

Enforcing referential integrity prevents the deletion of records in a primary table that are related to records in a foreign table. True or False

True

The Date() function can be used to set a default value for a short text field. True or False

False

The Allow Zero Length property is relevant ONLY for text fields.

True

Information systems are only used for processing financial data in businesses. True or False

False

Which data type would be most appropriate for storing a large block of descriptive text?

Long Text

Which of the following best defines a primary key?

A unique identifier for each record in a table

An object that allows you to retrieve records that meet specific conditions.

Query

A field in one table that links to a primary key in another table.

Foreign Key

An object that stores data in a database.

Table

A unique identifier for each record in a table.

Primary Key

IT and IS are essentially the same thing. True or False

False

Zach follows the instructions that show him how to create a custom Web site in his school's learning management system. These steps that he follows are examples of what component of an information system?

Procedures component

What file property automatically fills in a value for a new record?

Default Value

What field property displays a message when the data entered does not meet the criteria?

Validation Text

What field property ensures a field is not left empty?

Required

What field property sets criteria for data entered into a field?

Validation Rule

What property should be used to automatically fill in a value for a field when a new record is created?

Default Value

Name the table relationship: Each record in Table A can have multiple matching records in Table B

One to Many

Name the table relationship: Each record in Table A matches exactly one record in Table B

One to One

Name the table relationship: Multiple records in Table A can match multiple records in Table B

Many to Many

The Lookup Wizard can only be used with text fields. True or False

False

What is the file extension for Access Database?

.accdb

What is the file extension for Excel?

.xlsx

What is Text file extension?

.csv

What is the file extension for XML?

.xml

Setting the "Allow Zero Length" property to Yes ensures that an empty string is allowed in a text field. True or False

True

Which property should be set to ensure that a Number field cannot be left blank?

Required

What actions are necessary to create a relationship between two tables in Access?

- Define a primary key - Link the tables through the relationship window - Set a foreign key

What does the Date() function return when used in a default value expression in Access?

The current date

Which property specifies the text that appears as a column heading in datasheet view?

Caption

What is the primary purpose of using the Lookup Wizard in Access?

To create a dropdown list for a field

What are the CORE components of an information system in order from easiest to most difficult to change?

1. Hardware 2. Software 3. Data 4. Procedures 5. People

Enforcing referential integrity prevents the deletion of records in a primary table that are related to records in a foreign table.

True

What is the first step when importing data from an Excel file into an Access database?

Selecting the source file

When is the Date() function most appropriately used as a default value?

- Setting the current date as a default for new orders - Tracking when a record was created

Which property would you adjust if you want the field names to appear in a multi-field lookup?

Column Heads

In what scenarios would a composite primary key be necessary?

- tracking multiple editions of the same book - tracking employee enrollments into training classes - defining relationships between tables

A composite primary key uses two or more fields in a table to create a unique identifier. True or False

True

What language is used to manage and manipulate data in a relational database?

SQL (Structured Query Language)

What is the process of organizing data to minimize redundancy and improve data integrity?

Normalization

Which field property would you use to restrict data entry to numbers only between 1 and 100?

Validation Rule

What are the steps in the correct order to filter records where JoinDate is after 01/01/2024.

1. Open the table 2. Select the JoinDate column heading 3. Specify the criteria "After 01/01/2024" 4. Apply the filter

What can be used as a source for a lookup field created by the Lookup Wizard?

- A manually entered list of values - A query - A table

What type of relationship exists between a "Customers" table and an "Orders" table where each customer can place multiple orders?

One to Many

The Lookup Wizard can only be used with text fields. True or False

False

Which field property determines how data are displayed in a field?

Format

What techniques can be used to locate a specific record in a large table?

- Filtering - Sorting

What properties constrain data entry into a field, which is important for maintaining data integrity in an Access table?

- Required - Allow Zero Length - Validation Rule

The "Limit To List" property restricts user input to the values specified in the Row Source of a lookup field. True or False

True

What actions are prevented when referential integrity is enforced?

- Deleting a record in the primary table that has related records in the foreign table - Adding a record to the foreign table with no related record in the primary table - Updating the primary key in the primary table when related records exist