If you want to add or remove rows from a table, you’ll need yet ANOTHER different view:
This is known as the Datasheet View. Look at the very top of this view … each column has a header in light gray. That represents the name of each column. This will coincide with each column in the database table.
The each record is represented in the rows below the first row (the header row). Each row has a set of data values that correspond to each column in the table. Again, this looks a lot like an Excel spreadsheet. We can add a new row by typing into the last row of the table, and moving to the next line. OR we can create a program that allows a user (or many users) to add new records into our database without having to use Microsoft Access. The reason we would want to do that is to provide a more user-friendly interface to the end user, or to prevent the user from modifying the data in a way that violates our business’ practices or policies. These are called “Business Rules” … we use that term often, since that is the reason why many of us are gainfully employed as programmers … to create programs that enforce business rules.
Each column can have several properties associated with it. For example, each column will have a name, a data type (just like variables have), and depending on the data type, a size.
Additionally, columns can be used to AutoNumber so they make good columns for identifiers (or IDs … special columns used in primary/foreign key relationships.)
Supplemental Readings for the Express Edition Videos Copyright © 2005 LearnVisualStudio.NET