Logo 
Search:

ms office Interview FAQs

Submit Interview FAQ
Home » Interview FAQs » ms officeRSS Feeds
MS Office
Comments: 0

What is a ’query’ in Access? State and explain the different kinds of queries available.

Queries help to select information from tables and queries for specific purpose. It select columns from records ,recordes from table/query. You can select, summarize, update, delete, make new table, append records to table using query.

Different t...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What do you mean by primary key? Explain its significance.

The power of a relational database system such as Microsoft Access comes from its ability to quickly find and bring together information stored in separate tables using queries, forms, and reports. In order to do this, each table should include a fie...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What is the significance of validation rule and validation test in Access?

You can use the ValidationRule property to specify requirements for data entered into a record, field, or control. When data is entered that violates the ValidationRule setting, you can use the ValidationText property to specify the message to be dis...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

Distinguish between Select query and Action Query, Database and Table, Filter and Query etc

a. Select query and Action Query

The Simple Select Query creates queries that retrieve data from the fields you specify in one or more tables or queries. If you want, the wizard can also sum, count, and average values for groups of records or all ...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What do you understand by indexing in Access?

Index is a feature that speeds up searching and sorting in a table based on key values and can enforce uniqueness on the rows in a table. The primary key of a table is automatically indexed. Some fields can't be indexed because of their data type. Th...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What are the different types of forms that you can create in Access?

Forms can be created in three layouts :
Columnar Each field appears on a separate line with a label to its left.
Tabular The fields in each record appear on one line, with the labels displayed once at the top of the form.
Datasheet The fiel...
Posted By:Shruti Sharma      Posted On: Jan 20

  1  2  3  4  5  6