MS Access MCQs - Computer Practice | PakExamPoint

Practise MS Access MCQs in Computer. Attempt multiple-choice questions, check answers and revise related subtopics.

MS Access MCQs and revision practice

Study MS Access through multiple-choice questions in Computer. This subtopic contains 30 practice questions. Read the wording carefully, compare the options and attempt an answer before checking the solution in learning mode.

Use these MS Access MCQs to identify the facts, rules or methods you need to revise. Where an explanation is available, work through it and write down why your chosen option was correct or incorrect. Revisit difficult questions after reviewing your notes, then use exam mode for timed practice.

Continue your revision with related topics: 100 Most Repeated Computer MCQs MCQs, Computer Basic Hardware Components MCQs, Computer Short Questions MCQs, Computer Shortcut Keys MCQs, Important Abbreviations (Computer) MCQs, Information Technology (IT) MCQs, Internet and Social Media MCQs, Internet related Information MCQs.

Return to all Computer topics to choose your next area of study. Read the MCQ study guide to plan your revision, or try a Computer practice quiz.

MS Access: questions and answer review

Try each question before opening its answer. Record the concept behind each mistake and revisit it during your next practice session.

21. In Microsoft Access, it lets you enter and display data in customized format _____?

مائیکروسافٹ ایکسیس میں ، یہ آپ کو اپنی مرضی کے مطابق شکل میں ڈیٹا داخل اور ڈسپلے کرنے دیتا ہے؟

Check answer and explanation

Answer: Form

Explanation A Form in Microsoft Access is used to enter, view, and edit data in a user-friendly and customized layout . It provides a more controlled and organized way to interact with the database than using tables directly.

22. MS Access arranges the data in ______?

ایم ایس ایکسیس ______ میں ڈیٹا کا اہتمام کرتی ہے؟

Check answer and explanation

Answer: Tables

Explanation Microsoft Access (MS Access) organizes data in tables , which are the fundamental building blocks of any database. Data organization : Stores data in tables with rows and columns. Data types : Supports various data types, such as text, number, date/time, currency, and more .

23. It is used to establish an association between related tables.

Check answer and explanation

Answer: Relationship

Explanation You create such a relationship by defining a third table that is called a junction table.

24. MS Access provides _______ forms of layouts.

Check answer and explanation

Answer: 4

Explanation MS Access provides four form of layouts. 1. Columnar layout 2. Tabular layout 3. Datasheet layout 4. Justified layout agm.5.3.23

25. The size of yes/no field is always ________

ہاں/نہیں فیلڈ کا سائز ہمیشہ کیا ہوتا ہے

Check answer and explanation

Answer: 1 Bit

Explanation A Yes/No field in databases (like Microsoft Access) is designed to store only two possible values: true (yes) or false (no). 1- Binary Nature 2- Space Efficiency The actual logical size of the Yes/No field is just 1 bit because it only needs to represent two states.

26. When creating a new table which method can be used to choose fields from standard databases and tables?

نیا ٹیبل بناتے وقت معیاری ڈیٹا بیس اور ٹیبلز سے فیلڈز کا انتخاب کرنے کے لیے کون سا طریقہ استعمال کیا جا سکتا ہے؟

Check answer and explanation

Answer: Create Table using wizard

Explanation The " Create Table using Wizard " method allows users to select fields from standard databases and tables, simplifying the process. It provides step-by-step guidance to create a new table by choosing pre-defined fields efficiently.

27. In one-to-many relationship, the table in ‘one’ side is called _______

ایک سے کئی رشتے میں، 'ایک' طرف کی میز کوکیا کہا جاتا ہے

Check answer and explanation

Answer: Parent

Explanation In one-to-many relationship, the table in ‘one’ side is called Parent. ایک سے کئی رشتے میں، 'ایک' طرف کی میز کو والدین کہتے ہیں۔

28. In Access, which data type is used for "quantity"?

مائکروسافٹ ایکسیس میں، "مقدار" کے لیے کون سا ڈیٹا ٹائپ استعمال ہوتا ہے؟

Check answer and explanation

Answer: Number

Explanation In Microsoft Access, the " Number " data type is used to store numerical values, including quantities . This data type allows you to store whole numbers, decimal numbers, or a combination of both.

29. MS Access is program for ______?

ایم ایس ایکسیس ______ کے لئے پروگرام ہے؟

Check answer and explanation

Answer: Database

Explanation MS-Access is the program for Data Base. ** Microsoft Access is a Database Management System (DBMS) from Microsoft Microsoft Access combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools

30. Which option in MS Access Allows you to add a new record in a tubular form?

Check answer and explanation

Answer: Datasheet View

Explanation The " Datasheet View " in MS Access is the option That allows you to add a new record in a tabular form due to its format and functionality designed for efficient data entry and manipulation within tables.

Found a mistake? Use “Report correction” in the practice tool or contact us with the question and a supporting source.