Sort Search and Linking two Tables

What is the purpose for SORT and SEARCH operations?

• To arrange data records in different ways

• To reduce number of records displayed

• To put records in alphabetical order

• To look for one record within table

SEARCH operation will usually

• Display records for which matching criteria is not true

• Reduce number of records displayed

• Drop records for which matching criteria is true

• Look for one specific field

SORT operation will never reduce number of records displayed within database.

• True

• False

Search criteria to display records where DOB is: <= 01/01/2000 AND >= 31/12/2000 will display records with dates between:

• 1st of January and 31st of December 2000

• 2nd of January and 30th of December 2000

• None

• All dates before 1st of January 2000

What is the purpose of setting second SORT criteria for the same data table?

• To have all data records sorted in two ways

• To confuse everybody

• To spend more time working on database

• To sort records with identical values only after performing first sort

What two tables need to have to be linked?

• At least one same record

• Same table names

• Common column

• Many to many relationship

What is the name of common column which is used to link two tables together?

• Primary Key

• House Key

• Foreign Key

• Relationship Key

Foreign Key is:

• Primary Key column for one of the two linked tables and one of the column name inside another which acts as a connector between them.

• Key to understand data table written in different language

• Not well understood concept in Database Development

• Column which holds unique values for every record in database

One to many relationship between table is when:

• Many records of table 1 can match one or more records in table 2

• Yes

• Single record in first table can be repeated within one or many records inside second table

• Table picks which other table is the best to be related to

To set up relationship between tables in Microsoft Access you need to go to:

• Create New Query Design

• Insert tab

• Database Tools tab

• inside Design View