Home MS Office MCQs MS Access MCQs Question Answers For Competitive Exams Interviews

MS Access MCQs Question Answers For Competitive Exams Interviews

Tags:

 If you are looking online solved objective type question answers MCQs for upcoming jobs tests of MS Access you are here on right place. All of these MCQs are important for entry tests and interviews of PPSC, CSS, PMS, NTS, PTS, SPSC, KPPSC and other entry tests Preparations. Most Repeated MS Access MCQs Questions with Answers Online Test Quiz For Upcoming jobs Interviews and exams. These MCQs are helpful for Computer Entry Tests and Computer Operators Jobs tests interviews Preparations.

MS Access MCQs
MS Access MCQs With Answers


MS Access MCQs With Answers Online Quiz Test



Q.1: In MS Access which of the following is used to search and compile data from the tables?
  1. Reports
  2. Forms
  3. Tables
  4. Queries
D
Q.2: MS Access is a product of-----------?
  1. HP
  2. IBM
  3. Intel
  4. Microsoft
D
Q.3: In Microsoft Access database system which data type can store pictures and graphs?
  1. OLE Entity
  2. Objects
  3. Auto Object
  4. OLE Object
D
Q.4: In MS Access a report consists of data which is retrieved from---------?
  1. Forms
  2. Only queries
  3. Tables or Queries
  4. Only tables
C
Q.5: Which kind of facility MS Access RDBMS provides?
  1. All Options
  2. Data Integrity
  3. Data Security
  4. Data Independence
A
Q.6: In Microsoft Access the query “B[!ae]ll” finds?
  1. Ball,bill and bull
  2. Bull and bill, but not ball or bell
  3. All Options
  4. Ball,Bell,Bill but not bull
B
Q.7: Choose the correct association between the following options?
  1. Data=Information
  2. Field=Table
  3. Record=Row
  4. File=Row
B
Q.8: In Microsoft Access database which of the following is the correct logical data type?
  1. Text
  2. Auto Number
  3. YES/NO
  4. Boolean
C
Q.9: How many relationships are there in the Microsoft MS Access database that we can use?
  1. 3
  2. 7
  3. 4
  4. 5
A
Q.10: In MS Access which wildcard is used to exclude characters inside the brackets?
  1. @
  2. $
  3. !
  4. #
C
Q.11: In Microsoft Access which option is used to create a database from scratch?
  1. New Database
  2. Blank Database
  3. Blank Template
  4. New Template
B
Q.12: In Microsoft (MS) Access database which button is clicked to start the search?
  1. Open
  2. Next
  3. Search
  4. Find
D
Q.13: In MS Access which method is used to create a table?
  1. Creating tables using wizard
  2. Creating tables in design view
  3. All Options
  4. Creating tables by entering data
C
Q.14: Microsoft Access is a member of……………?
  1. MS Windows
  2. Apple
  3. MS Office Suite
  4. Android
C
Q.15: In MS Access---------.rule states that a record from the table cannot be deleted if it is linked to another table record?
  1. Normalization
  2. Referential Integrity
  3. Ruled Integrity
  4. Rare Integrity
B
Q.16: In Microsoft Access database memo data type can store characters up to?
  1. 5000
  2. 6500
  3. 65000
  4. 65
C
Q.17: In MS Access which wildcard matches any single numeric character?
  1. !
  2. @
  3. $
  4. #
D
Q.18: In Microsoft (MS) Access database how many table views are available?
  1. 3
  2. 2
  3. 5
  4. 7
B
Q.19: MS Access consists of four components used to store or manipulate data is known as?
  1. Tools
  2. Entries
  3. Objects
  4. Property
C
Q.20: In MS Access which wildcard matches any number of characters in a string?
  1. !
  2. @
  3. #
  4. *
D
Q.21: In Microsoft MS Access…………….view is used to edit, add or delete data from a table?
  1. Electronic sheet view
  2. Datasheet view
  3. Digital sheet view
  4. Database sheet view
B
Q.22: Choose the correct option related to four objects of MS Access database?
  1. All Options
  2. Tables, Forms, Queries, Reports
  3. Data, Forms, Queries, Reports
  4. Tables, Files, Queries, Reports
C
Q.23: Which of the following extension specifies the Microsoft Access database file?
  1. .db
  2. .mdb
  3. .data
  4. .database
B
Q.24: In MS Access which of the following is used to enter, modify and view data from the records?
  1. Forms
  2. Tables
  3. Reports
  4. Queries
A
Q.25: In Microsoft Access the query “B[ae]ll” finds?
  1. Ball,bill
  2. All Options
  3. Ball, Bell, But not bill
  4. Ball,Bell,Bill
C
Q.26: Microsoft Access table contains which type of elements?
  1. Fields
  2. All Options
  3. Characters
  4. Records
B
Q.27: In Microsoft MS Access the query “wh*” finds?
  1. What, wear, why
  2. All Options
  3. What, white, why but not wear
  4. What, well
C
Q.28: In Microsoft Access maximum number of fields that we can create is?
  1. 255
  2. 155
  3. 300
  4. 200
A
Q.29: In Microsoft Access database IDE stands for?
  1. International Development Environment
  2. Intel Development Engine
  3. Intel Development Environment
  4. Integrated Development Environment
C
Q.30: Microsoft Access stores all the data and defines the structure in………………?
  1. Forms
  2. Tables
  3. Reports
  4. Files
B
Q.31: In Microsoft Access in which view data is entered in tables?
  1. Normal View
  2. Datasheet View
  3. Database View
  4. Data View
B
Q.32: In Microsoft Access ………………corresponds to the columns of a table?
  1. Data
  2. Fields
  3. Files
  4. Records
B
Q.33: Choose the default data type in Microsoft Access database?
  1. All Options
  2. Number
  3. Numeric
  4. Text
D
Q.34: Microsoft Access RDBMS enables us to?
  1. Store Information
  2. Manipulate Information
  3. All Options
  4. Create a database
C
Q.35: In MS Access which of the following option is NOT available in design view?
  1. Data types of each field
  2. Data Types
  3. Field names
  4. Contents of each filed
B
Q.36: In Microsoft MS Access………………..menu is used to switch between table views?
  1. Tools
  2. View
  3. File
  4. Data
B
Q.37: Choose the correct full form of RDBMS?
  1. Relational Database Management Software
  2. Relational Data Management System
  3. Relation Data Management System
  4. Relational Database Management System
D
Q.38: In Microsoft Access a report is a collection of related..………….?
  1. Data
  2. Rows
  3. Fields
  4. Records
C
Q.39: In RDBMS a single piece of information is known as?
  1. Entity
  2. Property
  3. Attribute
  4. Record
C
Q.40: In MS Access which of the following is used to retrieve and present data from the database?
  1. Queries
  2. Forms
  3. Tables
  4. Reports
D
Q.41: In Microsoft (MS) Access database which criteria is used to find the three character name starting with Z?
  1. Z??
  2. ??Z
  3. Z##
  4. Z@@
A
Q.42: In MS Access the smallest meaningful unit of data is known as?
  1. Field
  2. Character
  3. Record
  4. Query
A
Q.43: Choose the default field size of text data type in Microsoft Access database?
  1. 355
  2. 300
  3. 200
  4. 255
D
Q.44: In Microsoft Access which of the following is displayed in the title bar of an opened database?
  1. Object Type
  2. All Options
  3. Program Name
  4. Database Name
B
Q.45: In MS Access every field in the table contains?
  1. Data number only
  2. All Options
  3. Field name and data type
  4. Filed name and data number
C
Q.46: In Microsoft Access ………………corresponds to the rows of a table?
  1. Data
  2. Records
  3. Fields
  4. Files
B
Q.47: In Microsoft (MS) Access database which of the following view is used to define the structure of a table?
  1. Relationship
  2. Datasheet
  3. Design
  4. Structure
C
Q.48: In Microsoft MS Access which of view looks like an electronic spreadsheet like Google sheets?
  1. E sheet
  2. Database sheet
  3. Digital sheet
  4. Datasheet
D
Q.49: In MS Access which symbol shows that you are in editing mode?
  1. Pencil
  2. Arrow
  3. Eye
  4. Key
A
Q.50: In Microsoft Access the query “1#5” finds?
  1. All Options
  2. 105,115 and 125
  3. 205,215 and 225
  4. 501,511 and 521/li>
B
Previous Post
Next Post
Easy MCQs

Related Posts

Advertisement