Database_GR9_4/2024

Which feature of Microsoft Access is used to create a new database?

• Tables

• Queries

• Forms

• Database Templates

Which object in Microsoft Access is used to store data?

• Tables

• Queries

• Reports

• Macros

What file extension does a Microsoft Access database typically have?

• .mdb

• .accdb

• .xlsx

• .docx

Which object in Microsoft Access is used to display data in a structured format?

• Tables

• Forms

• Queries

• Reports

What does the wildcard character (*) represent in an Access query?

• Any single character

• Any group of characters

• The end of a string

• The beginning of a string

What does normalization refer to in database design?

• Maximizing data redundancy

• Minimizing data integrity

• Organizing data into multiple related tables

• Combining all data into a single table

In Microsoft Access, what is the purpose of a form?

• To perform calculations

• To display data in a structured format

• To input data into a database

• To retrieve and manipulate data

What is the purpose of input masks in Microsoft Access?

• To hide sensitive data

• To encrypt data

• To create relationships between tables

• To restrict data entry to a specific format

How do you create a relationship between two tables in Microsoft Access?

• By creating a query

• By using the Report Wizard

• By importing data from Excel

• By establishing a foreign key relationship

Which view in Microsoft Access is used to design and modify forms?

• Design View

• Datasheet View

• Layout View

• Form View