More Common Database Tasks

View a table in design mode

Right click the table, query, form or report in the relevant area and select ‘Edit’

This will open the table, query, form or report in a design mode window

8 Design Mode

Navigate between records in a table, query, form

9 Navigation

Use the navigation toolbar to navigate between records in a table, query or form.

Use the number entry box to jump straight to a specific record by typing the number and pressing the enter key.

Click the ‘Next Record’ and ‘Previous Record’ arrows to move one record at a time.

Use the ‘Last Record’ or ‘First Record’ arrows to skip to first or last record in the table, query or form.

Sort records in a table, form, query output

10 Sort Records

Click the ‘Sort’ icon in the navigation toolbar to sort records in a table, query or form.

Choose the Field you want to sort the records by, from the ‘Field name’ drop down menu.

Select either ascending or descending from the ‘Order’ drop down menu.