K204 Exam 1

February 3rd test for K204 on chapters 3-7

Microsoft Access is primarily classified as what type of RDBMS?

Desktop

Adapting new technology creates what competitive advantage

Low-Cost leadership

Normalization

Reduce redundancy, simplify updates

.laccdb file

When database is open, normal

Open-source RDBMS widely used in the web apps

MySQL

.laccdb file characteristics

Lock file created while database is open

Yes/No

0 = false, -1 = true

Currency

Money, up to 4 decimal places

Validation Rule

What values are allowed

Validation Text

Error message

Required

Field cannot be empty

Caption

Human-readable label

Indexed

Faster searching

TPS

Day-to-day transactions, raw operations

MIS

Routine reports, summaries

DSS

Complex decision-making

Information Order

Data Information Knowledge Wisdom

Composite Primary Keys

Saving Work

Syncs changes to cloud storage

Closing the File

Needed when editing/creating objects

Default Value

automatically appears in new records