Welcome to TestAdda

Please wait....

Loading
Ms-Access Test 1 for IA
|
Mark For Review

What data type should yo choose for a zip code field in a table?

|
Mark For Review

Navigation pane is placed on

|
Mark For Review

Identify the relationship between a Movie table and Stars table:

|
Mark For Review

Which of the following filter method is not available in Access?

|
Mark For Review

The raw facts and figures are:

|
Mark For Review

Which of the following is a database management system?

|
Mark For Review

Which of the following database objects asks a question of information in a database and then displays the result?

|
Mark For Review

What is relational database?

|
Mark For Review

Which editor was provided for use with Access Basic?

|
Mark For Review

You can find Sort & Filter group of commands in

|
Mark For Review

Arrange according to the size

|
Mark For Review

Why do you pin an item in list?

|
Mark For Review

What is the purpose of the description column in Table Design View?

|
Mark For Review

What is the maximum allowed field size for Boolean (Yes/No) fields?

|
Mark For Review

How can you display Pivot Table report summary data in a currency format?

|
Mark For Review

Which of the following is NOT a selection technique

|
Mark For Review

Which of the following method can be used to add more tables in a database?

|
Mark For Review

The options like Save, Open Database, Print are available in

|
Mark For Review

What type of relationship exists between a Teacher table and Class table?

|
Mark For Review

What type of relationship exists between a Student table and Fees table?

|
Mark For Review

According to Access Help, what's a good way to design a database?

|
Mark For Review

What is the first step in creating a form or report with the form wizard or report wizard?

|
Mark For Review

The filter By selection feature allows you to filter:

|
Mark For Review

The feature that database allows to access only certain records in database is:

|
Mark For Review

Which of the following field type can store maximum data?

|
Mark For Review

A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As

|
Mark For Review

For which kind of relationship you need a junction table to reflect real world situation?

|
Mark For Review

The arranging of data in a logical sequence is called

|
Mark For Review

What field type is best to store serial numbers?

|
Mark For Review

What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library?s available objects and members?

|
Mark For Review

Which filter method lets you filter the records that match the selected field?

|
Mark For Review

From which version Microsoft introduced Backstage View for Access Interface?

|
Mark For Review

What is the propose to a sub datasheet?

|
Mark For Review

Which program do you use to edit code for data access pages?

|
Mark For Review

To display associated record from related table in datasheet view, you can

|
Mark For Review

Which of the following field type is used to store photograph of employees?

|
Mark For Review

Which filter method lets you filter records based on criterion you specify?

|
Mark For Review

A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be

|
Mark For Review

You can display data from multiple tables by using

|
Mark For Review

Group names in ribbon can be helpful to

|
Mark For Review

What is the size of Data & Time field type?

|
Mark For Review

Which control does access use to link data access page components to access data?

|
Mark For Review

Mechanism developed to enforce users to enter data in required format is:

|
Mark For Review

The advantage of computerized database over manual database is

|
Mark For Review

What happens when you add the asterisk (*) from any field list ot a query?

|
Mark For Review

Which of following relationship type is not possible to realize in Access Database directly?

|
Mark For Review

Which action will optimize your database performance?

|
Mark For Review

You can filter the display of different Access objects in navigation pane from

|
Mark For Review

The options like Relationship, SQL Server etc . are found in

|
Mark For Review

You can display Backstage View by clicking on

|
Mark For Review

The text you typed in Description column in Table Design View is displayed on

|
Mark For Review

What is the best data type for a field that stores mobile numbers?

|
Mark For Review

In access, the best types of queries to use for data analysis are:

|
Mark For Review

What do you need if you should enforce many-?to-?many relationship between two tables?

|
Mark For Review

Circular button with Office icon in it is

|
Mark For Review

By Grouped Report you understand

|
Mark For Review

The way a particular application views the data from the database that the applicaton uses is a

|
Mark For Review

If a piece of data is stored in two places in the database, then a

|
Mark For Review

How can you add a table to the relationship window?

|
Mark For Review

What is the memo data type field used for?

TestAdda OMR