From the course: Access: Building a Sales Database
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Create a form for each table - Microsoft Access Tutorial
From the course: Access: Building a Sales Database
Create a form for each table
- [Lecturer] So you've got your tables made. You have a customers table, a products table, an orders table, communications table, and we have a vendors table. We've got our relationships set, everything's good to go, but data entry in datasheet view is ugly. It's not fun to do, it's easy to make mistakes, it's just hard, and if entering and building customers here and I just open this up, I have to tab from column to column to column, I have to scroll when I hit the next column. I could easily be in the wrong row 'cause notice when I scrolled over here I can't see the customer name when I got to add something. It's just really ugly, so you wanna have another way to enter your records and to edit them and to view them and to search for them, and that requires forms. Now the first thing you should do after you've built all you tables, is build one form for every table. And it's easy, easy, easy, all you have to do is, let me close customers. First of all make sure everything's closed…
Contents
-
-
-
-
-
-
-
Create a form for each table2m 36s
-
Adding interactive data entry controls to a form4m 44s
-
Adding related table-based controls to a form4m 16s
-
Creating lookup controls4m 5s
-
Multiple-customer record form2m 40s
-
Create a read-only form2m 11s
-
Adding a field to a form2m 45s
-
Using tab order to change interactive form order1m 59s
-
Creating navigation buttons for forms3m 26s
-
-
-
-
-
-