Home
Current Affairs January 2024

What is the correct answer?

4

You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view

A. Clicking

B. Right clicking

C. Double clicking

D. None of the above

Correct Answer :

C. Double clicking


Related Questions

What is the correct answer?

4

To create relationship between two tables

A. drag the primary key of a table into foreign key of another table

B. drag the foreign key of a table into the primary key of another table

C. drag any field from parent table and drop on child table

D. Any of above can be done to create relationship

What is the correct answer?

4

The database language that allows you to access or maintain data in a database

A. DCL

B. DML

C. DDL

D. None of 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

What is the correct answer?

4

To duplicate a controls formatting you can use___

A. Manager

B. Wizard

C. Painter

D. Control

What is the correct answer?

4

Which of the following is a method to create a new table in MS Access?

A. Create table in Design View

B. Create Table using wizard

C. Create Table by Entering data

D. All of above

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

How can you define a field so that when entering data for that field it will display ****** instead of actual typed text

A. Input mask

B. Validation Rule

C. Indexed

D. IME Mode

What is the correct answer?

4

Which of the following database object hold data?

A. Forms

B. Reports

C. Queries

D. Tables

What is the correct answer?

4

The__ button on the tool box display data from a related table

A. Sub form sub report

B. Relationships

C. Select objects

D. More controls

What is the correct answer?

4

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

A. Tables

B. Query

C. Report

D. Relationship

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

Following is not a database model

A. network database model

B. relational database model

C. Object Oriented database model

D. None

What is the correct answer?

4

To create queries in Access

A. You can drag and drop fields on query builders

B. you can type the SQL command in SQL view

C. You can use query wizard or design view

D. All of above

What is the correct answer?

4

Microsoft Access is a

A. RDBMS

B. OODBMS

C. ORDBMS

D. Network database model

What is the correct answer?

4

It is an association established between common fields of two tables.

A. line

B. relationship

C. primary key

D. records

What is the correct answer?

4

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 is the correct answer?

4

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

A. Address book of all the suppliers of a company

B. Salary sheet of all the employees of a company

C. Records of daily sales transactions of a company

D. All of above

What is the correct answer?

4

This option allows you to build a new table by entering data directly into the datasheet.

A. datasheet view

B. design view

C. link table

D. None of the above

What is the correct answer?

4

Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

A. Home Tab

B. Create Tab

C. External Data Tab

D. Database Tab

What is the correct answer?

4

Which of the following term is least related to database?

A. Attributes

B. Tuples

C. Relationship

D. Columns

What is the correct answer?

4

To create a new table, in which method you dont need to specify the field type and size?

A. Create table in Design View

B. Create Table using wizard

C. Create Table by Entering data

D. All of above

What is the correct answer?

4

Which of the following expresses correct order?

A. Characters, Fields, Records, Tables, Files, Databases

B. Characters, Fields, Records, Tables, Database, Files

C. Databases, Tables, Files, Records, Field, Character

D. Files, Databases, Tables, Records, Fields, Characters

What is the correct answer?

4

We can remove a relationship defined between two tables by

A. From Edit menu choose Delete Relationship

B. Select the relationship line and press Delete

C. Choose Delete option from Relationship menu

D. All of above

What is the correct answer?

4

It is most common type of query. It retrieves records from one or more tables and then displays the

A. Parameter

B. Select

C. crosstab

D. All of above

What is the correct answer?

4

Which of the following is not a database object?

A. Tables

B. Queries

C. Relationships

D. Reports

What is the correct answer?

4

The two form layout types will display multiple records at one time are tabular and___

A. columnar

B. justified

C. date sheet

D. pivot table

What is the correct answer?

4

Which of the following is NOT a type of Microsoft Access database object?

A. Table

B. Form

C. Worksheets

D. Modules

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

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

Which field type will you select when creating a new table if you require to enter long text in that field?

A. Text

B. Memo

C. Currency

D. Hyperlink