A description of a particular collection of data, using the a given data model.

Ability to change the logical structure of data without affecting the external schema.

Protection from changes in logical structure of data

Responsible to handles security and authorization

Responsible to handles security and authorization

Define and implement database schemas based on system requirements.

An rganization that develops and provides database management systems (DBMS) — the software used to store, organize, and manage data.

a person who uses the data stored in a database to perform specific tasks or make decisions, but does not necessarily design or manage the database system itself.

Used to interact with the database (create, read, update, delete data).

Translates database access languages into operations.

Raw facts stored in structured or unstructured formats.

Information that can be analyzed and processed to extract meaning.

Ensures that users follow established guidelines while interacting with the system.

An object or “thing” we want to store information about.

The performance of MS Access get fast with very big datasets or many users

The details or properties that describe the entity.

A group of entities that share a common characteristic.

It illustrates how different entities interact with one another

Can MS Access connect with applications outside of the MS Office suite?

Identify what key constraint teh below relationship:

Car – Registration Certificate

Identify what key constraint teh below relationship:

Library – Books

Identify what key constraint teh below relationship:

Products – Orders

Identify what key constraint teh below relationship:

Vehicle → GPS Tracker

Identify what key constraint teh below relationship:

Movies ↔ Actors

Identify what key constraint teh below relationship:

Students ↔ Organizations

Identify what key constraint teh below relationship:

Videos → Content Creator

Identify what key constraint teh below relationship:

Warehouse → Inventory Items

Identify what key constraint teh below relationship:

Course → Lessons

Identify what key constraint teh below relationship:

User Account → Two-Factor Authentication Setup

Which Access object best allows the automation of data entry validation across multiple related tables?

Which Access object is primarily used to summarize and print information for decision-making?

When designing a table, what field property ensures that no two records can have the same value?

When enforcing referential integrity between two tables, which of the following actions is not allowed by Access?

What happens when a relational database in Access exceeds its optimal storage limit (around 2GB)?

A form is created to update customer information. To prevent duplicate records, what should be enforced at the table level?

What specific Access component manages data types, field sizes, and input rules?

Identify the properties of each field

The different categories within the tables

A collection of data about specific topic