From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Manage fields
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Manage fields
- In this video we will review how to best manage your fields in your tables. We'll look at how to add and remove fields. How to change data types. And how to change field properties, such as captions, field size, default values and how to auto-increment a field. Let's jump into our manage fields database. And we're going to work with our employee data table. Now there's two ways to make changes to the fields in your table. You can right click on the tab and go to design view and make all of your changes here. So in this view we see each of the field names. On the right hand side we see each of the data types assigned to them. Right off we see that ID is our primary key field. Remember that means no duplicate information. And it's set to auto-number. Which means every time we add a new record, it will incrementally increase the record number. The department field has a data type of short text. And if I look down 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.