Question

Which of the following is NOT true regarding table formatting?

1) In a table design, you can define a Format field property that customizes how data is displayed and printed in tables, queries, reports, and forms.
2) The Format property tells Access how data is to be displayed.
3) You can define your own custom formats for Currency and Number fields.
4) Formatting does not affect the way the data is stored.

Answer 1

All statements given about table formatting are true; they correctly describe the functions and implications of formatting in a database system like Microsoft Access, including that formatting only alters the data's display, not how it is stored.

Step-by-step explanation:

The question is asking which statement is NOT true regarding table formatting, particularly in the context of a database system like Microsoft Access. Here's an analysis of the statements provided:

1. In a table design, you can indeed define a Format field property that customizes how data is displayed and printed in tables, queries, reports, and forms. This is true and allows for a consistent presentation of data.
2. The Format property tells Access or any similar database program how data is to be displayed, which is also accurate.
3. You can indeed define your own custom formats for Currency and Number fields, which allows for localized or industry-specific presentations of numerical data.
4. Formatting does not affect the way the data is actually stored in the database. It only changes how data appears to the users on screen or in printed reports.

All of these statements are true regarding table formatting. Therefore, none of the provided options is a correct answer if the question asks for the incorrect statement. Each statement accurately conveys aspects of the customization and display of data through formatting while reaffirming that the underlying stored data remains unaffected.