Microsoft Access Quiz | Microsoft Access Multiple Choice Questions and Answers

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

Questions
1 What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
A A relationship is created
B Edit relationship dialog box appears
C Error occurs
D Nothing happens

Answer: Edit relationship dialog box appears
2 When creating a new table which method can be used to choose fields from standard databases and tables
A Create table in Design View
B Create Table using wizard
C Create Table by Entering data
D None of above

Answer: Create Table using wizard
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
3 A database language concerned with the definition of the whole database structure and schema is ________
A DCL
B DML
C DDL
D All of above

Answer: DDL
4 The command center of access file that appears when you create or open the MS Access database file.
A Database Window
B Query Window
C Design View Window
D Switchboard

Answer: Database Window
5 This key uniquely identifies each record
A primary key
B key record
C unique key
D field name

Answer: primary key
6 The size of Yes No field is always
A 1 bit
B 1 byte
C 1 character
D 1 GB

Answer: 1 bit
7 A small button with three dots usually displayed at the right of field properties box
A Make button
B Expression button
C Build button
D None of above

Answer: Build button
8 The size of a field with Number data type can not be
A 2
B 4
C 8
D 16

Answer: 16
9 The two form layout types will display multiple records at one time are tabular and___
A columnar
B justified
C date sheet
D pivot table

Answer: justified
10 This is the stage in database design where one gathers and lists all the necessary fields for the database project.
A data definition
B data refinement
C establishing relationship
D none of the above

Answer: data definition
11 Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
A Home Tab
B Create Tab
C External Data Tab
D Database Tab

Answer: Database Tab
12 The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
A relationship
B Join
C Query
D None of these

Answer: relationship
13 In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______
A Child , Parent
B Parent , Child
C Brother , Sister
D Father , Son

Answer: Parent , Child
14 Which of the following is not a database object?
A Tables
B Queries
C Relationships
D Reports

Answer: Relationships
15 To create a new table, in which method you don’t need to specify the field type and size?
A Create table in Design View
B Create Table using wizard
C Create Table by Entering data
D All of above

Answer: Create Table by Entering data
16 In a database table, the category of information is called ____________
A tuple
B field
C record
D All of above

Answer: field
17 Query design window has two parts. The upper part shows
A Name of fields, field type and size
B Tables with fields and relationships between tables
C Criteria
D Sorting check boxes

Answer: Tables with fields and relationships between tables
18 This data type allows alphanumeric characters and special symbols.
A text
B memo
C auto number
D None of the above

Answer: text
19 Cascade delete option
A is used to delete all the records of all tables in a database
B will repeat the recent delete operation to all the records of current table
C is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
D None of above

Answer: is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
20 When a picture or other graphic image is placed in the report header section it will appear____
A Once in the beginning of the report
B At the top of every page
C Every after record break
D On the 1st and last pages of the report

Answer: Once in the beginning of the report
Assam Direct Recruitment Test Series

Teacher Eligibility Test

Assam Direct Recruitment Test Series