1. Question:What are the different useful tools available in Design Window to help you with your design work? 

    Answer
    The different tools available in Design Window are:
    - The Forms Design Toolbar
    - The Formatting (Form/Report) Toolbar
    - The Toolbox
    - The Field List
    - The Properties Sheet
    - Various Control Wizards






    1. Report
  2. Question:What is a Field List tool available in Design Window? 

    Answer
    The field list is a handy way to reference fields in the Design View Window. To show the field list, click on the field list button on the Design toolbar. You will see a list of fields from the table or query, which is the source of data for the form.






    1. Report
  3. Question:What is the difference between using a filter and a query to find records? 

    Answer
    We can use a Filter to quickly limit the records we are already viewing in a Datasheet or a form to those that match the criteria that we specify. In contrast to this, we can use a Query to view selected fields and records from one or more tables, then save the query to open it later or use it as the basis of a form or a report.






    1. Report
  4. Question:What are the different options that you can use to filter records? 

    Answer
    The various options available to filter records are:
    - Filter by Form
    - Filter by Selection
    - Filter for Input
    - Advanced Filter/Sort.






    1. Report
  5. Question:How can you apply Filter For option to filter records based on a value of a field? 

    Answer
    To apply Filter For option to filter based on a value of a field:
    - Right click on the field and type the
    criteria in Filter For text box of the
    context menu






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