So far we've taken a look at creating navigation forms to move around our…database, we've created a reference form in our employee directory and we've…created a form that looks up orders that include a particular product.…Let's now create a form that can be used to import records into our data tables.…We'll create a form that can be used to capture information about new customers.…I'm going to close our Main Menu window here and I'm going to click once on my…DirectCustomers table and go to the Create tab and by clicking on Form we'll…build a quick form that I can then edit.…So, there's my form here, it's showing me data at the top and if I scroll down I…can see that Access automatically put in a subform.…
Let's go into Design View.…I'll change my View to Design View and we'll clean this up.…First, I'm going to scroll down and I'm going to get rid of that subreport.…I'll click on it and press Delete.…I'm going to scroll back up.…Next, I want to get rid of these headers.…So, I'll click on the Detail section and then right-click and turn off…
- 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.