New Training: Create Table Structures in Access 2019
In this 11-video skill, CBT Nuggets trainer Jacob Moran teaches you how to create tables in an Access database. Learn how to correctly define field properties and how to create fields, rows, keys, indexes, and data types. Watch this new Microsoft 365 training.
Watch the full course: Microsoft Access 2019 Training
This training includes:
- 11 videos
- 58 minutes of training
You’ll learn these topics in this skill:
- Introduction to Access Tables
- Creating a Basic Access Table
- Inserting and Managing Access Table Data
- Inserting Text Data Types in Access Tables
- Inserting Numeric Data Types in Access Tables
- Inserting Special Data Types in Access Tables
- Controlling Access Table Field Formats
- Pre-Validating Data in Access Tables
- Indexing Access Fields and Setting Primary Keys
- Creating Indexes and Primary Keys in Access
- Summary of Creating Tables in Access
What are Microsoft Access Tables?
At the heart of Microsoft Access are tables. Like a spreadsheet, they contain columns and rows of data. Though this data is typically very specific. For example, a table of books might include its ISBN ID, its name, its author, its price, the publisher ID, and the date published.
In Access, columns of data are called fields. For each field, you must specify its data type. For example, the title of the book is text, so it needs a Text data type. But its price is a number, so it needs a Numeric data type.
Tables generally have relationships between them. For example, like the book table, you could have a publisher table, which lists information about publishers, such as the publisher ID, its name and its address. By creating a relationship between the book and publisher tables, you can find information about the publisher through the publisher ID in the book table.