Review Test 4 – Access Tutorials 1-3

25 tasks, 25 Multiple Choice/Short Answer questions

Add a table to a query

Build an expression in a query

Create a new database

Create a new datasheet

Create a new query

Use the Simple Query Wizard

Change data type in design view

Remove & add a field from a table

Remove record from a database

Change format of a field in a query

Go to different records in a table

Open a database

Specify a primary key

Create a relationship between tables using referential integrity

Create a query with criteria

Sort values in a table ascending & descending

Specify sort in a query

Definition of database

Steps in creating a database

Definition of primary key

What is a query, form, report – when to use each

ID column

Data redundancy

Field properties

Field types

Null value

Query show box

QBE

One-to-many relationship

Filter

AND & OR operators