K204 Chapter 3-6 Exam Study Set

Field Size

Controls the maximum number of characters or the magnitude/precision of a number.

Decimal Places

Specifies the number of decimal places to use for a Number or Currency field.

Format

Controls how numbers, dates, times, and text are displayed.

Which of the following statements are true regarding the Indexed property? (Select all that apply)

It can be beneficial for fields frequently used in joins between tables;

It can speed up searches and sorting operations;

If set to "Yes (No Duplicates)", it prevents duplicate entries in that field.

.laccdb file

Essential to preventing unwanted changes by another user and usually disappears when the database is closed.

Saving Work

Needed often when editing the structure of a database file or creating new objects.

Closing the File

Ensures saved changes sync back to cloud storage and provides access to the most up-to-date version.

What is the main purpose of selecting appropriate data types for fields in a relational database?

To streamline storage, boost performance, and ensure data integrity.

If you see an additional Access icon with a padlock and a .laccdb extension, what does it signify?

It is a lock file, essential for preventing unwanted changes by others.

What is the main benefit of information systems in terms of operational efficiency?

Automating everyday tasks and reducing errors

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

SQL

What does the "network effect" imply about digital platforms?

Their value increases as more people use them.

Transaction Processing Systems (TPS)

Handles the day-to-day basic business transactions that keep a company running.

Decision Support Systems (DSS)

Helps managers make better decisions for complex or non-routine problems, often interactively.

Management Information Systems (MIS)

Takes data from TPS and turns it into useful, structured reports for routine management.

What is the primary function of a database management system (DBMS)?

To efficiently retrieve, manage, and update data in a database.

According to the data-to-wisdom hierarchy, which of the following are higher levels than "data"? (Select all that apply)

Knowledge

Information

Wisdom

When the Field Size property is adjusted for a Short Text data type, it specifies the maximum number of characters allowed.

True

What is the primary benefit of data-driven decision-making?

Reducing risk and uncertainty by using evidence

Product/Service Differentiation

Using technology to make offerings stand out from competitors.

Low-Cost Leadership

Employing sophisticated systems to manage supply chains and keep costs lower.

Early Adoption of Technology

Establishing market dominance and lasting advantages by being the first to use new tech.

In a one-to-many relationship, such as between tblEmployee and tblTransaction, how many transactions can one employee process?

Any number of transactions.

New Values

Controls whether the AutoNumber field increments sequentially or randomly.

Allow Zero Length

Determines if a zero-length string ("") is a valid entry for a text field.

Indexed

Speeds up searches and sorts.

Yes/No

Boolean (true/false) data values, stored as 0 for false and -1 for true.

Long Text

Longer alphanumeric values like sentences and paragraphs.

Short Text

Alphanumeric values (letters, numbers, and other symbols).

Foreign Key

Establishes a relationship between two tables by linking to another table's primary key.

Primary Key

A unique identifier for each record in a table.

SQL is a language used for managing and manipulating data in relational databases.

True

People

The users who interact with the system, including employees and customers.

Software

The programs and instructions that tell the hardware what to do.

Hardware

The physical equipment used in the system, such as computers and printers.

Which of the following RDBMS is described as an "open-source relational database management system widely used in web applications"?

MySQL

What benefits are associated with using relational databases? (Select all that apply)

Improved data integrity and accuracy.

Simplified maintenance.

Reduced data redundancy.

What is the main purpose of the Required property for a field?

To ensure that a value must be entered in the field for every new record.

What is the primary role of an information system in an organization?

To bridge the gap between technology and organizational needs

In a relational database, conceptually, a many-to-many relationship can be directly executed without using an intermediate table.

False

What do Transaction Processing Systems (TPS) primarily focus on?

Processing day-to-day basic business transactions

How do Management Information Systems (MIS) differ from Transaction Processing Systems (TPS)?

MIS provides structured reports for routine management decisions, while TPS processes daily transactions.

Microsoft Access is primarily classified as what type of RDBMS?

Desktop (personal) RDBMS

What type of database object is used to store and display data in rows (records) and columns (fields)?

Table

Which of the following are benefits of using field properties in a relational database? (Select all that apply)

Ensuring data integrity.

Improving data entry accuracy.

Enhancing data display and readability.

Optimizing storage space.

Microsoft Access is ideal for managing very large datasets with thousands of concurrent users.

False

What is metadata in the context of a relational database table?

Information about the data and the structure of the table, including field names, data types, and keys.

Which of the following is not one of the five components of an information system?

Algorithms

What is the primary function of field properties in a relational database?

To define how data is stored, entered, and displayed for each field.

Which of the following business values of information systems is primarily concerned with personalizing offerings and improving customer service?

Customer Value Creation

Which field properties are available for Short Text data types?

Input Mask

Field Size

Format

Caption

A company using a system to track customer issues and quickly solve them is an example of an information system contributing to which business value?

Customer Value Creation

In a relational database, conceptually, a many-to-many relationship can be directly executed without using an intermediate table.

False

Which of the following applications is least likely to rely on databases according to the text?

A standalone word processing application without online features

Data-driven decision-making completely eliminates all risk in business choices.

False

Which data type in MS Access is specifically designed to store monetary data with up to 4 decimal places of precision?

Currency

MySQL

An open-source RDBMS widely used in web applications, known for reliability and ease of use.

Microsoft Access

A desktop RDBMS with a graphical user interface, commonly used for small to medium-sized solutions and personal projects

Oracle

A powerful, enterprise-grade RDBMS known for robustness and large-scale data processing in big enterprises.

What is the primary purpose of data quality in data management?

To ensure data is accurate and reliable

Scalability and Flexibility

Allows easy modification and scaling without disrupting existing schemas, enhancing reusability.

Efficient Data Retrieval through Queries

Allows complex data requests across multiple tables and enables faster access with indexing.

Improve Data Integrity and Accuracy

Ensures data remains consistent and accurate by minimizing update, insert, and delete anomalies.

The Validation Text property works independently and does not require a Validation Rule to be set.

False

Which component of an information system refers to the raw facts and figures collected and processed by the system?

Data

What is a query in the context of a database?

A request for information from a database.

Which of the following are recognized business values of information systems? (Select all that apply)

Decision-Making Enhancement

Strategic Alignment

Operational Efficiency

Financial Performance

Customer Value Creation

When creating a composite primary key in MS Access, which of the following statements are true? (Select all that apply)

Neither of the individual fields can be used as a primary key on its own if they contain non-unique values.

It can be used to enforce business rules, such as preventing duplicate enrollments.

It combines the values of two or more fields to serve as one unique identifier.

Which of the following statements are true regarding the Indexed property? (Select all that apply)

If set to "Yes (No Duplicates)", it prevents duplicate entries in that field.

It can be beneficial for fields frequently used in joins between tables.

It can speed up searches and sorting operations.

The Field Size property can be applied to all data types in Microsoft Access.

False

Information systems can help businesses adapt quickly to new situations, such as shifting to online sales during a pandemic.

True

What are some of the advantages of using Microsoft Access? (Select all that apply)

Suitable for rapid development and prototyping of database applications.

Seamless integration with other Microsoft Office applications.

User-friendly interface with templates and wizards.

Validation Text

Specifies the error message displayed when data violates the validation rule.

Validation Rule

Defines criteria that must be met for data to be accepted into the field.

Which of the following are examples of how information systems can change industries? (Select all that apply)

Helping businesses reach new, previously inaccessible markets

Allowing businesses to connect directly with customers, bypassing middlemen

Creating barriers to entry for new competitors

Creating new business models