From the course: Access Essential Training (Office 365/Microsoft)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Table structures and relationships
From the course: Access Essential Training (Office 365/Microsoft)
Table structures and relationships
- [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. Tables in Access follow a very strict model. Their horizontal rows are called records. Records are an unbroken chain of properties that describe a single entity. For instance, in an employees table, you would have a record for each individual in the company. Fields are the vertical columns. Each field in a table is a single property that can be tracked for each record. In a well-designed database table, each field stores just a single piece of information, such as a first name instead of the entire full name. Each field can hold data of a single data type. You can choose to store short text, up to a maximum of 255 characters, or long text, with a maximum character…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.