Office Software

Change arrangement of data fields and headings in a report Click ‘Reports’ from the Database area of the main window and right click the report you want to change in the Reports area. Click ‘Edit’ from the drop down menu. To move fields and labels, simply click and drag individually to move them around the…

To create a two-table query, first make sure you have created a second table. The two-table query will use the ‘Company employees’ table created in a previous tutorial. Use the table design view to create a table containing personal phone numbers for home and mobile Once created and saved, you need to create a relationship…

Queries are used to extract and analyse data from tables. Click on the Queries icon, then select Create Query in Design View. The single table query will use the ‘Company employees’ table created in a previous tutorial. In the ‘Add Table or Query’ window, click the table(s) you want to extract data from, click ‘Add’,…

Use the search command to find specific data in a field This tutorial demonstrates how to find specific records within a table. This won’t cover forms or reports, which can do the same thing but display the data in a different (more user-friendly) format. Sometimes you may want to just quickly check data within a…

Set a field as primary key To set the primary key, right-click the grey box to the left of the field you want to set as primary key. Check the ‘Primary Key’ option and a yellow key symbol will appear in the grey box. It’s a good idea to set the primary key to an…

Create a table To create a table, click ‘Tables’ in the Database area. Then click ‘Create Table in Design View’ from the Tasks area to open table design window. In this example, we’re going to create a table that holds data on company employees. It will contain basic details on employees such as name, gender,…

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…

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…

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.…

AND A logical operator that is used in queries to state that values must satisfy all of the set criteria. Autovalue A feature that can be attributed to data under a certain field (often the primary key) of a table that will automatically create a unique number for each entry. Best used with ‘integer’ data…