Home/Computer/Computer Table and Query Test Online

Computer Table and Query Test Online

Mustansar KhanLast Updated: October 15, 2025

Important Table and Query Question and Answer

Total Questions:	50
Time Allowed:	25 Minutes
Total Marks:	50
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	ECAT Entry Test Computer Online Test Interview Questions about Computer All Universities Entrance Test Recruitments Tests

Computer Table and Query Practice Test Online With Explanation

Please wait...

Page 1 of 2

Uncategorized

1. In MS Access, what does a field represent in a table?

A column

A row

A cell

A form

2. Which data type is suitable for storing phone numbers?

Number

Currency

AutoNumber

Short Text

3. Which of these fields is automatically indexed in Access?

Caption field

Foreign key

Any Long Text field

AutoNumber (Primary Key)

4. Which type of join returns all records from one table and matching records from another?

Left join

Self join

Inner join

Right join

5. Which of the following statements is true?

Queries do not require tables

A table can have multiple records and multiple fields

Queries can only access one table at a time

One table can only have one field

6. What is a Crosstab query used for?

To apply validation rules

To group and summarize data in a matrix format

To change field names

To delete data

7. What does the "Is Null" condition in a query do?

Finds empty or missing values

Finds fields that contain numbers

Finds text fields only

Sorts values in descending order

8. What type of query is used to delete data from a table?

Make Table query

Delete query

Parameter query

Crosstab query

9. What is the function of a lookup field?

To allow selection from a predefined list

To apply queries

To enter unique values

To sort table records

10. What is a foreign key?

A key that can be left blank

A key that refers to the primary key in another table

A unique key for each record

A field with numeric values

11. Which field property is used to limit the type of data entered?

Field Size

Caption

Format

Validation Rule

12. Which of the following views allows you to create or modify a query using SQL?

Design View

Datasheet View

SQL View

Form View

13. Which query would you use to combine fields from two or more tables?

Select query with JOIN

Update query

Append query

Delete query

14. Which of the following clauses is used to sort query results?

WHERE

JOIN

ORDER BY

GROUP BY

15. Which of the following is not a valid data type in Access tables?

Currency

Image

Short Text

Number

16. Which feature ensures that each record is uniquely identified?

Caption

Primary Key

Foreign Key

Lookup Field

17. In a query, which function returns the average value?

MAX

SUM

COUNT

AVG

18. What does the expression builder in Access help you do?

Print reports

Write and insert formulas or expressions

Rename tables

Create queries

19. Which of the following allows you to join data from multiple tables?

Report

Query

Form

Macro

20. Which of the following helps filter data in a query?

GROUP BY

WHERE clause

ORDER BY

SELECT clause

21. Which of the following is used to add new records to a table using a query?

Crosstab query

Update query

Append query

Select query

22. What is the primary purpose of a table in MS Access?

To format data

To create reports

To store data

To filter data

23. Which property in a table defines the data type and length of a field?

Field Size

Caption

Required

Field Name

24. What does the Total row in a query allow you to do?

Set primary keys

Apply formatting

Use aggregate functions like Sum, Count

Apply joins

25. Which view is used to design the structure of a table?

Layout View

Datasheet View

Design View

SQL View

Page 2 of 2

26. What is the function of a query in MS Access?

To retrieve specific data

To create forms

To update table structures

To define primary keys

27. Which field type allows automatic incrementing of values?

Number

AutoNumber

Short Text

Currency

28. What is the effect of the DISTINCT keyword in a query?

Filters out duplicate records in the result

Highlights unique data in red

Limits records to 10

Deletes duplicate tables

29. Which type of join returns only the matching records from both tables?

Self join

Inner join

Cross join

Outer join

30. Which of the following is a calculated field?

A field created by combining other fields using expressions

A form field

A lookup field

A manually entered number

31. Which key uniquely identifies each record in a table?

Primary key

Foreign key

Super key

Candidate key

32. Which of the following query types allows user input at runtime?

Make Table query

Parameter query

Delete query

Append query

33. Which of the following queries is used to create a new table from an existing one?

Make Table query

Update query

Crosstab query

Delete query

34. Which of the following can be used to restrict the number of records returned in a query?

TOP

ORDER BY

WHERE

JOIN

35. What is the default view when you open a table?

Pivot View

Design View

Datasheet View

SQL View

36. What happens when you set a field as Required?

It cannot be left empty

It only accepts numbers

It becomes read-only

It becomes the primary key

37. Which query type is used to retrieve and view data?

Append query

Delete query

Update query

Select query

38. Which field property is used to display a user-friendly name instead of the actual field name?

Field Size

Caption

Validation Rule

Format

39. Which wildcard symbol represents a single character?

40. Which of the following query types cannot be used to edit data?

Append query

Delete query

Crosstab query

Update query

41. What is the purpose of the "LIKE" operator in a query?

To check for NULL values

To filter numeric values only

To match patterns in text fields

To perform arithmetic

42. Which query is used to modify existing records?

Delete query

Make Table

Update query

Append query

43. Which symbol is used as a wildcard for any number of characters in Access queries?

44. Which of the following is a valid aggregate function in Access queries?

CAST

INSERT

ADD

MAX

45. What is a record in a table?

A field

A column of data

A query result

A complete row of data

46. What is the purpose of setting a default value for a field in a table?

To automatically insert a preset value when none is entered

To disable the field

To reduce storage size

To allow null values

47. What is the result of a null value in a field?

The field is zero

The field is text

The field has a space

The field is empty (no data)

48. Which field type should you use to store URLs or email addresses?

Memo

Short Text

Hyperlink

Attachment

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.

Introduction to Computers Online Test
Computer File Handling in “C” Test Online
Computer Functions in “C” Test Online
Computer Loop Constructs Test Online
Computer Decision Constructs Test Online
Computer Input Output Test Online
Computer Elements of “C” Test Online
Computer Getting Started with “C” Test Online
Computer Microsoft Access-Forms and Reports Test Online
Computer Introduction to Microsoft Access Test Online

Mustansar KhanLast Updated: October 15, 2025

Computer Table and Query Test Online

Important Table and Query Question and Answer

Computer Table and Query Practice Test Online With Explanation

Uncategorized

Related Posts

Mustansar Khan

Leave a Reply Cancel reply