MS Access 2013/2016 Intermediate Course Information
Duration: One Day: 9am – 4:30pm Price: $400
Software and Version | Course Length | May 2022 | June 2022 | July 2022 | August 2022 | September 2022 | October 2022 | November 2022 |
---|---|---|---|---|---|---|---|---|
Access 2013/2016 Intermediate | 1 Day Course | 20 May | 21 June | 15 July | 16 August | 19 September | 20 October | 18 November |
Course Booking
Target Audience & Purpose
Access Intermediate is for people who can already create simple databases, and want a Forms-driven database with basic automation.
Objectives
By the end of this course participants should be able to:
- Export data from Access to other applications
- Set table field properties
- Design advanced queries and action queries
- Use charts in Access
- Create subforms and subreports
- Use hyperlinks in Access
- Create and use a switchboard
By the end of this course participants should be able to:
- Export data from Access to other applications
- Set table field properties
- Design advanced queries and action queries
- Use charts in Access
- Create subforms and subreports
- Use hyperlinks in Access
- Create and use a switchboard
Course Inclusions
- Comprehensive learning materials incl. exercise files
- Post course telephone support
- ‘Certificate of Attendance’
on completion of course - Morning & afternoon tea
Course Prerequisites
Participants should be competent users of Access and should already be able to:
- Create a database
- Define the fields and properties for a table
- Create simple calculation and select queries
- Link tables using queries
- Create table relationships
- Create forms and modify the appearance of forms
- Perform calculations in forms
- Create and modify reports
MS Access 2013/2016 Intermediate Course Content
Exporting Data
Exporting Data to an Excel Workbook, Saving Export Setup, Dragging and Dropping Data into Excel, Creating Word Mail Merge Documents
Using Advanced Database Features
Importing Data, Linking Data to an Access Table, Using the Linked Table Manager, Exporting Data, Converting Files, Printing a Relationship Document, Compacting a Database, Using Name AutoCorrect, Backing Up a Database
Using Subforms/Subreports
Working with Subforms/Subreports, Creating a Subform/Subreport, Editing the Layout of a Subform, Displaying a Subform in Datasheet View, Displaying a Subform/Subreports Total
Using Controls and Layouts
Switching Views, Using Controls, Using Control Layouts, Using a Stacked Layout, Using a Tabular Layout, Removing a Control from a Layout, Moving Controls, Viewing the Properties of an Object, Changing a Control Property, Manipulating Controls
Using Other Form Techniques
Creating a Split Form, Converting an Existing Form to a Split Form, Editing a Split Form, Adding a Command Button, Saving a Form as a Report
Using Charts
Creating a Chart, Adding a Chart to a Form or Report, Activating Microsoft Graph to Edit, Changing the Chart Type, Changing the Chart Title, Formatting the Chart Title, Adding Data Labels to a Chart
Using PivotTables and PivotCharts
Creating a PivotTable View, Creating a PivotChart View, Using Other Form Techniques
Creating Macros
Working with Macros, Opening the Macro Tools Window, Creating a Macro, Displaying Macro Design Arguments, Assigning an Argument to an Action, Saving a Macro, Using Single Step Mode for Testing, Running a Macro, Editing an Existing Macro
Using Macros
Using Properties, Creating Embedded Macros, Assigning a Macro to a Control, Creating a Command Button, Adding a Condition to a Macro, Creating a Group Macro, Creating an Autoexec Macro
Collecting Data by E-mail
Understanding When to Use Data Collection, Using the Collect Data By E-mail Messages Wizard, Setting Data Collection by E-mail Options, Manually Processing Replies
Customising the Navigation Panel
Creating Custom Categories, Creating Custom Groups, Adding Database Objects to a Group, Showing/Hiding the Unassigned Objects Group, Deleting Objects from a Group
Forrest Training
Roving one-on-one trainer
Microsoft Office Courses
- Windows 10 Training
- Computer Fundamentals Course
- Microsoft Access Training
- Microsoft Excel Training
- Microsoft Office Training Schedule
- Microsoft Office Upgrade Training
- Microsoft OneNote Training
- Microsoft Outlook Training
- Microsoft PowerPoint Training
- Microsoft Project Training
- Microsoft Publisher Training
- Microsoft Visio Training
- Microsoft Word Training
Microsoft Training & Certification
Desktop – Non Microsoft Courses
Professional Development Courses
- Business Etiquette Training
- Change Management Training
- Creative Problem Solving Training
- Customer Service Training
- Effective Business Writing Training
- Effective Communication Skills Training
- Leadership and Influence Training
- Management Fundamentals Training
- Negotiation Skills Training
- Presentation Skills Training – Presenting with Confidence
- Project Management Training
- Time Management Training