MCQ Practice Quiz

MS Access Database Systems

In MS Access, a database is primarily composed of

Tables

A row in a table is also referred to as a

Record

A primary key in MS Access must

Uniquely identify each record

Which of the following is used to enforce a relationship between tables

Foreign key

In Access, which data type is best for storing currency values

Currency

A one-to-many relationship means

One record in the first table relates to many records in the second

To create a new blank database in MS Access, you first choose 

File, New, Blank Database

The AutoNumber field is used when

Unique sequential numbers are needed for each record

To prevent duplicate values in a column, you should

Set it as primary key or unique indexed

In table design view, which property ensures a field cannot be left empty

Required

Lookup fields in Access are used for

Selecting values

Which view is used to create and modify queries in MS Access

Design View

In MS Access, which type of query retrieves records that meet specific criteria

Select Query

A query that allows changing data in a table is called

Update Query

Which query type in Access creates a new table from existing data

Make-Table Query

To find the average salary from an Employee table, you would use

Aggregate Function

Which wildcard character in Access represents multiple characters in a LIKE query

*

If you want a query to prompt the user for input, you use

Parameter Query

Which join type returns all records from both tables, regardless of match

Full Outer Join

In MS Access, an Inner Join will

Return only matching records between the two tables

If you want to see all customers, even those without orders, you should use

Left Join between Customers and Orders

Compact and Repair Database in MS Access is used for

Reducing file size and fixing corruption issues

Which feature prevents accidental changes to data structure in Access

Setting Database Password

A split database in MS Access typically means

Tables are in one file, while query forms and reports are in another

Backup of an Access database can be created using

File, Save As, Backup Database

The Report Wizard in MS Access is mainly used for

Quickly generating reports with grouping and summaries

Which of the following is NOT a purpose of using a Form in MS Access

Generate summarized data reports

A filter in MS Access allows you to

Display only records meeting specific conditions

Which statement about outer joins in MS Access is correct

They return all rows from one table and matching rows from another

When applying a Right Outer Join between Table A and Table B in Access, the result will include

All rows from Table B and only matching rows from Table A