Sunday, March 24, 2013
Sunday, March 10, 2013
Sunday, March 3, 2013
Homework:
Word Ch 3, practice and mid-level exercises
Access Ch 1, practice and mid-level exercises
Quiz:
based on Word ch 3 multiple choice
based on Access ch 1 multiple choice
What is a database:
data + methods of interacting with your data
a collection of tables
what is a table?
a collection of records
what is a record?
a collection of fields
what is a field?
approx same as column in Excel, one unit of data
SELECT DISTINCTROW TOP 10 Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC;
Subscribe to:
Posts (Atom)