Forms and Reports - Short Questions and Answers. Find the below-mentioned the most important and conceptual short questions with answers of Computer Science, ICS Part-2 Chapter No.7: Microsoft Access Forms and Reports. The following questions are especially for the examinations; entry tests i.e. ECAT and job interview questions on Database Management System (DBMS):
Chapter No.7
MS-Access Forms & Reports
Short Questions & Answers
Q.1: What is Access Form?
Answer:
Access Form creates the user interface to your table. Forms are used as an alternative way to enter data into a database table, view, and print data. It provides different ways of viewing table data.
Q.2: What are Control Objects of Form?
Answer:
The form is constructed from a collection of individual design elements called Controls or Control Objects. Controls are the components we see in the windows' dialog boxes of the access and other windows application like buttons, check boxes, and radio buttons etc.
Q.3: Define Form Wizard?
Answer:
A Form Wizard is provided to assist you in the construction of forms. Four types of layout of forms can be created by using form wizard.
Q.4: Define Form Layout?
Answer:
Form Layout is the way in which all objects, fields and records are arranged. Layout of form should be organized and look simplistic and professional. There are four types of layout of forms, these include:
- Columnar Form
- Justified Form
- Tabular Form
- Datasheet Form
Q.5: What is Columnar Form?
Answer:
A single record is displayed at one time with labels and form field side by side in columns. In a Columnar Form, each field appears in a separate line with a label to its left.
Q.6: What Justified Form?
Answer:
Using Justified Form, a single record is displayed with labels and form fields are listed across the screen.
Q.7: What is Tabular Form?
Answer:
Multiple records are listed on the page at a time with fields in columns and records in rows. Tabular Forms display fields in horizontal row, with field labels at the top of the form. Each new row represents a new record. These are best when you want to display several records at once.
Q.8: What is Datasheet Form?
Answer:
A Datasheet Form initially displays data in datasheet view, much as it appears when you open a table. This type of form is often used as the basis for main / sub forms.
Q.9: What is List Box control?
Answer:
The List Box control is a quicker and easier way of entering data and enables the user to make a single selection from a list of predetermined values. List box values are displayed during data entering.
Q.10: Define Combo Box?
Answer:
The Combo Box control is an easy way of entering data from a list of predetermined values. The combo box values are not displayed until the arrow button is clicked to open it.
Q.11: Differentiate between Check Boxes and Radio
Buttons?
Answer:
Both controls are used to display yes/no, true/false, or on/off values. Only one value from a group of radio buttons can be selected while any or all values from a checkbox group can be chosen. Typically, these controls should be used when five or less option are available.
Q.12: Define Command Button control?
Answer:
Command Button control is a clickable image object that is used to start an action or a set of actions such as delete record, save record, close form or open another form etc.
Q.13: State the purpose of Sub-Form?
Answer:
A sub-form is a form that is placed in a Parent Form, called the Sub-Form. These are particularly useful to display data from tables and queries that have one-to-many relationships.
Q.14: What is Hierarchical Form / Master/Detail Form, or
Parent/Child Form?
Answer:
A Sub-form is a form that is placed in another form. The primary form is called the main form, and the form that is enclosed in form is called the sub-form. Sometimes, form/sub form combination is known as Hierarchical Form, Master/Detail Form, or Parent/Child Form.
Q.15: Define Report?
Answer:
Presentation of processed data obtained from a database is called Report. It can be displayed on the screen, on the paper or on the disk.
Q.16: List two advantages of Report?
Answer:
The following are the main uses of reports:
- Display information obtained from a database
- Display the result of a query
- Produce output according to the user’s needs
Q.17: What is Columnar Report?
Answer:
Columnar Report spreads the information for a single record over many rows. In these reports, the values of each field in each record of a table or a query are listed in one long column of text boxes.
Q.18: What is Tabular Report?
Answer:
These reports provide a column for each field of the records in rows under the column header. If you have more columns than can fit on one page, additional pages print in sequence until all columns are printed, then the next group of records is printed.
Q.19: What is Conditional Formatting?
Answer:
Conditional Formatting is a special formatting that depends on the control’s value can be added to text boxes, lists, and combo boxes. A default value can be set along with up to three conditional formats.
Q.20: What is Password Text Field?
Answer:
Password Text Field is a field in which each character appears as an asterisk as the user types the information.
Q.21: What is a Switchboard?
Answer:
A Switchboard is a form that allows navigation around the database. The switchboard is made of buttons that you click. You can set these buttons to open forms, queries, and reports etc.
➤ Forms & Reports - MCQs
➤ Introduction To MS-Access - Short Questions
➤ Table and Query
➤ Data Integrity & Normalization
➤ Database Design Process
➤ Basic Concepts & Terminology of Databases
➤ Data Basics
➤ Getting Started with C
➤ Elements of C
➤ Input/Output
➤ Decision Constructs
➤ Loop Constructs
➤ Functions in C
➤ File Handling
Post a Comment
Your feedback is highly appreciated and will help us to improve. So, please give your good suggestions.