Access - set up and queries

Microsoft's version of a Database Management System

• Excel

• Access

• PowerPoint

• Word

A Primary Key is a code that uniquely identifies a _____________ in a Database.

• Field

• Text

• Record

• Number

Answer explanation

In its simplest foirm a primary key is a field (Column) or combination of Fields (columns) which uniquely identifies every row.

 

In a database table, rows are called __________

• Field

• Text

• Number

• Record

Tables are used to create....

• Queries

• Reports

• Queries and Reports

To sort from the smallest to the largest (from A to Z and 0 to 9)

• Ascending

• Descending

• Sort

• Advanced Sort/Filter

A table is divided into __________________

• field and form

• Datasheet and dataview

• Field and Record

• Record and Form

In Microsoft Access, a field labelled “Price” should be formatted as

• Number

• Currency

• Short Text

• Auto number

Truncate means

• You cannot see all text because column is too narrow

• You cannot see all text because column is too wide

• The data on page header and field detail are not aligned

Which tab do you use to create Queries and Reports?

• Home

• Create

• External Data

• Table

Which tab do you use to export a table or Query to Word?

• Home

• Create

• External Data

• Table