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.
Clicking the Design view icon will switch you to the
Design view of the table or query.
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.
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.
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.
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.
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.
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.