401 to 493 MCQ Questions for MS Access

Questions:

401. It is a query that when run displays its own dialog box prompting you for information, such as

a. Select
b. Crosstab
c. Parameter
d. Append

402. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,

a. Parameter
b. Select
c. Crosstab
d. Append

403. It is a sign or symbol that specifies, operator, and values that produce a result

a. Operator
b. Query
c. Expression
d. None of the above

404. Which of the following database object is created first before any other created?

a. Table
b. Form
c. Report
d. Query

Q. Visit MCQ Sets for

a. Multiple Choice Questions Collection
b. Download MCQ Banks
c. Attempt online quiz
d. Study subjective questions/answers

405. This type of database contains multiple tables that are connected to produce combined output from all tables.

a. Bound
b. Linked
c. Relational
d. Joined

406. The ‘filter by selection’ allows you to filter those records

a. That match the selected field
b. That match the criteria specified
c. That meet any of several criteria specified
d. All of above

407. The operation of checking input data against specified criteria is known as?

a. Data verification
b. Data validation
c. Cross check
d. Data control

408. Some rules are set in databases to check and permit only correct values. What is this feature called?

a. Data verification
b. Auditing
c. Data filtering
d. Data validation

409. 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. None of above

410. What it is called to present information in a particular order based on numeric or alphabetical value?

a. Sorting
b. Searching
c. Arranging
d. Cropping

411. A collection of related records in database is known as a

a. Table
b. Database
c. File
d. None of above

412. A part of database that stores complete information about an entity such as employee, sales, orders etc.

a. File
b. Record
c. Field
d. Query

413. To create this, you enter an expression in the design grid that instructs access to perform a calculation using the current field values.

a. Formulated field
b. Numeric field
c. Formula field
d. Calculated field

414. The ascending order of data hierarchy is?

a. Bit – byte – field – record – file – databse
b. Bit – byte – record – field – file – database
c. Byte – bit – field – record – file – database
d. Bit – byte – field – record – database – file

415. Which of the following database object can be used if you need to mail the invoice to customers?

a. A form
b. A query
c. A report
d. A table

416. When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from a-z

a. ?
b. !
c. #
d. \

417. In access, this displays the results of a calculation in a query

a. Lookup field
b. Calculated field
c. Source field
d. Child field

418. In access, this operation copies a backup file from the storage medium back onto the computer

a. Recreate
b. Restore
c. Copy
d. Structure

419. If you make an invalid entry in the input mask wizard dialog box, this will display to advise you that the entry is not correct

a. Text error
b. Validation error
c. Literal error
d. Entry error

420. In the form wizard dialog box, the fields from the selected table are displayed in this list box.

a. All fields
b. All records
c. Available records
d. Available fields

421. This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.

a. Tabular
b. Justified
c. Columnar
d. Datasheet

422. This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.

a. Columnar
b. Justified
c. Datasheet
d. Tabular

423. This form displays multiple records, one per row, in the form window

a. Datasheet
b. Tabular
c. Columnar
d. Justified

424. In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.

a. Datasheet
b. Tabular
c. Justified
d. Columnar

425. Which of the following is not a form style available in the form wizard dialog box.

a. Blends
b. Standard
c. Stone
d. Highlights

426. You can move between fields in a form by using any of these keys except

a. Tab
b. Enter
c. Shift+tab
d. Page up

427. Queries are based on this, allowing you to use a query as the source for forms and reports

a. Filters
b. Tables
c. Records
d. Fields

428. This type of query summarizes large amounts of data in easy-to-read, row-and-column format.

a. Crosstab
b. Columnar
c. Select
d. Action

Q. Visit MCQ Sets for

a. Multiple Choice Questions Collection
b. Download MCQ Banks
c. Attempt online quiz
d. Study subjective questions/answers

429. Which of the following is not one of the methods available in the new query dialog box to create queries?

a. Design view
b. Crosstab query wizard
c. Simple query wizard
d. Datasheet view

430. This query wizard will create a select query.

a. Crosstab
b. Find duplicates
c. Simple
d. Design view

431. The quickest way to add a field to the selected fields list is to double-click its field name in this list.

a. Find fields
b. Search fields
c. Search record
d. Available fields

432. The result of a query is displayed in a

a. Record
b. Query datasheet
c. Query table
d. Form

433. Changing the order of this in the query datasheet does not affect the field order in the table.

a. Record
b. Row
c. Column
d. Sort

434. In the second subform wizard dialog box you specify the table to use as the data source and the

a. Records from the selected form
b. Form from the selected table
c. Fields from the selected table
d. Content from the selected form

435. This is not one of the sections of the form design window

a. Form footer
b. Form content
c. Form header
d. Form detail

436. When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.

a. Text
b. Form
c. Label
d. Field

437. In access, this view is used to create and modify the structure of a form.

a. Normal
b. Datasheet
c. Form design
d. Control

438. To set a password for the database, select ____________ in the Microsoft Access open window.

a. Open read only
b. Open write only
c. Open explicit
d. Open exclusive

439. To enter the input mask wizard

a. Click on the three dots to the right of the caption entry field
b. Click on the three dots to the right of the format entry field
c. Click on the input mask toolbar
d. Click on the three dots to the right of the input mask entry field

440. Saving a database in access is done

a. At the beginning of the database
b. The first time you save data
c. When closing the application
d. During auto save

441. The file extension for an access 2003 database is

a. Exe
b. Doc
c. Exc
d. Mdb

442. Which of the following best describes the grouped report?

a. A part of report that can be generated by the report wizard
b. A report that displays data that has been sorted in ascending or descending order
c. A report that displays data grouped by fields you specify
d. None of a the above

443. What is the use of description field in table design window?

a. The description will be displayed on status bar when entering data in datasheet view
b. The description will be displayed on status bar when entering data in form
c. Both of above
d. None of a the above

444. How can you display the related records from other tables in datasheet view?

a. Click on the expand indicator next to the record
b. Double click on the record to expand it
c. Apply filter by command to display related records
d. All of above

445. Which of the following query type is best suitable to analyze data?

a. Cross tab queries
b. Parameter queries
c. Action queries
d. None of above

446. Which of the following is a database management system?

a. Ms word
b. Ms excel
c. Oracle
d. Lotus 1-2-3

447. In relational database schema each tuple is divided into fields known as?

a. Relations
b. Queries
c. Records
d. Domains

Q. Visit MCQ Sets for

a. Multiple Choice Questions Collection
b. Download MCQ Banks
c. Attempt online quiz
d. Study subjective questions/answers

448. Which of the following columns does not exist in macro design window?

a. Arguments
b. Comments
c. Conditions
d. Actions

449. What is the type of query that extracts data from a table and puts them into separate table?

a. Parameter query
b. Make table query
c. Update query
d. Put table query

450. What type of control in a form can display data from database table?

a. Bound control
b. Unbound control
c. Both of above
d. None of above

451. To display value from table for a label control

a. Set teh control source and record source prom property panel
b. Choose the databse, table, field and select data value to display
c. Look at the table and type value in the caption
d. Set the record source property and then control source

452. Which of the following is not a section in report design window?

a. Report header section
b. Page header section
c. Summary section
d. Report footer section

453. You can not import data into access database from

a. Dbase iii database files
b. Excel spreadsheets
c. Comma delimited text files
d. None of the above

454. Which control does access use to link data access page components to Access data?

a. Microsoft dynamic data control
b. Microsoft data connection control
c. Microsoft office data source control
d. None of the above

455. which program do you use to edit code for data access pages?

a. Microsoft script editor
b. Microsoft code editor
c. Microsoft data access pages editor
d. None of above

456. the way a particular application views the data from the database that the applicaton uses is a

a. Module
b. Relational model
c. Schema
d. Sub-schema

457. which of the following is a database management system?

a. Ms-word
b. Lotus 1-2-3
c. Oracle
d. None of above

458. what is the corresponding text for the <#1/1/95# validation rule setting?

a. Neter a value less or more than 1,195
b. Value must be less than 95 characters
c. Enter a date before 1995
d. All of above

459. what is the name of the visual basic editor utility that allows you to view the Microsoft Access type library’s available objects and members?

a. Object viewer
b. Object browser
c. Type library spy
d. None of above

460. a computer language for informing the dbms regarding the data structure used is

a. Pascal
b. Ddl
c. Prolog
d. Fortran

461. which of the following is not a data type

a. Picture/graphic
b. Data/time
c. Texst
d. Number

462. the executive responsible for the data processing function in an organization is

a. Pm
b. Dbms
c. Dp
d. Dpm

Q. Visit MCQ Sets for

a. Multiple Choice Questions Collection
b. Download MCQ Banks
c. Attempt online quiz
d. Study subjective questions/answers

463. which of the following is not a type of Microsoft Access database object?

a. Queries
b. Workbooks
c. Forms
d. Tables

464. a file containing relatively permanent data is

a. Random file
b. Transaction file
c. Master file
d. Sequential file

465. the complete picture of data stored in database is known as

a. Record
b. Scheme
c. System flowchart
d. Dbms

466. a subset of characters within a data field is known as

a. Record
b. File
c. Data string
d. Byte

467. data items groped together for storage purposes are called a

a. Record
b. Title
c. List
d. String

468. which of the following terms does not describe a database structure used by a dbms to link data from several files?

a. Relational
b. Structural
c. Network
d. All of the above

469. in a relational schema, each tuple is divided into fields called

a. Relations
b. Domains
c. Queries
d. All of the above

470. how do you filter by selection?

a. Right click the field value and select filter by selection from the shortcut menu
b. Find and double click the value on which you want to base the filter
c. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
d. None

471. what is a fast way t adjust the width of a column?

a. Right click the left side of the column heading
b. Double click the left side of the column heading
c. Double click the right side of the column heading
d. Select tools>adjust column width from the menu

472. what are the columns in a Microsoft Access table called?

a. Rows
b. Fields
c. Cells
d. Records

473. how do you update pivot table report data after changes are made to the source data?

a. Save your changes, close the workbook, and then reopen it.
b. Select the pivot table worksheet and press f9 on the keyboard
c. Click the report, and on the pivot table toolbar, click the refresh data button
d. All of the above

474. In access, the best types of queries to use for data analysis are:

a. Select queries
b. Parameter queries
c. Action queries
d. All of the above

475. How can you add a table to the relationship window?

a. Select tools>add table from the menu
b. Select the table from the table list on the toolbar
c. Click the show table button on the toolbar
d. Select edit>add table from the menu

476. What is the first step in creating a form or report with the form wizard or report wizard?

a. Selecting the fields that you want to appear in the form or report
b. Selecting the underlying table or query on which you want to base the form or report
c. Reading several screens of mostly useless information and clicking next
d. Selecting how the form or report should be formatted

477. Which action will optimize your database performance?

a. Set the record set type to snapshot
b. Use the compact and repair database tool
c. Create a replica of the database
d. All of the above

478. The arranging of data in a logical sequence is called

a. Sorting
b. Classifying
c. Reproducing
d. Summarizing

Q. Visit MCQ Sets for

a. Multiple Choice Questions Collection
b. Download MCQ Banks
c. Attempt online quiz
d. Study subjective questions/answers

479. According to access help, what’s a good way to design a database?

a. Start from data access pages and work backward
b. Sketch the design of your database using a pencil and paper
c. Use the table analyzer to reverse-engineer your flat source data.
d. None of above

480. If a piece of data is stored in two places in the database, then a

a. Storage space is wasted
b. Changing the data is one spot will cause data inconsistency
c. It can be more easily accessed
d. Both a and b

481. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As

a. Tables
b. Relations
c. Tuple
d. Both a and b

482. Which of the following database objects asks a question of information in a database and then displays the result?

a. Tables
b. Reports
c. Queries
d. Forms

483. What data type should yo choose for a zip code field in a table?

a. Text
b. Number
c. Memo
d. All of above

484. In order to use dbms, it is important to understand

a. The physical schema
b. All sub schemas that the sytem supports
c. One sub schema
d. Both a and b

485. A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be

a. The pin code
b. The last name
c. A compound key consisting of the first name and the last name
d. All of the above

486. What happens when you add the asterisk (*) from any field list ot a query?

a. The table will not include any fields from the table
b. The query sorts the table’s record in the order you specify
c. The query will include every field from the table
d. The query uses the records from the table without displaying them

487. Which editor was provided for use with access basic?

a. The visual basic 1.0 editor
b. Notepad
c. The quickbasic editor
d. All of above

488. The filter by selection feature allows you to filter:

a. Those records that match an entity in a field
b. Records based on a criterion you specify
c. Records that meet any of several criteria you specify
d. All of above

489. What is the memo data type field used for?

a. To add table
b. To store objects created in other programs
c. For long text entries
d. For shout text entries of no more than 255 characters

490. What is the purpose of the description column in table design view?

a. To define the data type applied to each field within the table
b. To describe the data that should be entered in each field
c. To enter lookup data that the field should refer to.
d. None of the ablve

491. What is the propose to a sub datasheet?

a. To provide a hierarchial view of related tables or queries in a single window
b. To display grouped data in a report
c. To display summarized data.
d. All of the above

492. Which of the following is not a selection technique

a. To select a word, double click the word
b. To select an entire table click the empty bosx to the left of the field names
c. To select a row, click the record selector box to the left of the row
d. To select a column, double click anywhere in the column

Q. Visit MCQ Sets for

a. Multiple Choice Questions Collection
b. Download MCQ Banks
c. Attempt online quiz
d. Study subjective questions/answers

493. How can you display pivot table report summary data in a currency format?

a. Use custom calculation
b. Type in the currency symbol
c. Modify the field settings
d. None of the above

Answers:

Click the Like, Tweet or Google+ buttons below to show correct answers:

[l2g]

Q.No-Correct Answer

401 – c	402 – c	403 – a	404 – a	405 – c	406 – a	407 – b	408 – d	409 – a	410 – a
411 – a	412 – b	413 – d	414 – a	415 – c	416 – a	417 – b	418 – b	419 – b	420 – d
421 – c	422 – d	423 – a	424 – c	425 – d	426 – d	427 – b	428 – a	429 – d	430 – c
431 – d	432 – b	433 – c	434 – c	435 – b	436 – b	437 – c	438 – d	439 – d	440 – a
441 – d	442 – c	443 – c	444 – a	445 – a	446 – c	447 – d	448 – c	449 – b	450 – a
451 – d	452 – c	453 – d	454 – c	455 – a	456 – d	457 – c	458 – a	459 – b	460 – b
461 – a	462 – b	463 – b	464 – c	465 – b	466 – c	467 – a	468 – b	469 – b	470 – a
471 – c	472 – b	473 – c	474 – a	475 – b	476 – b	477 – b	478 – a	479 – b	480 – d
481 – d	482 – c	483 – a	484 – c	485 – c	486 – c	487 – b	488 – a	489 – c	490 – b
491 – a	492 – d	493 – c

[/l2g]