GCOM-Microsoft Access Test -5

An Access database object that is used to enter, view or edit records?

1 Mark(s)

Table
Form
Query
Report

A database can be best described as__________?

1 Mark(s)

Organized collection of data
Useful presentation of data
Graphical representation of data
All of above

To create primary key for a table when in design view__________

1 Mark(s)

Type PRIMARY in field type box when creating required field
Mark the Primary check box in field name of required field
Click the Primary Key button in Design ribbon when the cursor is in required field
None of the above

Each record is constituted by a number of individual data items which are called?

1 Mark(s)

Fields
Data Types
Relations
Tables

If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:

1 Mark(s)

Foreign key
Native key
Composite key
Primary key

A part of database that stores only one type of data is__________?

1 Mark(s)

Report
Field
Query
Record

A primary key in any table has the properties?

1 Mark(s)

Not Null
No Duplicates
Both of above
None of above

Collection of related records in a database is known as__________?

1 Mark(s)

File
Bench
Table
Relationship

Which of the following term is least related to database?

1 Mark(s)

Attributes
Tuples
Relationship
Columns

Which of the following may not be a database?

1 Mark(s)

Data presented in table in MS Word document
Data entered in Excel spreadsheet
A presentation created in PowerPoint
A telephone diary

A composite key is________?

1 Mark(s)

Required when a table does not have any unique fields in it
The primary key with AutoNumber as the field type
Made up of two or more fields to uniquely identify records
Is a foreign key that uniquely identifies records

Database Management Systems are featured with:

1 Mark(s)

The facility to easy editing, spelling check, auto pagination, lay out and printing reports
The ability to store large amount of data to facilitate easy update, sort and retrieval
The ability to calculate efficiently with the help of built-in functions and analyze
All of above

The task of arranging data in order is called?

1 Mark(s)

Searching
Sorting
Ordering
Shorting

Which of the following expresses correct order?

1 Mark(s)

Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters

The complete information about an entity in a database is called?

1 Mark(s)

Data
Information
Field
Record

A database object in MS Access that stores a question about the data in database?

1 Mark(s)

Table
Form
Query
Report

Which of the following can be an example of a database?

1 Mark(s)

Address book of all the suppliers of a company
Salary sheet of all the employees of a company
Records of daily sales transactions of a company
All of above

Which of the following is not a database object in MS Access?

1 Mark(s)

Tables
Query
Report
Relationship

Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called_________?

1 Mark(s)

Foreign key
Native key
Composite key
Primary key

How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:

1 Mark(s)

Query Wizard
Look up Wizard
Form Wizard
Report Wizard

GCOM-Microsoft Access Test -5 : Question 1 of 20