New Skills

New Training: Create Table Structures in Access 2019

by Team Nuggets
New Training: Create Forms in Access 2019 picture: A
Published on February 19, 2021

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.



Ultimate Systems Administration Cert Guide

A 158-page guide to every Microsoft, VMware, Citrix, AWS, Google, and Linux certification, and how they fit into your career.

By submitting this form you agree that you have read, understood, and are able to consent to our privacy policy.

Don't Miss Out

Get great content delivered to your inbox.

I have read and understood the privacy policy, and am able to consent to it.

Recommended Articles

Get CBT Nuggets IT training news and resources

I have read and understood the privacy policy and am able to consent to it.

© 2022 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522