RelationalDB
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Creating Forms
«Prev
Next»
Data Manipulation
Finding Sorting Filtering Data
Finding Data Table
Sorting Access Records
Sorting Access Records
Filter Records to Display Subset
Display Record Subset
Filter Records Multiple Criteria
Filter Records Complex Criteria
Advanced Filter Uses
Single Table Access Conclusion
Creating Access Queries
What are Queries
Query Access Database Window
Simple Query Wizard
Query Design View
Creating Query Design View
Save Query Design
Editing Query Design
Adding Criteria to Queries
Values in Criteria Expressions
Multiple Queries in Access
Specifying Sort Order
Creating Calculated Fields
Creating Access Forms
Access Form
Access Auto Form
Displaying Records Access Form
Edit Access Database
Create Access Forms
Form Design View
Save Access Form
Access Resize Controls
Access Form controls
Add Access Bound Controls
Toolbox Buttons Add Controls
Format form Controls Design form
Create Calculated Controls
Design Create Report
MS Access Reports
Navigating Report View
Access Mailing Labels
Report Design View
Header Footer Sections
Create a form using a Wizard - Exercise
Create a form with the Form Wizard
Objective:
Create a form to display project description and hours data with the Form Wizard.
You will receive 5 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit for the exercise is click the
Submit
button.
Use the form wizard to create a form that shows project data for one project at the top and the hours worked on that project at the bottom.
Include the following fields.
the Project table:
Company<
Project Description
Start Date
Due Date
the Hours table:
Date
Hours worked
Group the form by the data in the Projects table. This way, each project will appear in the main form, and the subform will contain the hours worked on the project.
Create a form with subforms rather than linked forms.
You may choose either Tabular or Datasheet format for the subform. Now that you have seen both, choose the layout you prefer. You can also choose the style you prefer.
Accept the default names for the form and subform and open the form to view or enter information.
Submit