Skip to content
GK24
Computer AwarenessMedium

What is the file extension of a database created in MS Access 2007 and later versions?

  1. A..mdb
  2. B..accdb
  3. C..adb
  4. D..dbf

Correct answer

B. .accdb

Explanation

The correct answer is B, .accdb. From Access 2007 onwards, the default database format changed and files are saved with the extension .accdb, which stands for Access database and supports features such as multivalued fields and attachment data types. Option A, .mdb, was the extension of the earlier format used up to Access 2003; it can still be opened for compatibility, which is why it is the favourite distractor in this question. Option C, .adb, is not an Access format at all. Option D, .dbf, is the old dBase file format, used by dBase, FoxPro and several statistical packages, and it can be imported into Access but is not written by it. The pattern to notice is that Office 2007 added a letter to the extensions of the whole suite, giving .docx for Word, .xlsx for Excel, .pptx for PowerPoint and .accdb for Access.

Read the full article: MS Access, Outlook and Office Tools: Exam Notes

View all