Answer
See explanation
Work Step by Step
The current version of SQL is called ANSI SQL-92 and a major feature upgrade from the second version of SQL called ANSI SQL-89. Microsoft Access, however, generally uses the earlier ANSI SQL-89 version. For this, some features of the SQL-92 language will not work in Microsoft Access.
Microsoft Access supports a subset of SQL-92 with its own syntax and limitations.
Access has its own set of data types (e.g., Text instead of VARCHAR, Currency instead of DECIMAL).
SQL-92 statements using types not recognized by Access will fail.
Access has its own list of reserved words, which may conflict with table or column names in standard SQL-92.
SQL statements fail when they use features, types, syntax, or functions not supported or implemented differently in Access.
