MS Access Interview Questions for Fresher - Set 30 - ObjectiveBooks

MS Access Interview Questions for Fresher - Set 30

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

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: