Unit 5 revision - Microsoft Access

Which Of The Following Is Not A Type Of Microsoft Access Database Object

• A) Table

• B) Form

• C) Report

• D) All of the above applied

What Are The Columns In A Microsoft Access Table Called

• A) Rows

• B) Records

• C) Fields

• D) Columns

What Is The Maximum Length A Text Field Can Be?

• A) 522

• B) 255

• C) 265

• D) 50

What is a report in MS Access

• A) It is a printed page where users can display data

• B) It is an input screen designed to make the viewing and entering data easier

• C) This is an important part of database used by analysts to draw conclusions

• D) All of above

What Are The Different Views To Display A Table?

• A) Datasheet View

• B) Design View

• C) Pivote Table & Pivot Chart View

• D) All Of Above

To create relationship between two tables

• drag the primary key of a table into the primary key of another table

• drag any field from parent table and drop on child table

• drag the primary key of a table into foreign key of another table

• Any of above can be done to create relationship

What happens when you release mouse pointer after you drop the primary key of a table into foreign

• A) A relationship is created

• B) Edit relationship dialog box appears

• C) Error occurs

• D) Nothing happens

The Third Stage In Designing A Database Is When We Analyze Our Tables More Closely And Create A ___________ Between Tables

• relationship

• join

• query

• none of the above

If you write criteria values vertically (one in a row) it will mean

• OR conditions

• AND conditions

• NOT condition

• None of above

In A Database Table, The Category Of Information Is Called

• Tuple

• field

• record

• all of the above