From the course: Learning Access 2016
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understand database objects
- [Voiceover] I mentioned the various Access objects that will make up your database a couple of times now. And it's probably a good idea to pause a moment and explore exactly what each object does and what their role is in the complete system. We'll begin with the all-important table object. Tables are the heart of the database, and they're the objects that physically store your data. Tables in Access are more structured than the ones you may have previously created in a spreadsheet program, like Excel. In Access, tables are made up of horizontal rows called records that describe a single object or thing that you want to keep track of. All of the records in a table will all be the same type of entity. For instance, every record in an employees table will be a person that works for your organization. Each record in a products table would represent an individual item that you have for sale. The columns that make up your table represent different attributes about the record. In the…
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.