2nd Year Chapter-7 Ms. Access Forms And Report Question And Answer

Short And Simple Question And Answer

Q1: What is a form?

Ans: A form is a window with visual components for data input and display. It’s made up of individual design elements known as controls, like text boxes, labels, and check boxes, serving various purposes.

Q2: What are some uses of a form?

Ans: Forms are used to add, delete, include, view, and search data in a database. They also function as custom dialog boxes that accept user input and trigger actions.

Q3: What is a sub-form?

Ans: A sub-form is a form placed within a parent form (main form). It’s also known as a child form and is useful when tables have a one-to-many relationship, with the sub-form typically involving a foreign key.

Q4: What is conditional formatting?

Ans: Conditional formatting is a special type of formatting that depends on the value of a control. It can be applied to elements like text boxes, lists, and combo boxes.

Q5: What is a report?

Ans: Reports are the output of a database application and allow users to generate various types of reports by manipulating the database.

Q6: What is linking?

Ans: Linking in MS Access involves creating a link to an object in another database table. It does not copy the table but rather connects to it.

Q7: What is a switchboard?

Ans: A switchboard in Microsoft Access is a form that helps users navigate and perform tasks within a database application. It acts as a customized menu with user-defined commands, often involving actions like opening forms, naming queries, or printing reports.

Q8: What are keyboard shortcuts?

Ans: Keyboard shortcuts are key combinations used to perform different tasks in an application. They are designed to save time and effort.

Q9: What is an input mask?

Ans: An input mask controls the format in which data is stored in a cell. For example, it can ensure that a date field follows a specific format, such as dd/mm/yy.

Q10: Explain tabular form briefly?

Ans: In a tabular form, multiple records are displayed with fields in columns and records in rows. It’s ideal when you want to view a few records with narrow fields and see several records simultaneously.

Q11: Define columnar form.

Ans: Columnar form displays field and label side by side. It shows only one value at a time and provides a record navigation bar for traversing records.

Q12: Define Datasheet form.

Ans: A datasheet form displays data in datasheet view, showing one record at a time. It also includes a record navigation bar to move through different records. This type of form is often used as the basis for sub-forms.

Q13: What is a list box?

Ans: A list box is a type of text box that can associate multiple values, allowing more than one value to be displayed and selected at the same time.

Q14: What is a combo box?

Ans: A combo box is a type of text box that can associate multiple values, but it displays and allows the selection of only one value at a time.

Q15: What is a switchboard?

Ans: A switchboard is a type of form that displays buttons linked to various database objects. Users can use these buttons to open, close, or modify those objects.