From the course: Microsoft Access: Forms and Reports

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Add data with a text box

Add data with a text box

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Add data with a text box

“

- [Instructor] When it comes time to display or edit data from your forms, there are three objects which you'll use most often. There are the text box, the combo box and the list box. Because these three controls work with data, we'll have to connect the blank form to a data source so that they'll work properly. I'd like to add a workflow to the base for storing product reviews. So the first step is to create a new table that'll hold the review data. I can go to the Create tab on the ribbon and we'll start a new table design window. Then we can fill in the fields on the data types. The first field will be review ID. It'll be the auto numbered data type. And I want this to be the primary of the table. It's also like that button here on the ribbon. The next field will hold the product number that we want to review. This is going to relate to the products table. So it needs to be a short text data type. Next, we'll store…

Contents