Access Training
Access Intermediate
Course Objectives
Welcome to Seven Institute’s course for Microsoft Office Access, Microsoft’s database program. This new version of Access incorporates new features and templates to make working with databases easier.
This Intermediate level is intended to help those who are familiar with the basics of Access do more with their database. This course will also help more experienced users who have little to no experience with Access and the ribbon interface.
This course will cover how to create and manage database files as well as how to link to additional database resources. It also covers tables, forms, reports, and queries in more depth. By the end of this course, users should be able to create and manage small databases.
Who Should Attend
Access Intermediate is targeted at individuals wanting to increase their base knowledge of Access databases. It assumes you are already familiar with basic database functions and want to be able to overcome some of the more complex features of access. This course is ideal for anyone wanting to build an database.
Course Syllabus
ADVANCED ACCESS FILE TASKS
- Navigate around your computer using Windows Explorer
- Identify a Trusted Location
- Open and use the trust centre
- Perform basic tasks in Windows Explorer
- Change icon views in Windows Explorer
- Use the Navigation Pane within Windows Explorer
- View and edit database properties
- Use the Save As dialog
- Recognise different database file formats
- Recognise AutoRecover actions
- Export database objects to other file formats
- Use saved export steps
- Export information to older Access databases
- Link to an Excel worksheet
- Link to another database
- Recognise other forms of linking in Excel
- Create hyperlinks in a table
WORKING WITH ACCESS TABLES
- Navigate around your computer using Windows Explorer
- Perform basic tasks in Windows Explorer
- Change icon views in Windows Explorer
- Use the Navigation Pane within Windows Explorer
- View and edit database properties
- Use the Save As dialog
- Recognise different database file formats
- Recognise AutoRecover actions
- Export database objects to other file formats
- Use saved export steps
- Export information to older Access databases
- Link to an Excel worksheet
- Link to another database
- Recognise other forms of linking in Excel
- Create hyperlinks in a table
WORKING WITH ACCESS FORMS
- Recognise different types of forms
- Add controls to a form
- Use the Control Wizard to add controls to a form
- Cut, copy, paste, and move controls in a form
- Apply basic control formatting
- Change a control’s properties, data source, and default value
- Create a calculated control
- View and modify form properties
- Format gridlines in form Design view
- Modify fonts in a form
- Add logos to a form
- Change the form layout
- Change the color of a control
- Modify control properties
- Align and size controls
- Apply special effects to stylize controls
- Use themes in a form
- Modify theme color and font schemes
- Save customised themes
WORKING WITH ACCESS REPORTS
- Add and remove fields in a report
- Use the different sections of a report
- Change report section properties
- Group and sort the data in a report
- Use calculated controls in a report
- Modify the formatting gridlines in report Design view
- Modify fonts in a report
- Add logos to a report
- Change the report layout
- Use themes to stylize report content
- Add a photo or image to a report
- Adjust page properties for printing
- Add page numbers to a report
- Use the Label Wizard to produce mailing labels based on report data
- Apply conditional formatting to highlight report data based on criteria
WORKING WITH ACCESS QUERIES
- Recognise basic queries and their functionality
- Create a new query
- Sort and filter query results
- Hide and show query results
- Use the AND/OR operations in a query
- Recognise an IFF function
- Recognise multiple table queries
- Create a calculated field in a query
- Recognise features of the Expression Builder
- Use queries to summarize data in your database
- Create and use parameter, crosstab, make-table, append, delete, and update queries
- Export queries to another database