What is a table record and how do I enter one in Access 2007? A Table record is a collection of related fields or cells. For example, say you want to keep track of your client's name, phone number, address etc., and each element just listed would have it's own field. And so the collection of those fields that includes all the fields that relates to another field makes up a record for each client. When it comes to saving all those fields say for client Dream Force, you'll be saving the record. In other words, Access won't save the data entered into a field in and of itself, but on a whole as part of saving the record. You can save the record by holding the Shift key and hitting Enter as one way to save.

Purchase the training video and you can see this in action for yourself!