Computer Introduction to Microsoft Access Test Online

Q: How can I prepare for Computer Introduction to Microsoft Access Test Online?

You can prepare for Computer Introduction to Microsoft Access Test Online by attempting the free online quizzes at Gotest.com.pk. We provide instant results, performance reports, and detailed explanations for every question.

Question 1

1. Which object in Access is used to store raw data?

Question 2

2. What is the maximum number of characters for a Short Text field in Access?

Question 3

3. Which of these can be used to copy only the structure of a table?

Answer

Copy-Paste

Answer

Append Query

Answer

Make Table Query

Answer

Export to Excel

Question 4

4. Which of the following is used to enter, view, and edit data in a user-friendly format?

Question 5

5. Which feature allows you to filter records quickly?

Answer

Pivot Table

Answer

Filter by Selection

Question 6

6. Which of these views allows you to design the structure of a table?

Answer

Print Preview

Answer

Report View

Answer

Design View

Answer

Datasheet View

Question 7

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

Answer

Short Text

Question 8

8. Which of the following allows grouping and summarizing data?

Answer

Parameter query

Answer

Append query

Answer

Select query

Answer

Crosstab query

Question 9

9. Which of the following is used to import or export data?

Answer

External Data Tab

Answer

Design View

Answer

Create Tab

Answer

Report Wizard

Question 10

10. Which of these allows data validation in MS Access?

Answer

Validation Rule property

Question 11

11. Which object in MS Access is used to present data visually?

Question 12

12. What is the primary function of a report in MS Access?

Answer

Printing and presenting data

Answer

Form creation

Answer

Data entry

Answer

Query design

Question 13

13. Which Access object can be used to automate tasks?

Question 14

14. Which feature in Access is used to automatically calculate totals?

Answer

Report Wizard

Answer

Totals row in Datasheet View

Answer

AutoNumber

Question 15

15. What does the Data Type property in Access define?

Answer

Table sorting order

Answer

Type of data stored in a field

Answer

Column formatting

Answer

Input form layout

Question 16

16. What is the Row Source property used for?

Answer

Creating reports

Answer

Formatting rows

Answer

Linking data to combo boxes or list boxes

Answer

Generating primary keys

Question 17

17. What is the primary key used for in an Access table?

Answer

Sorting records

Answer

Formatting

Answer

Uniquely identifying each record

Question 18

18. Which of the following views allows users to enter or edit data directly?

Answer

Design View

Answer

Datasheet View

Answer

Print Preview

Question 19

19. Which query type is used to add records from one table to another?

Answer

Select query

Answer

Append query

Answer

Delete query

Answer

CrossTab query

Question 20

20. Which of the following statements about relationships in Access is correct?

Answer

Access does not support relationships

Answer

Relationships help link data across tables

Answer

Only reports can define relationships

Answer

A table can only have one relationship

Question 21

21. Which Access object is used to retrieve specific data based on criteria?

Question 22

22. In Access, what is a macro?

Answer

A data entry field

Answer

A stored procedure

Answer

A set of actions to automate tasks

Answer

A type of table

Question 23

23. Which tab in Access is used to create tables, queries, forms, and reports?

Answer

External Data

Question 24

24. Which property defines the number of characters that can be stored?

Answer

Input Mask

Answer

Field Size

Question 25

25. Which view allows you to see one record at a time?

Answer

Report View

Answer

Datasheet View

Answer

Layout View

Question 26

26. What is the use of the Lookup Wizard?

Answer

To delete duplicates

Answer

To search records

Answer

To create a list of values from another table or value set

Answer

To validate data

Question 27

27. Which command is used to remove all records from a table?

Answer

Delete Query

Answer

Truncate Table

Answer

Drop Table

Answer

Remove Form

Question 28

28. Which of the following commands is used to sort records in a query?

Question 29

29. Which of the following is not an object in MS Access?

Question 30

30. Which field type is used to store monetary values?

Answer

AutoNumber

Answer

Short Text

Question 31

31. What is the maximum number of characters allowed in a field name?

Question 32

32. Which of the following is used to automatically generate a unique value?

Answer

AutoNumber

Question 33

33. Which query type is used to change data in a table?

Answer

Make Table query

Answer

Select query

Answer

Update query

Answer

Append query

Question 34

34. Which of the following field types can store large text in Access?

Answer

Short Text

Answer

Long Text (Memo)

Question 35

35. Which property controls how data is displayed but not stored?

Answer

Field Size

Answer

Input Mask

Answer

Validation Rule

Question 36

36. Which of the following views is used to modify a form’s structure?

Answer

Datasheet View

Answer

Layout View

Answer

Table View

Question 37

37. Which key combination is used to switch between views in Access?

Question 38

38. In a report, which view is used to make changes to the structure?

Answer

Datasheet View

Answer

Report View

Answer

Print Preview

Answer

Layout View

Question 39

39. What is the purpose of the Input Mask property in a field?

Answer

To sort values

Answer

To control how data is entered

Answer

To filter records

Answer

To convert data types

Question 40

40. Which of these is true about AutoNumber in Access?

Answer

Automatically increments value

Answer

Requires formatting

Answer

It's a text-based field

Answer

Must be entered manually

Question 41

41. Which feature allows multiple users to access the database at the same time?

Answer

Record Locking

Answer

Query Wizard

Answer

Backup Tool

Question 42

42. Which of these allows searching across all fields in a table?

Answer

Filter by Form

Answer

Search Box

Answer

Design View

Answer

Navigation Pane

Question 43

43. What is a parameter query?

Answer

A read-only query

Answer

A query that asks the user for input

Answer

A query used only in reports

Answer

A query with foreign key

Question 44

44. Which field property in Access ensures a field must contain a value?

Answer

Field Size

Answer

Input Mask

Question 45

45. Which of the following is a database management system from Microsoft?

Answer

PowerPoint

Question 46

46. What is the default file extension for an Access 2016 database?

Question 47

47. Which option is used to define a relationship between tables?

Answer

Report Layout

Answer

Table Wizard

Answer

Query Design

Answer

Relationship Window

Question 48

48. Which of the following relationships ensures referential integrity?

Answer

Many-to-many

Answer

One-to-one

Answer

One-to-many with foreign key

Question 49

Loading...

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 Introduction to Microsoft Access Test Online

Important Introduction to Microsoft Access Question and Answer

Computer Introduction to Microsoft Access Practice Test Online With Explanation

Uncategorized

Study Plan for Computer Introduction to Microsoft Access Test Online

How to Use GoTest for Preparation:

More Related Resources

Mustansar Khan

Leave a Reply Cancel reply

Important Introduction to Microsoft Access Question and Answer

Computer Introduction to Microsoft Access Practice Test Online With Explanation

Uncategorized

Study Plan for Computer Introduction to Microsoft Access Test Online

How to Use GoTest for Preparation:

More Related Resources

Latest Updates

Mustansar Khan

Leave a Reply Cancel reply