Understanding Databases – Tables & Records

Add or delete records in a table To add a record, click a cell in the table. Enter valid data into the cell, for instance, for Start Date, make sure you enter it in a date format. If you move down to the next row, and the ID is set to Integer auto-value, the next…

Read More

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 Navigate between records in a table, query, form Use the navigation toolbar to navigate between records in a table, query…

Read More

Common Database Tasks

Tables Tables are used to store records (pieces of data) within a database. Records are entered into tables under fields that are created when editing the table. Fields are similar to the headings given to columns in a spreadsheet. An unlimited number of tables can be created in a database, containing different types of data.…

Read More