Database: How do I…

1. Switch between Design view and Datasheet view

To switch between views you can toggle between the Design view and Datasheet view icon on the Home ribbon.

Design View icon MS Access

Clicking the Design view icon will switch you to the
Design view of the table or query.

 

Datasheet-view

Clicking the Datasheet view icon will switch you back
to the Datasheet view of the table or query.

 

2. Change the field size of a text field.

  • Click on the relevant field in Design view of the table.
  • In the General tab of the Field Properties box click in the box next to field size, delete 255 and type in your required amount.
  • Save the changes.

FieldSizes

 

 

 

 

 

 

 

3. Set a default value on a field

If you want the same text to appear in a field of a table, for example, a county field, you can set a default value on that field.

  • In Design view of the table select the relevant field.
  • In the Field properties click in the Default value box and type the relevant text.
  • Click save.

Default value

 

 

 

 

 

 

4. Set a field as a Primary Key

  • In Design view of the table select the field you wish to be the Primary Key
  • Click the Primary Key icon on the Tools group on the Design ribbon.
  • The field is now set as the Primary Key.  You will notice a key icon beside the field name.
  • To remove the Primary Key click the icon again to switch it off.

Primary Key

 

 

 

 

 

 

 

 

5. Remove a Primary Key

  • In Design view of the table select the field with the Primary key attached.
  • Click the Primary Key icon to remove the Primary Key.

Primary Key_off

 

6. View all Access objects in the table of the database

  • When a table is opened in a database, a navigation panel appears to the right of the screen.
  • Set the panel to show All Access objects by clicking on the drop down arrow at the top of the navigation panel.

All Objects

 

 

 

 

 

 

 

 

 

7. Change the field width of a table in a database by a fixed amount

See the video below on how to do this task.

 

8. How to move or re-order fields in a database table

See the video below on how to do this task.