Access Assessment

Fill in your basic details before continuing to take the Access test

Name*
Company
Email*
Phone*
Human Verification-Enter code:
1) Microsoft Access Is A ? None of the below
OODBMS
ORDBMS
RDBMS
2) What Are The Columns In A Microsoft Access Table Called ? None of the below
Records
Fields
Columns
3) In MS-Access to Open a combo box ? None of the below
DOWN ARROW
PAGE DOWN
F4 or ALT+DOWN ARROW
4) Where you can keep the sum([Sales]) to calculate the totals for each month ? None of the below
In the page footer section
In the month group footer section
In the summary section
5) What Is The Maximum Length A Text Field Can Be? None of the below
255
265
75
6) Which of the following type s of queries are action queries? None of the below
Crosstab Queries
Parameter queries
Append Querits
7) Which of the following is NOT a report section? None of the below
Summary section
Page header section
Details section
8) If you are creating a cross tab query, what must table you are querying contain? None of the below
More than 100 records
At least one field
Lots of confusing information
9) A query summarizes information in a grid, organized by regions and months. Which type of query is this? None of the below
A parameter query
An action query
A cross tab query
10) What type of text box does the toolbox and to a form? None of the below
Rebound
Calculated
Unbound
11) To create a new table, in which method you don’t need to specify the field type and size? None of the below
Create Table using wizard
Create Table by Entering data
Create table in Design View
12) Collection of related records in a database is known as ? None of the below
Bench
Table
Relationship
13) A __ name must be unique within a database ? None of the below
Field
Record
Character
14) Queries in Access can be used as ? None of the below
a source of records for forms and reports
Only A
Both A and B
15) A primary key in any table has the properties ? None of the below
No Duplicates
Both of above
Not Null
Contact us today at info@upskilltechnologies.com or call us at +91-9985130004