ms access Interview Questions and Answers
Ques:- The default and maximum size of text field in access
A. 50 and 255 characters
B. 266 characters and 6400 characters
C. 288 characters and 6880 characters
D. 299 characters and 6499 characters
Ques:- In MS Access, OLE objects Data type can store
A. Microsoft Excel Spreadsheets
B. Microsoft Word documents
C. Sounds
D. All of the above
Ques:- A part of database that stores complete information about an entity such as employee, sales, orders etc.
A. Record
B. File
C. Field
D. Query
Ques:- In table design view, which key can be used to switch between the field names and properties panels?
A. F1
B. F6
C. F10
D. F12
Ques:- To create queries in Access
A. You can drag and drop fields on query builders
B. You can type the SQL command in SQL view
C. You can use query wizard or design view
D. All of the above
Ques:- Which of the following is not a selection technique?
A. To select a row, click the record selector box to the left of the row
B. To select a column, double click anywhere in the column
C. To select a word, double click the word
D. To select an entire table click the empty box to the left of the field names
Ques:- To create a table in MS Access
A. Database should be created before creating a table
B. You should allow atleast one Primary key in a table
C. Table can be created using Table Templates
D. All of the above
Ques:- Database access levels are specified so as to define who can access what in a database, it is identified through
A. User ID
B. Password
C. Status
D. All of these
Ques:- What is a database?
A. It is a collection of data arranged in rows
B. It is a collection of data arranged in columns
C. It is a collection of data arranged in rows and columns
D. All of the above
Ques:- The option allows you to build a new table by entering data directly into the datasheet.
A. Datasheet view
B. Design view
C. Link table
D. All of the above
Ques:- Queries in Access can be used as
A. View, change and analyze data in different ways
B. A source of records for forms and reports
C. Both a and b
D. None of these
Ques:- To sort records in a table
A. Open table, click on the field on which the sorting is to be done, then click sort button on database toolbar
B. Click the field heading to sort it ascending or descending
C. Open table, click sort button on database toolbar, choose field based on which to sort, click ok
D. All of the above
Ques:- In MS Access “Lookup Wizard†is used to
A. to select value from another table
B. to select values from Excel Sheet
C. to select from previous values
D. not a valid data type
Ques:- The command center of access file that appears when you create or open the ms access database file.
A. Switchboard
B. Design view Window
C. Database Window
D. Query Window
Ques:- In MS Access, Text data type may contain maximum character of
A. 255 character
B. 256 character
C. 1064 character
D. No limit
Ques:- Press _____ to cyle between open windows.
A. Ctrl + F4
B. Ctrl + F6
C. Ctrl + F7
D. Ctrl + F12
Ques:- You can automatically include all of the field in a table in a query by _____ a strike that appear list box in query design view.
A. Double clicking
B. Right clicking
C. Clicking
D. All the above
Ques:- _____ key is uniquely identifies each record.
A. Field Name
B. Unique key
C. Primary key
D. Key record