How are SQL views handled in Microsoft Access? What will be an ...

[Mr. Wonderful]

How are SQL views handled in Microsoft Access?
 
  What will be an ideal response?

Question 2

What is the least restrictive isolation level that will prevent dirty reads?
 
  A) Read Committed
  B) Serializable
  C) Read Uncommitted
  D) Atomic Read
  E) Repeatable Read

[ansleighelindsey]

Answer to Question 1

Microsoft Access does not support views directly. But since an SQL view is essentially a stored query, Microsoft Access queries can be used to implement SQL view equivalents. Standard Microsoft Access queries can then use previously stored view equivalent Access queries the same way an SQL SELECT statement is used to retrieve SQL views.

Answer to Question 2

A