MICROSOFT ACCESS EXAMINATION (2025-26) (GOVT OF INDIA VOCATINAL EXAMINATION BOARD)


GOVT OF INDIA 

VOCATIONAL EXAMINATION BOARD 

APPROVED BY GOVT.OF INDIA 

MICROSOFT ACCESS 

FINAL EXAM 2025-26

SUBJECT CODE-REG27/16/02


Total Marks: 100
Time: 01:15 Minutes




Section A: Multiple Choice Questions (20 Marks)

Each question carries 2 marks.

  1. Which of the following is not a data type in MS Access?
    a) Text
    b) Memo
    c) Currency
    d) Float

  2. What is a primary key?
    a) A key that combines multiple fields
    b) A unique identifier for a record
    c) A field used to sort records
    d) A field that accepts duplicates

  3. Which object is used to display data in a printable format?
    a) Table
    b) Form
    c) Query
    d) Report

  4. What is the purpose of a query in MS Access?
    a) To enter data
    b) To print data
    c) To retrieve filtered data
    d) To delete the database

  5. Which of the following allows creating a user interface in MS Access?
    a) Report
    b) Table
    c) Form
    d) Query

Section B: Short Answer Questions (30 Marks)

Each question carries 6 marks.

  1. Explain the difference between a table and a query in MS Access.

  2. What is referential integrity? Why is it important?

  3. Describe the steps to create a form using a wizard in MS Access.

  4. What is the difference between "one-to-one" and "one-to-many" relationships?

  5. How can you apply a validation rule in a field?

Section C: Practical-Based/Theoretical Long Questions (50 Marks)

Each question carries 10 marks.

  1. Design a database in MS Access for a Library Management System. Mention the table names, fields, and relationships.

  2. Explain the use of reports in MS Access. How do you create and format a report?

  3. Describe the process of creating a parameter query with an example.

  4. What are macros in MS Access? How are they different from modules?

  5. Discuss data normalization. Explain the first three normal forms with examples.

Let me know if you'd like this paper in Hindi, PDF format, or for a different subject like Access Control in Cybersecurity, etc.

Comments

Post a Comment

Popular posts from this blog

TALLY PRIME DASHBOARD BY MOHIT SIR

Image
1) TALLY SYLLABUS  TALLY SYLLABUS LINKS 2) TALLY PRIME THEORY QUESTIONS TALLY PRIME THEORY QUESTIONS LINK 3) COMPANY CREATION COMPANY CREATIONS 4) LEDGER CREATION LEDGER CREATIONS 5) STOCK ITEMS CREATION STOCK ITEMS CREATION 6) GODOWN CREATION GODOWN CREATION 7) GODOWN TRANSFER  GODOWN TRANSFER 8) OP. BALANCE , PURCHASE PAYMENT , SALES , RECEIPT (BILLING CONCEPT) OP. BALANCE , PURCHASE PAYMENT , SALES , RECEIPT (BILLING CONCEPT) 9) ORDER PROCESSING  OEDER PROCESSING 10) DEBIT NOTE & CREDIT NOTE DEBIT & CREDIT NOTE LINK 11)MULTIPLE PRICE LEVEL MULTIPLE PRICE LEVEL LINK 12)REORDER LEVEL REORDER LEVEL LINK 13)STANDARD RATE STANDARD RATE 14)MANUFACTURING MANUFACTURING LINK 15)BATCH WISE DETAILS BATCH WISE DETAILS LINK 16)BUDGET&CONTROL BUDGET & CONTROL LINK 17)CASH BOOK CASH BOOK LINK 18)BALANCE SHEET , PL & TRADING  BALANCE SHEET, P/L, TRADING A/C 19) PAYROLL PAYROLL LINK 20) POINT OF SALE POINT OF SALES LINK 21) GST THEORY CONCEPT  ...
Read more

BILLING CHAPTER

Image
बिलकुल! Tally में Opening Balance, Purchase, Payment, Sales, और Receipt क्यों और कब करते हैं, इसका संक्षिप्त उत्तर नीचे दिया गया है: 1. Opening Balance (ओपनिंग बैलेंस) 🔹 Hindi : जब आप Tally में नया कंपनी खाता बनाते हैं, तो आपको पहले से मौजूद स्टॉक और लेन-देन का बैलेंस डालना पड़ता है ताकि सही शुरुआत हो सके। 🔹 English : When you create a new company in Tally, you need to enter the existing stock and balances from previous records to start with accurate data. 2. Purchase (खरीद) 🔹 Hindi : Stock को खरीदने के समय, उसे Tally में दर्ज करते हैं ताकि Inventory और Accounts सही रहें। 🔹 English : Purchases are entered to keep track of stock bought and to update inventory and accounts. 3. Payment (भुगतान) 🔹 Hindi : जब आप किसी को पैसे देते हैं , तो Tally में Payment एंटर करते हैं ताकि आपकी liabilities कम हो सकें। 🔹 English : Payment is recorded when you make payments to vendors or creditors, reducing liabilities . 4. Sales (बिक्री) 🔹 Hindi : Sales ट्रांजेक्श...
Read more

HOW TO CREATE STOCK ITEM

Image
  📦 Stock Items Tally में क्यों बनाए जाते हैं? 🔹 Hindi : Tally में Stock Items इसलिए बनाए जाते हैं ताकि हर प्रोडक्ट का सही-सही रिकॉर्ड रखा जा सके — जैसे कि कितनी मात्रा है, क्या रेट है, कितना सेल हुआ, कितना बचा है आदि। इससे इन्वेंटरी कंट्रोल आसान हो जाता है। 🔹 English : Stock Items are created in Tally to track individual products — including quantity, rate, stock-in-hand, sales, and purchase details. It helps in inventory control and reporting . ✅ मुख्य फायदे / Main Benefits : Inventory का रिकॉर्ड — Quantity और Value ट्रैक करना Track quantity & value of each item Sales & Purchase रिपोर्टिंग Generate reports based on item-wise sales/purchase Stock Summary बनाना आसान Easy to create Stock Summary in Tally Batch-wise और Expiry-wise tracking (Optional) Useful for pharma & food industry Q. HOW TO CREATE STOCK ITEM? PAHLE MAIN PAGE ME JANA HAI ----FIR CREATE ME CLICK KARNA HAI  FIR STOCK ITEM ME JAKAR CLICK KARNA HAI  YAHA KUCH EXAM...
Read more