Relationships Forms And Queries

Question 1

Relationship

Answer 1

A relationship links two tables in a database using a field that exits in each of the tables, the primary key of the one table will be stored as a foreign key in another table

Question 2

1 to 1

Answer 2

X—————————x

Question 3

1 to many

Answer 3

———
X——————-x
———

Question 4

Many to many

Answer 4

——- ———
X———————x
——- ———

Question 5

Forms

Answer 5

Are a common way to collect data. They can be used to enter a new record , modify an existing record or a view record already stored in a table

Question 6

What are the advantages of creating a data capture form

Answer 6

When different tables makes easier to collect data, database designer can control exactly how the form looks

Question 7

Query

Answer 7

A query is a question used to retrieve selected information from a database . It is used to search for records .

Question 8

=

Answer 8

Equal to

Question 9

Between

Answer 9

Between x and y

Question 10

And

Answer 10

Both must be true

Question 11

Or

Answer 11

One must be true

Question 12

>

Answer 12

Greater than

Question 13

<

Answer 13

Less than

Question 14

> =

Answer 14

Greater than or equal to

Question 15

<=

Answer 15

Less then or equal to

Question 16

How can fields be hidden and sorted

Answer 16

Hiding take away the tick in show
Sorting in ascending or descending order