From the course: Microsoft Access Essential Training (Office 2024/LTSC)

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Table structures and data types

Table structures and data types

From the course: Microsoft Access Essential Training (Office 2024/LTSC)

Start my 1-month free trial Buy for my team

Table structures and data types

“

- [Instructor] Tables provide the foundation for any good database, and the success of the database, how well it functions, and how flexible it is to future growth often comes down to the structure of the tables that house your data. Understanding how tables function in Access is key to creating a well-structured database. Unlike Excel spreadsheets, tables in Access follow a very strict design model, where rows and columns have a specific purpose. In a database table, horizontal rows are called records. Records are an unbroken chain of properties that describe a single entity. For instance, in an employee table, you would have a record for each individual in the company, so each row in the table would describe one specific person. Fields are the vertical columns in a table. Each field in a table is a single descriptive property that is being tracked. In a well-designed database table, each field stores just a single piece of information, and they're broken down into the smallest unit…

Contents