Practice Test: Question Set - 30
1. Which editor was provided for use with access basic?
- (A) The visual
basic 1.0 editor
- (B) Notepad
- (C) The quick basic
editor
- (D) All of above
2. 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
3. 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
4. If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
- (A) Foreign key
- (B) Native key
- (C) Composite
key
- (D) Primary key
5. After creating the table which of the following is correct?
- (A) Fields
cannot be added
- (B) Fields
cannot be deleted
- (C) Fields can
added but only once
- (D) Fields can
added and deleted as needed
6. On the property sheet, which of the following tabs contains the Caption property?
- (A) Data
- (B) Event
- (C) Format
- (D) Other
7. You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting would have how many records?
- (A) 7
- (B) 17
- (C) 60
- (D) Not enough
information to tell
8. Which is NOT an option of the Picture Size Mode property?
- (A) Clip
- (B) Fit
- (C) Stretch
- (D) Zoom
9. Which of the following field properties is an expression that specifies criteria or requirements for entering data?
- (A) Field Size
- (B) Format
- (C) Input Mask
- (D) Validation
Rule
10. The __________ performs document tracking.
- (A) Distributed
application
- (B) Enterprise
software
- (C) Oracle
software
- (D) EDM software
11. Which of the following statement is true?
- (A) Reports can
be used to retrieve data from tables and calculate
- (B) Queries can
be printed in well formatted manner and presented as the information
- (C) Queries can
include calculated fields that do not exist in table
- (D) Reports and
forms are similar but forms are use to print but reports to display on screen
only
12. 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
13. The file extension for an access 2003 database is
- (A) Exe
- (B) Doc
- (C) Exc
- (D) Mdb
14. A computer language for informing the dbms regarding the data structure used is
- (A) Pascal
- (B) Ddl
- (C) Prolog
- (D) Fortran
15. 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
Next Tests:
Blogger Comment
Facebook Comment