Skip to content

We use essential cookies to sign you in and remember your settings. With your permission we also use analytics cookies to understand how the site is used. See our privacy policy or fine-tune this anytime at cookie settings.

SubjectPaid lesson

DATA MODELING II

ClassNotes Team 5 MIN READUPDATED 15 JUN 2026

DATA PROCESSING SSS2 FIRST TERM   

WEEK 5

DATA MODELING II

Contents

Editing data type in fields

When creating tables, you should define the data types of the table to most closely match the type of data that will be entered in the field.

To edit data type in Datasheet view.

  1. Click the field you wish to define.
  2. Click the Datasheet tab on the Ribbon.
  3. Click the down arrow next to the Data type.
  4. Choose the type of data that will be entered into the field.

To edit the data of the format,

  1. Click the field you wish to define.
  2. Click the datasheet tab on the ribbon.
  3. Click the down arrow next to the format.

To edit Data type in the…