Unit 5 revision - MS Access/ Database

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

• A) Table

• B) Form

• C) Worksheets

• D) Modules

What Are The Columns In A Microsoft Access Table Called

• A) Rows

• B) Records

• C) Fields

• D) Columns

Which Of The Following Is Not A Database Object?

• A) Tables

• B) Queries

• C) Relationships

• D) Reports

What Is The Maximum Length A Text Field Can Be?

• A) 120

• B) 255

• C) 265

• D) 75

The Database Language That Allows You To Access Or Maintain Data In A Database?

• A) DCL

• B) DML

• C) DDL

• D) None Of Above

DCL Provides Commands To Perform Actions Like

• A) Change The Structure Of Tables

• B) Insert, Update Or Delete Records And Data Values

• C) Authorizing Access And Other Control Over Database

• D) None Of Above

What is a form in MS Access

• A) It is a printed page where users will write their data to fill it up

• 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

In A Database Table, The Category Of Information Is Called

• A) Tuple

• B) Field

• C) Record

• D) All Of Above

This Key Uniquely Identifies Each Record

• A) Primary Key

• B) Key Record

• C) Unique Key

• D) Field Name