MS Access 2007 - Intermediate (Post Test)

10 Questions | By Naldsauza | Last updated: Mar 16, 2022 | Total Attempts: 455

Questions

Settings

Create your own Quiz

MS Access 2007 - Intermediate (Post Test) - Quiz

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