Learner will begin working with Forms and Reports. They will create basic Forms and Reports, as well as create a Subform, Multi-Item and Split Form, Navigation Form, a Grouped Report, and a Labels Report. Additionally, learners will learn how to create an aggregate field, a Combo Box, and a Command button, and also will work more with Queries.
Course Topics:
- Restrict the type and amount of data in a field
- Specify the format of data in a field
- Restrict data by using validation rules
- Create a simple or multi-column lookup list
- Add controls to a form
- Create a form by using an AutoForm
- Add a subform to a form
- Locate information that matches multiple criteria
- Create a query by using a wizard or manually
- Perform calculations by using a query
- Update information in a table
- Delete information from a table
- Create a report by using a wizard or manually
- Modify report design and content
- Add a subreport to a report
- Preview and print a report
- Make favorite Access commands quickly available
- Create custom categories
- Assign a password to a database
- Prevent database problems
- Create a switchboard
- Control the features available to database users
- Prevent changes to database code
- Secure a database for distribution
|