Logo 
Search:

MS Office Interview FAQs

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

Differentiate between select Query & parameter Query.

A select query is the most common type of query. It retrieves data from one or more tables and displays the results in a datasheet where you can update the records (with some restrictions). You can also use a select query to group records and calcula...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

Differentiate between crosstab query & Action query.

A crosstab query displays summarized values (sums, counts, and averages) from one field in a table and groups them by one set of facts listed down the left side of the datasheet and another set of facts listed across the top of the datasheet.

An a...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

How does the Auto form feature of Access differ from the Form wizard?

Create a form by using AutoForm. With AutoForm, you select one record source and either columnar, tabular, or datasheet layout; AutoForm creates a form that uses all the fields from the record source you selected and all the fields from its related r...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

Is it possible to run a macro from within another macro? If so, how will you do it?

To run a macro from another macro or from a Visual Basic procedure, add the RunMacro action to your macro or procedure.

• To add the RunMacro action to a macro, click RunMacro in the action list in a blank action row, and set the Macro Name argum...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What are macro actions? Name any two actions provided by Access?

Echo, Msgbox , GotoControl, StopMacro
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What are macro actions? Name any two actions provided by Access?

Echo, Msgbox , GotoControl, StopMacro...................
Posted By:Shruti Sharma      Posted On: Jan 20

  1  2  3  4  5  6