Home
Current Affairs January 2024

What is the correct answer?

4

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

A. Table

B. Form

C. Query

D. Report

Correct Answer :

B. Form


Related Questions

What is the correct answer?

4

Which field type can store photos?

A. Hyperlink

B. OLE

C. Both of these can be used

D. Access tables cant store photos

What is the correct answer?

4

What do you mean by one to many relationship between Student and Class table?

A. One student can have many classes

B. One class may have many student

C. Many classes may have many students

D. Many students may have many classes

What is the correct answer?

4

You can set a controls border type to make the border invisible.

A. Transparent

B. Invisible

C. Do not display

D. No border

What is the correct answer?

4

If you need to edit a relationship

A. Right click the relationship line and choose Edit Relationship

B. Double click the relationship line

C. Both of above

D. None of above

What is the correct answer?

4

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

A. Foreign key

B. Native key

C. Composite key

D. Primary key

What is the correct answer?

4

Which of the following store command to retrieve data from database?

A. Forms

B. Reports

C. Queries

D. Tables

What is the correct answer?

4

A database language concerned with the definition of the whole database structure and schema is ________

A. DCL

B. DML

C. DDL

D. All of above

What is the correct answer?

4

Database Management Systems are featured with:

A. The facility to easy editing, spelling check, auto pagination, lay out and printing reports

B. The ability to store large amount of data to facilitate easy update, sort and retrieval

C. The ability to calculate efficiently with the help of built-in functions and analyze

D. All of above

What is the correct answer?

4

Which of the following creates a drop down list of values to choose from a list?

A. OLE Object

B. Hyperlink

C. Memo

D. Lookup Wizard

What is the correct answer?

4

To sort records in a table

A. Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar

B. Open table, click Sort button on database toolbar, choose field based on which to sort, click OK

C. Click the field heading to sort it ascending or descending

D. All of above

What is the correct answer?

4

Which of the following database object produces the final result to present?

A. Forms

B. Reports

C. Queries

D. Tables

What is the correct answer?

4

When entering field name, how many characters you can type in maximum?

A. 60

B. 64

C. 68

D. Any number of character

What is the correct answer?

4

A part of database that stores only one type of data is

A. Report

B. Field

C. Query

D. Record

What is the correct answer?

4

A small button with three dots usually displayed at the right of field properties box

A. Make button

B. Expression button

C. Build button

D. None of above

What is the correct answer?

4

What are the columns in a Microsoft Access table called?

A. Rows

B. Records

C. Fields

D. Columns

What is the correct answer?

4

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

A. OR conditions

B. AND conditions

C. NOT condition

D. None of above

What is the correct answer?

4

Which of the following statement is true?

A. Foreign key fields dont allow duplicate values

B. In primary key field you can enter duplicate value

C. In an indexed field you may or may not enter duplicate value depending upon setting

D. All statements are true

What is the correct answer?

4

Which is not a view to display a table in Access?

A. Datasheet View

B. Design View

C. Pivot Table & Pivot Chart View

D. None of above

What is the correct answer?

4

In table design view what are the first column of buttons used for

A. Indicate Primary Key

B. Indicate Current Row

C. Both of above

D. None of above

What is the correct answer?

4

The command center of access file that appears when you create or open the MS Access database file.

A. Database Window

B. Query Window

C. Design View Window

D. Switchboard

What is the correct answer?

4

While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into

A. a doctors sign

B. thin + sign

C. outline rectangle

D. None of above

What is the correct answer?

4

A search value can be an exact value or it can be

A. Logical Operator

B. Relationship

C. Wild card character

D. Comparison operation

What is the correct answer?

4

The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables

A. relationship

B. Join

C. Query

D. None of these

What is the correct answer?

4

When a picture or other graphic image is placed in the report header section it will appear____

A. Once in the beginning of the report

B. At the top of every page

C. Every after record break

D. On the 1st and last pages of the report

What is the correct answer?

4

The task of arranging data in order is called

A. Searching

B. Sorting

C. Ordering

D. Shorting

What is the correct answer?

4

A database can be best described as

A. Organized collection of data

B. Useful presentation of data

C. Graphical representation of data

D. All of above

What is the correct answer?

4

Unlike text data type, this can store up to maximum of 65, 535 characters.

A. memo

B. data/time

C. number

D. All of above

What is the correct answer?

4

Collection of related records in a database is known as

A. File

B. Bench

C. Table

D. Relationship

What is the correct answer?

4

It is a database object to view, change, and analyze data in different ways

A. query

B. form

C. report

D. None of the above

What is the correct answer?

4

After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

A. You need to delete the whole tablThere is no method to remove a particular field only.

B. Delete all the fields from third downwards and reenter the required fields again.

C. Select the third column in datasheet view then Delete

D. Select the third row in table design view then Delete