Lab Quiz 6 Study Guide

Question 1

Fields

Answer 1

Columns

Question 2

Records

Answer 2

Rows

Question 3

Form view

Answer 3

Double click on the form
To add new records - green plus sign at the bottom

Question 4

Design view

Answer 4

Right click on the table > Edit

Question 5

How to add a field in a table

Answer 5

Go to design view and add it, then you can modify the data type

Question 6

How to use “Format Example”

Answer 6

Modify data type by choosing User Defined

Question 7

Primary key

Answer 7

Any field or group of fields that uniquely identifies each record. To set one, right-click on the small space next to the field name then select primary key

You might have to assign more than one primary key

Question 8

Filter

Answer 8

Click the standard filter button.

The auto filter can be used after selecting a record

Question 9

Create a relationship

Answer 9

In the menu bar, click on tools and select relationships

Question 10

Queries

Answer 10

Click on queries then click on create queries in design view. Add necessary tables. For the table boxes that show up, click on the fields within them to get them to show up at the bottom. Then save the query

For numerical you will need to use number specific sorting like >= 3.