Lesson 11

Module Conclusion: Table Manipulation in Microsoft Access

In this module, you built practical skills for working with tables in Microsoft Access—both how a table is designed (Design View) and how data is entered and maintained (Datasheet View). You also applied rules that improve data quality (choosing correct data types, applying input masks, defining primary keys) and learned how these design choices directly affect how reliable your database becomes as it grows.

The workflow pages in this module were refactored into a continuous learning sequence. Each page focuses on a core table task and builds toward the next stage of database development: creating relationships between tables so you can build queries, forms, and reports that combine data across your database.

What you accomplished in the workflow

The module’s workflow pages form a complete progression—from understanding how Access presents table data to enforcing integrity rules. Use this list as your review checklist:

Introduction to table manipulation
You established the purpose of Datasheet View vs. Design View and why table structure matters before you start entering large amounts of data.
Using Design View effectively
You learned how fields, data types, and field properties define what Access allows users to store—and how that affects forms and queries later.
Selecting correct field data types
You reviewed common types (Short Text, Number, Date/Time, Currency, Yes/No, AutoNumber, Hyperlink) and when each should be used to prevent invalid input.
Changing a field’s data type safely
You learned to change data types with awareness of conversion risk (for example, text-to-number or date conversions) and the importance of backing up data first.
Limiting format with Input Masks
You used the Input Mask Wizard to enforce patterns (such as phone numbers, postal codes, or IDs) and distinguished input masks (format control) from validation rules (logic control).
Selecting fields and records
You practiced selecting records, fields, and multiple columns in both Datasheet and Design views—skills required for editing, formatting, and structural changes.
Adding and deleting fields
You modified table structure by inserting new fields and removing fields, and you learned why deletes are destructive (field removal deletes all values stored in that field).
Creating hyperlinks in a table
You created and edited Hyperlink fields and learned safe editing techniques (Edit Hyperlink dialog or F2) to avoid accidentally activating the link.
Reordering fields by moving columns
You moved fields in Datasheet View (layout) and in Design View (schema order), then saved changes so the default field order matches how you want users to work.
Choosing and defining a primary key
You learned why every table should have a primary key, how Access enforces uniqueness and non-null rules, and when AutoNumber is the preferred approach.

Key terms and concepts

This module introduced and reinforced the following terms:

Datasheet View
Design View
Data type
Input mask
Hyperlink
Primary key

Modern guidance for Access 365 users

Prefer prevention over cleanup: choosing the correct data type and adding a key/index early prevents expensive cleanup work later.
Use Input Masks for format, Validation Rules for logic: masks guide how data is typed; validation rules enforce business meaning.
Back up before schema changes: changing data types or deleting fields can cause irreversible data loss if conversion fails or values are removed.
Use AutoNumber keys for most tables: they are stable, compact, and ideal for relationships; enforce business identifiers separately with unique indexes when needed.

In the next module, you will learn how to create table relationships so that queries, forms, and reports can combine data from multiple tables.

Access Field - Quiz

Before moving on, take the multiple-choice quiz to check your understanding of the lessons in this module.
Access Field - Quiz