Microsoft Access

What are the different views to display a table?

• (A) Datasheet view
• (B) Design view
• (C) Pivoted table & pivot chart view
• (D) All of above

Check Answer

---

Which of the following creates a drop down list of values to choose from?

• (A) Ole object
• (B) Hyperlink
• (C) Memo
• (D) Lookup wizard

Check Answer

---

The command center of access file that appears when you create or open the ms access database file:

• (A) Database window
• (B) Query window
• (C) Design view window
• (D) Switchboard

Check Answer

---

The third stage in designing a database is when we analyze our tables more closely and create a between tables:

• (A) Relationship
• (B) Join
• (C) Query
• (D) None

Check Answer

---

In a database table, information is called the category of:

• (A) Tuple
• (B) Field
• (C) Record
• (D) All of Above

Check Answer

---

This key uniquely identifies each record:

• (A) Primary Key
• (B) Key Record
• (C) Unique Key
• (D) Field Name

Check Answer

---

It is an association common established between:

• (A) Line
• (B) Relationship
• (C) Primary Key
• (D) Records

Check Answer

---

This is the stage in database design where one gathers and list all the necessary fields for the database project:

• (A) Data Definition
• (B) Data Refinement
• (C) Establishing Relationship
• (D) None of these

Check Answer

---

A database language concerned with the definition of the whole database structure and schema is:

• (A) DCL
• (B) DML
• (C) DDL
• (D) All of Above

Check Answer

---

Which of the field has width 8 bytes?

• (A) Memo
• (B) Number
• (C) Date/time
• (D) Hyperlink

Check Answer

---