Database Manipulation

What is the purpose of using Forms and Sub-Forms in databases?

• To generate reports

• To create tables

• To display and input data

• To delete records

Which software can be used to create queries?

• LibreOffice Writer

• Microsoft Access

• Microsoft Word

• Notepad

What layout option can you choose for a main form in Microsoft Access?

• Grid

• Columnar

• List

• Table

What is the easiest way to create a Form with SubForm in Microsoft Access?

• Open the database

• Form Wizard

• Using Reports

• Choose a layout

In the SubForm Wizard, what must you specify?

• The color of the form

• The relationship between the main form and the subform

• The font style

• The size of the form

What is the purpose of creating a query in Microsoft Access?

• To manage user permissions

• To retrieve and analyze data

• To format text

• To create graphics

What can you specify in the 'Criteria' row of a query?

• The title of the query

• The color scheme

• Conditions to filter data

• The layout of the report

What is a calculated field query used for?

• To change data types

• To delete records

• To perform calculations on existing fields

• To create new tables

Which of the following is a step in creating a report in Microsoft Access?

• Select a data source

• Delete existing reports

• Add a new table

• Change the database format

What is the purpose of the Report Wizard in Microsoft Access?

• To create forms

• To guide users in creating reports

• To manage databases

• To delete queries