Inserting table fields and data types in Microsoft Access 2019

When creating a table, field size is extremely important. Field sizemeans the number of characters allocated to each field. If we allocate50 characters to a field size, but we know there will be no more thanfive characters per field when inputting data, then the database isgoing to be larger than we need and the effect on performance (slower)will be huge. Spaces should not be used to separate a field name if itconsists of more than one word. Rather, use uppercase letters todifferentiate between the words, as in the following example.

A data type must be assigned to each field in a table. The datatype determines what kind of data can be entered and stored in a singlefield. It also has a big effect on what can be done to the data once thedata type has been assigned. For instance, if you are going to use thefield to perform calculations, then the number data type will be used.Each data type will have its own restrictions so be sure to check outthe field properties at the bottom of the Design View pane:

  1. Open the EnrolledStudentsTbl table in Design View.
  2. Type a field name into the space provided. 
  3. Assign a data type to the field name by selecting a type from thedrop-down list in the Data Typecolumn.
  4. Press Tab on the keyboard to move to the description fieldor tab again to move to the next field to be entered:
ms office 250
  1. Enter the field names and data types as per the example in thepreceding screenshot to complete the table fields, then save thetable.

Planning your database prior to physically working in Access isextremely important. If you change the data type once the database isset up, a loss of data can occur.

Leave a Comment