MS Access 2007 - Intermediate (Post Test)
10 Questions
| Total Attempts: 269
.
Questions and Answers
- 1.Table in Microsoft Access can be create by using all below except
- A.
Design View
- B.
Datasheet View
- C.
Table Wizard
- D.
Input Mask
- 2.Which data type can store more than 255 character?
- A.
Memo
- B.
Text
- C.
Long Integer
- D.
Lookup Wizard
- 3.You can use Input Mask and set the data as _______________ to make sure all data are valid to enter and not duplicate.
- A.
Primary Key
- B.
Query
- C.
Macro
- D.
Lookup Wizard
- 4.There are 3 type of Relationship that valid in Ms Access 2007, Except
- A.
One to one
- B.
One to Many
- C.
Many to Many
- D.
Interdeminate
- 5.2 ways to identify inconsistencies between data in two or more tables are either modify the join line or use a special Query Wizard
- A.
True
- B.
False
- 6.What type of queries is a queries that select records from tables based on criteria.
- A.
Action Queries
- B.
Select Queries
- C.
CrossTab Queries
- D.
Cascade Queries
- 7.What Queries are used to summarise data in tables
- A.
CrossTab
- B.
Action
- C.
Select
- D.
Cascade
- 8.Special form called Switchboard, can set up such that anybody can use your database even if they know nothing about Access
- A.
True
- B.
False
- 9.A macro holds a series of instructions (commands) such that all the instructions can be carried out simply by running the one macro.
- A.
True
- B.
False
- 10.You can __________ macros setting so that the macros run automatically for any database you open.
- A.
Disable
- B.
Enable
- C.
Ignoring
- D.
Cancelling
Back to top