Preview lessons, content and tests

Computer Science & Programming solved. All in one platform.

1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.
2. Searching for something specific? See our text overview of all tests. Includes 'real teacher' use videos.

Table Basics

At this point, you should already understand that a database is a collection of data organized into several connected lists. In Access, all data is stored in tables, which means tables are the heart of any database.

Video - Working with Tables

Additional Information

You also might already know that tables are organized into vertical columns and horizontal rows. In Access, rows and columns are referred to as records and fields. A field is more than just a column; it’s a way of organizing information by the type of data it is. Every piece of information within a field is of the same type.