Logo 
Search:

Interview FAQs

Submit Interview FAQ
Home » Interview FAQsRSS Feeds
MS Office
Comments: 0

How can you copy an entire worksheet to another worksheet ?

a. To move or copy sheets to another existing workbook, open the workbook that will receive the sheets.
b. Switch to the workbook that contains the sheets you want to move or copy, and then select the sheets.
c. On the Edit menu, click Move or Cop...
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

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

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

  1  2  3  4  5  6  7  8  9  10  11