IS 201: MS Access | Midterm

What are the objects in an Access database?

• Tables

• Queries

• Forms

• Reports

How is data stored in an Access database?

Structured tables composed of rows and columns.

A data type option used to relate tables as a best practice while the tables are actively being built

Lookup wizard

Determine how data is stored and what operations can be performed on that data.

Data types

Why do you have to choose a data type for each attribute when creating a table with a database management system?

Ensures data accuracy, precise storage, and proper foreign key matching.

What are the general data types available in Access?

• Short Text

• Long Text

• Number

• Date/Time

• Currency

• AutoNumber

• Yes/No

• OLE Object

• Hyperlink

• Attachment

• Calculated

• Lookup Wizard

How do you create relationships between tables in Access?

Dragging a foreign key to a primary key in the Relationships window, or by using the Lookup Wizard during table creation.

How does creating a relationship in the relationship window work?

Drag-and-drop relationships can be done after the tables are already built.

How does and creating relationship in lookup wizard work?

Allows you to relate tables while they are being built.

• Implements a set of rules ensuring data consistency and accuracy so that any foreign key value must either exist in the referenced parent table or be NULL (preventing orphan records).

• It also enables options like cascade updates and deletes.

Enforcing referential integrity

Links the tables together based on keys, but does not strictly enforce these consistency rules or orphan checks.

Creating a relationship

A tool used to format a field so that data appears or behaves in a specific way as users enter it, ensuring that data is entered in the correct format.

Input Mask