Queries That Select Records (Chapter 6 – 7). Query Basics. A Microsoft Access query is a question about the information stored in Access tables .
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
1 SELECT Products.ID, Products.ProductName, Products.Price
2 FROM Products
3 WHERE (((Products.Price)>50))
4 ORDER BY Products.Price;
PriceWithTax: [Price] * 1.10
Field Name : Expression
FullName: [FirstName] & “ “ & [LastName]
Price: "The price is: " & [Price]
SalePrice: Round([Price] * 0.95, 2)
SalePrice: [Price] * 0.95
SalePrice: Format([Price] / 0.95, "Currency")