Join Adam Wilbert for an in-depth discussion in this video Exploring the database, part of Access 2007: Forms and Reports.
One of the main ideas behind creating Forms and Reports is to allow your…end-users to be able to work with the database without knowing a whole lot…about its structure.…You as a database designer, on the other hand, need to have some familiarity with…the data tables within the database in order to be able to work with them.…Let's take a look at the Two Trees Olive Oil company database that we will be…working with throughout this course.…In my navigation pane on the left, I've got all of the data tables we'll be working with.…I have got a table for Orders, a table for Customers, Employees, Products, and so on.…
Let's go ahead and double-click on the Orders table and take a look at what's inside.…And within the Orders table, I have got fields for the Order ID, the Order Date,…Customer ID, Product ID, and Salesperson ID.…Now all these ID numbers reference other fields and other data tables.…So for instance, Customer ID here is linked to Direct Customers table and if I…open up that, I can find the customer that was associated with the order by…
- 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
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. The User Experience
- 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.