Nothing Special   »   [go: up one dir, main page]

Computer Dot Com: Access (Online/ In-House Exam Paper)

Download as pdf or txt
Download as pdf or txt
You are on page 1of 3

1

Computer Dot Com


A complete computer education
Under W.B. Government registered
An ISO 9001:2015 Certified Institute
ACCESS [ONLINE/ IN-HOUSE EXAM PAPER]

Unit – I Select Correct Answer 10x2=20


1.Microsoft Access is a _____
(A) Network Database Model
(B) RDBMS
(C) ORDBMS
(D) OODBMS

2.Which of the following is not a type of Microsoft access database object?


(A) Macros
(B) Modules
(C) Worksheets
(D) Table

3.____ is not a valid data type in MS Access.


(A) Auto number
(B) Currency
(C) Memo
(D) Picture

4.In Access, ____ are used to store the data.


(A) Report
(B) Form
(C) Table
(D) Query

5.Which tool do you use to create a query object?


(A) Table query wizard
(B) Simple query wizard
(C) Simple filer wizard
(D) Database wizard

6.Open the Save As dialog box


(A) F1
(B) F2
(C) F10
(D) F12

7.Primary key is used for


(A) Prevent Duplicate Entry of A record
(B) Prevent Duplicate Entry of A Table
(C) Prevent Duplicate Entry of A Database

Computer Dot Com/ Online / In- House Exam/ 2021/Set-5


2

(D) None of this

8.A __________ enables you to view data from a table based on a specific criterion
(A) Form
(B) Query
(C) Macro
(D) Report

9.Which of the following database object produces the final result to present?
(A) Forms
(B) Reports
(C) Queries
(D) Tables

10. Which field type will you select when creating a new table if you require to enter long text in
that field?
(A) Text
(B) Memo
(C) Currency
(D) Hyperlink
Unit – II [ Fill the Blanks ] 5x2=10

1. Extension of Ms-Access 2010 file is _________


2. Ms-Access produced by __________ company
3. Date of birth is __________ type of data type
4. There are ________ tabs in Ms-Access 2010
5. New option is available under ________ tab

Unit – III [ W rite the Steps ] any 2 2x10=20

1. How you Open Access 2021 and make a new database


2. How you make a table with the field [ Code,name,house,join_date,salary]
3. How you export access data to Excel
4. How you make duplicate table? How you make a report.

Instruction of the Exam :


 Write question in paper and answer it
 Submit the answer sheet PHOTO GRAPH within 2 hours after getting the question paper to
Namrata mam whatsapp .
 Now submit the answer sheet to office next days. Do not modify any part after send the
answer sheet to Namrata mam.
 Step write will be fully clear means write all the steps
 Hand writing will be clean and answer sheet will be clean at all
Computer Dot Com/ Online / In- House Exam/ 2021/Set-5
3

Computer Dot Com/ Online / In- House Exam/ 2021/Set-5

You might also like