1. Question:What is a switchboard? 

    Answer
    A switchboard is simply a form with command button that open other switchboard or perform tasks such as opening forms and printing reports. Switchboard is a tool in Access to create a database application. You can use Switchboard Manager to create switchboards.

    1. Report
  2. Question:What is an AutoForm? 

    Answer
    AutoForm is a wizard in Access that creates the specified type of form from selected table or query. To create an AutoForm Select the Forms tab and click on New button.

    1. Report
  3. Question:What are the three different forms of auto forms? 

    Answer
    The three different types of auto forms are:
    - Columnar
    - Tabular
    - Datasheet

    1. Report
  4. Question:Each object on the form has its own property sheet. What are the different ways to evoke property sheet? 

    Answer
    The different ways to evoke property sheet are:
    - Right Click the object and select properties
    - Select the object and click properties from
    forms design toolbar
    - Double click the object

    1. Report
  5. Question:What is the form view? 

    Answer
    Form View is the presentation of the fields of a table in a format suitable for data entry as various controls can be placed on the form.

    1. Report
  6. Question:What are controls? How to use them? Give examples for control. 

    Answer
    Controls are objects that can be placed in a form. The different controls are available in the Tool Box. After selecting the control in the toolbox it can be placed on the forms. After placing the control we can set its properties to serve our request. Examples for controls are, textbox, label, List Box, Check Box, Option Buttons etc.

    1. Report
  7. Question:What is the use of the form design window? 

    Answer
    The form design window is where the user can customize the window. Customizing is the process of modifying the form design to suit user requirements.

    1. Report
  8. Question:What are the ways to create a new form? 

    Answer
    You can create a new form in any of the following three ways:
    - Using AutoForm: You can create a form
    based on a single table or query quickly
    using Autoform.
    - Using Form Wizard: You can create a form
    based on multiple talbes or queries using
    Form Wizard.
    - Design View: You can create a custom
    form on your own in Design View.

    1. Report
  9. Question:How can you show only selected records with a form? 

    Answer
    There are different ways in which you can limit the records that you will see with a form, you can:
    - Open a form and apply a Filter.
    - Create a query that selects records and
    base the Form on that Query.

    1. Report
  10. Question:What is Dynaset? 

    Answer
    A dynaset is a subset of the data stored in database that is displayed by the query.

    1. Report
Copyright © 2024. Powered by Intellect Software Ltd