Microsoft Access

To create a new table, in which method you don’t need to specify the field type and size?

• (A) Create table in design view
• (B) Create table using wizard
• (C) Create table by entering data
• (D) All of above

Check Answer

---

When creating a new table which method can be used to choose fields from standard databases and tables?

• (A) Create table in design view
• (B) Create table using wizard
• (C) Create table by entering data
• (D) None

Check Answer

---

In table design view, which key can be used to switch between the field names and properties panels?

• (A) F3
• (B) F4
• (C) F5
• (D) F6

Check Answer

---

In table design view what are the first column of buttons used for:

• (A) Indicate primary key
• (B) Indicate current row
• (C) Both of above
• (D) None of these

Check Answer

---

The default and maximum size of text field in access:

• (A) 50 and 255 characters
• (B) 8 and 1 GB
• (C) 266 characters & 64000 characters
• (D) None

Check Answer

---

The size of yes no field is always:

• (A) 1 Bit
• (B) 1 Byte
• (C) 1 Character
• (D) 1 GB

Check Answer

---

Which of the following is not a field type in access:

• (A) Memo
• (B) Hyperlink
• (C) Ole Object
• (D) Lookup Wizard

Check Answer

---

The size of a field with number data type can not be:

• (A) 2
• (B) 4
• (C) 8
• (D) 16

Check Answer

---

Which field type will you select when creating a new table if you require to enter long text in that field? 

• (A) Text
• (B) Memo
• (C) Currency
• (D) Hyperlink

Check Answer

---

Which Of The Following Creates A Drop Down List Of Values To Choose From?

• (A) Ole Object
• (B) Hyperlinks
• (C) Memood
• (D) Lookup Wizard

Check Answer

---