229k views
1 vote
A column in the results of a Microsoft Access query can be formed from?

1) A table column
2) A query column
3) A constant
4) A calculation
5) All of the above

1 Answer

3 votes

Final answer:

A column in the results of a Microsoft Access query can be formed from a table column, a query column, a constant, and a calculation.

Step-by-step explanation:

In Microsoft Access, a column in the results of a query can be formed from all of the options listed (1) a table column, (2) a query column, (3) a constant, and (4) a calculation. A column in the results of a Microsoft Access query can be formed from a table column, a query column, a constant, and a calculation.

For example, a column can be formed from a table column by simply selecting that column in the query design or SQL statement. A column can also be formed from a query column by including it in the SELECT statement. Additionally, a column can be formed from a constant by entering a value directly in the query design or SQL statement. Finally, a column can be formed from a calculation by using mathematical operators and functions in the SELECT statement.

User Andrew Laughlin
by
8.1k points