Microsoft Access Intermediate
Microsoft Access Intermediate
This course has been developed for Access users want to report on and manipulate data and improve their working knowledge of the product.
- Import, link and export tables
- Work with advanced table properties
- Use advanced select queries and create crosstab queries and charts, as well as use action queries
- Design forms and use subforms
- Create simple macros
- Design reports
Participants will need to be familiar with all of the topics covered in the Microsoft Access Introduction course.
Course Features
- Students
- Max Students10
- Duration1 day
- Skill levelintermediate
- Language
- Re-take courseN/A
-
Revision
-
Importing and linking tables
-
Advanced table properties
-
Table relationships
-
Advanced select queries
-
Advanced query expressions
-
Form design
- Form design view
- Breaking form layouts
- Selecting form controls
- Form properties
- Form control properties
- Create an unbound control
- Add a calculation
- Add a drop-down control
- Change combo box properties
- Add a button
- Change tab order
- Align controls
- Resize controls
- Evenly spacing controls
- Add a logo to a form
- Link a query to a form
-
Action queries
-
Crosstab queries
-
Subforms
-
Advanced report design