a virtual field called NumberOfOrders. You could use the GROUP BY clause in this instance to group the orders by EmployeeID as follows:   SELECT EmployeeID, Count(Quantity) AS NumberOfOrders FROM Orders GROUP BY EmployeeID   The result would be as follows: EmployeeID NumberOfOrders 1 2 3 1 4 1 5 2   The result is based on the fact that employees 1 and 5 made two orders each while employees 3 and 4 made one order each. The INSERT Statement Collecting information from your users is not uncommon and, in most cases, it is a necessity. When you collect information such as registration information, you're not querying data, but rather you're inserting data into the database. In our Dorknozzle example for instance, we'll create an Admin page that allows administrators to insert new employees into the database. To illustrate this point, consider the Employees table and some of the fields that make it up: Field Name Date Type EmployeeID AutoNumber DepartmentID Number Name Text Username Text Password Text Email Text Phone Text Headshot Text BillingShippingAddress Text BillingShippingCity Text BillingShippingState Text BillingShippingZip Text   You could easily insert a new record into the Employees table using the following INSERT statement:   INSERT INTO Employees (DepartmentID, Name, Username, Password, Email, Phone, Headshot, BillingShippingAddress, BillingShippingCity, BillingShippingState, BillingShippingZip) VALUES (1, 'Zak', 'zak', 'zak', 'zak@modulemedia.com', '5555555555', 'Images\head_zak.gif', '555 Sample St.', 'San Diego', 'Ca', '92115')   The preceding statement inserts all the values you specified into the proper columns within the Employees table. The INSERT keyword generally uses the following elements: INSERT The INSERT keyword is used to identify the statement or action you are attempting to perform on the database. INTO The INTO keyword specifies that you are inserting something into a specific table. Table name The name of the table into which you want to insert the values.