Gent - Access Test 1

Gent Technologies - www.gent.ie - Free Online Practice Tests

Quick Links
Excel Test 1 Excel Test 2 Excel: Selecting Cells Excel: Forumlas Excel: Cell Referencing Word Test 1 Word Test 2 Word Test 3 PowerPoint Test 1 Access Test 1 Internet Test 1

Access Test 1

Test Instructions
You may use Access to do this test. You should not use notes or books. Only use Access and its associated help files.

1. Which one of the following is not an important planning and design consideration for a database?

Font type
Data type
Size / Length
Name

2. What is the file extension used for Microsoft Access database files?

.exe .db .mdb .dbs

3. Which Access component is best for data-entry?

Table
Report
Form
Query
View

4. Which join type is the most common?

One-to-Many
One-to-One
Many-to-Many
All of the above

5. Which Access component is best for data extraction?

Table
Report
Form
Query

6. Which one of the following is not an important planning and design consideration for a report?

Font Type
Page Orientation
Forms Used
Style

7. What is a common file extension used for Microsoft Access database export files?

.exe
.txt
.mdb
.dbs

8. Which Access component is best for data type design?

Table
Report
Form
Query

9. Which join type is the least common?

One-to-Many
One-to-One
Many-to-Many
All of the above

10. Which Access component is best for data presentation?

Table
Report
Form
Query

Your Test Result is %