Microsoft Office Tutorials and References
In Depth Information
The DELETE Statement
figurE 24-1
You’ll notice an important distinction between an Access table and an Excel worksheet. Database
tables do not have row headers as numbers, or columns designated by letters. Columns (called fields in
a database environment) rely on being identified by their field headers such as FirstName, LastName,
and so on. Rows (called records ) rely on being identified by one or more key fields, or certain
properties of other fields such as being empty ( Null ) or having date entries between a start date and end date.
You might also want to surf the Web for sites that list SQL objects and their associated properties
and methods. Keep in mind that SQL’s capacity for database interaction goes far beyond what you’ll
need it to do for your Excel projects, so stick with the basics for now when perusing SQL
instructional material.
Search JabSto ::

Custom Search