When it comes to displaying data in your forms there are three objects which are…used most often, they are the Text Box, the Combo Box and a List Box.…For this exercise we're going to create a new form based off this Reviews Table.…Let me go ahead and open up the Reviews Table and you can see that this a place…where you can collect information about product reviews from our customer.…I've got a review identification number, product ID that's being reviewed,…the rating given, any comments and whether we can use this review publicly on our website.…We're going to build a form that'll add records to this table, let's go ahead…and close this table, let's go to the Create tab and we're going to Create a new…Form and Design view.…
Now the first thing I want to do when creating a new form is connect it to the…table where the data is going to go.…In the Property sheet for the Form, I'll go to the Data tab and I can set this…Record Source here by using the drop down menu to the table I want to connect it…
- Designing for the end user
- Organizing form elements
- Formatting a form
- Adding headers
- Linking to external content
- Entering and selecting data
- Adding charts
- Creating a main menu
- Creating a customer form
- Understanding report structure
- Building reports from wizards and queries
- Printing reports
Skill Level Intermediate
Managing and Analyzing Data in Excel 2010with Dennis Taylor1h 32m Intermediate
1. Introduction to Forms
2. Form-Design Basics: Creating a Directory
3. Form and Report Controls
4. Getting around the Database
5. Report Layout
6. Printing, Tweaking, and Automating
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.