1) What is the primary purpose of a query in Microsoft Access? a) To create forms for data entry b) To generate reports for printing c) To retrieve and manipulate data from tables d) To design user interfaces 2) What type of function in Microsoft Access is commonly used to calculate the total sales amount for a specific product category? a) TEXT function b) COUNT function c) AVG function d) SUM function 3) What does the criteria in an Access query specify? a) The layout of the query results b) The data source for the query c) The conditions that records must meet to be included in the results d) The sorting order of the query results 4) Which Access function is used to find the average value of a numerical field in a query? a) MIN b) MAX c) AVG d) COUNT 5) What does an action query in Microsoft Access allow you to do? a) Create forms for data entry b) Generate reports for printing c) Perform operations such as updating, appending, or deleting records d) Design macros for automating tasks

Access Queries

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?