S4 Microsoft Access Practice Exercise I

What Are The Different Views To Display A Table
1. Datasheet View
2. Design View
3. Pivote Table & Pivot Chart View
4. All Of Above
Which Of The Following Creates A Drop Down List Of Values To Choose
From?
1. Ole Object
2. Hyperlink
3. Memo
4. Lookup Wizard
The Command Center Of Access File That Appears When You Create Or Open
The Ms Access Database File.
1. Database Window
2. Query Window
3. Design View Window
4. Switchboard
The Third Stage In Designing A Database Is When We Analyze Our Tables
More Closely And Create A ___________ Between Tables
1. Relationship
2. Join
3. Query
4. None Of These
In A Database Table, The Category Of Information Is Called __________
1. Tuple
2. Field
3. Record
4. All Of Above
This Key Uniquely Identifies Each Record
1. Primary Key
2. Key Record
3. Unique Key
4. Field Name
It Is An Association Established Between Common
1. Line
2. Relationship
3. Primary Key
4. Records
This Is The Stage In Database Design Where One Gathers And List All the Necessary Fields For The Database Project.
1. Data Definition
2. Data Refinement
3. Establishing Relationship
4. None Of The Above
Database Language Concerned With The Definition Of The Whole
Database Structure And Schema Is ________
1. DCL
2. DML
3. DDL
4. All the above
Which Of The Field Has Width 8 Bytes?
1. Memo
2. Number
3. Date/time
4. Hyperlink
Which Of The Following Statement Is True?
1. Foreign Key Fields Don\'t Allow Duplicate Values
2. In Primary Key Field You Can Enter Duplicate Value
3. In An Indexed Field You May Or May Not Enter Duplicate Value
  Depending Upon Setting
4. All Statements Are True
Following Is Not A Database Model
1. Network Database Model
2. Relational Database Model
3. Object Oriented Database Model
4. None
Microsoft Access Is A
1. RDBMS
2. OODBMS
3. ORDBMS
4. Network Database Model
DCL Provides Commands To Perform Actions Like
1. Change The Structure Of Tables
2. Insert, Update Or Delete Records And Data Values
3. Authorizing Access And Other Control Over Database
4. None Of Above
The Database Language That Allows You To Access Or Maintain Data In A
Database
1. DCL
2. DML
3. DDL
4. None Of Above
What Is The Maximum Length A Text Field Can Be?
1. 120
2. 255
3. 265
4. 75
Which Of The Following Is Not A Database Object?
1. Tables
2. Queries
3. Relationships
4. Reports
A __________ Enables You To View Data From A Table Based On A
Specific Criterion
1. Form
2. Query
3. Macro
4. Report
What Are The Columns In A Microsoft Access Table Called?
1. Rows
2. Records
3. Fields
4. Columns
Which Of The Following Is Not A Type Of Microsoft Access Database
Object?
1. Table
2. Form
3. Worksheets
4. Modules