In Microsoft Access,standard SQL Table Creation Syntax Items Not Supported

question 45

Multiple Choice

In Microsoft Access,standard SQL table creation syntax items not supported by Access SQL can generally be implemented by ________.

• A) setting the Data Types in Access table Design View
• B) setting the field properties in Access table Design View
• C) setting the relationship properties in the Edit Relationship dialog box
• D) setting the referential integrity properties in the Edit Relationship dialog box
• E) running an ALTER TABLE query in Access SQL

---

Definitions:

Password

A string of characters used for authenticating a user's identity and granting access to a computer system or software.

Front-end Database

A database that is designed for the end-user interface, often providing forms, queries, and reports, and is typically connected to a back-end database where data is stored and managed.

Client-end Database

A Client-end Database is a database that resides on the client side of a client-server architecture, allowing for data storage and management on the user's device.

Split Database

A database architecture that divides the database into two parts: a front-end that contains forms, reports, and application logic, and a back-end that stores the data, enhancing security and performance.