Arithmetic addition of ACCESS data and data type conflicting issues

The answer is C report;

To put it simply: the report is to use **, charts and other formats to dynamically display data, which can be expressed as a formula: "report = diverse formats + dynamic data", the main role of the report is to display data, it can be understood as a tool, so it is not a data type, so the answer is C.

The correct answer is c

The analysis is as follows: numeric text, date, and time are all data types of Access, and Forms, Tables, Queries, Modules, Macros, and Modules belong to the database objects of Access, not data types.

Upstairs confuses the concept of data types. Access data types include:

So the answer to this question should be C.

I just finished reviewing Access, the data type that does not belong to Access is C report, the report is the object class of Access, and the Access database objects are: tables, queries, forms, reports, data access pages, macros, modules, and views. If it's a data type, it's what type of field those fields belong to, for example, numbers, which can be used for fractions and so on.

For example, if it is a name, you can use a text data type, in addition to the date and time, but also include the note type, automatic numbering, and so on! So the answer is C

Data is usually deposited in a table.

Generally, you can set the calculation formula in the design view of a query or report.

Query or report output.

Since the default value of a data table field cannot reference a foreign field value, an error will inevitably be reported for the field that is not referenced. Actually, it should"Amount"There's no need to actually save and maintain a field, it's very convenient to use an expression in the selection query when needed, and you can also use it"Amount"The data type is changed to a virtual calculated field, so that the calculated expression can be recognized.

The method for calculating age in the access database is as follows:

1.Open Access to create a form:

2 Enter the date of birth, e.g. 1999 12 1, click Calculate:

3 Enter the following in the Macro block:

dim birth as string

dim age as integer

birth =

age = round(datediff("y", birth, date) / 365, 0)

age

Enter Age: year(date())year([date of birth]) in the query

You can see the date of birth and automatically calculate the age by querying the generated table.

select year(now())year(from test;

Subtract the user's date of birth from the current system time, and if you want to display it directly in the database, then create a view of the above statement.

Submit one, send it to your email, I don't know if it's what you need.

There is a table that is a sales schedule, which contains the quantity, unit price, and amount, and I want the amount to be automatically generated (amount = quantity * unit price): just make a query view, and add amount = quantity * unit price to the view.

In the future, when reading data, you can read the view directly.

If you are using access2010, you can change the data type to a calculated field, and if you are using accc2003, you can use a query.

The calculated results are generally not in the table, but are generated by queries.

If you must add it, create an update query and run it once to update them all.

query the bai field.

DU name. zhi: [field dao.]

Inner1] + [Field 2].