January 21st, 2025
- MS Access
- Digital Upskilling
- Google Drive / Sheets
- MYOB
- PhotoShop
- Zoom
MS Access
Basics Course
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Describe the Access screen layout.
- Plan a database.
- State meanings of database terms – primary key, fields, relational.
- Add fields to create a database.
- Create simple forms.
- Enter data to create records.
- Import data from other programs.
- Find, sort and navigate data.
- Create and format simple reports.
- Create simple queries to extract data.
- Create reports based on queries.
- Link tables together.
- Create queries to combine tables.
Intermediate Course
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Revise the basics and shortcuts in using an Access database.
- Create more tables and link them.
- Use queries to combine tables.
- Create calculation queries.
- Change the design of forms and reports.
- Create forms and subforms.
- Add calculations to forms and reports.
- Format and validate data.
- Add Windows features to forms (drop downs, check boxes).
- Create a main menu system.
- Implement simple security features.
Advanced Course
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Create mail merges with MS Word
- Assign detailed controls to forms
- Create automatic field population controls
- Use report dialogue forms
- Apply maintenance and security measures
- Integrate databases with Web pages
- Create and format macros
- Use Visual Basic modules
- Deploy databases to users without Access
Digital Upskilling
Full Course
This is a five (5) part live online course. Content as follows:
Session 1: Digital Technologies in the Workplace
- Work better with a Windows PC using lots of great shortcuts, proper keyboarding, mouse shortcuts, etc.
- Check the settings of a Windows PC – audio, screen, camera, Cortana settings, etc.
- Create an electronic filing system for storing files, documents and folders.
- Introduction to cloud computing and terminology, online learning, meeting and video conferencing tools (Zoom, etc).
Session 2: Working with MS Word Documents
- Create and edit word processing documents.
- Format word processing documents.
- Output documents correctly: print and save to PDF.
- Structure documents correctly: formal letter, CV, etc.
- Handy shortcuts to save stacks of time.
Session 3: Working with MS Excel Spreadsheets
- Create and edit spreadsheet documents.
- Format spreadsheet documents.
- Work with simple formulas and charts.
- Output documents correctly: print and save to PDF.
- Handy shortcuts to save stacks of time.
Session 4: Job Market, Facebook & LinkedIn, and Workplace Softskills
- State aspects of the online job market and how to research jobs online.
- State the differences and advantages of a Facebook profile and a Linked In profile.
- State the important aspects of a great Linked In profile.
- State and exhibit important job ‘soft skills’.
- Understand the importance of interpersonal skills, phone and email etiquette, working in a team, meeting etiquette, etc.
Session 5: Bookkeeping & Email Skills, and Course Review
- Work with a typical online accounting and bookkeeping app (Xero) .
- Create and manage email communications, attachments, and more.
- Review the DUIT Course, receive certificates, and where to next.
Google Drive / Sheets
Google Drive and Docs
This course can be delivered as a 1-day hands-on, face-to-face session or as 2 x 3-hour live online sessions, and participants will learn how to:
Google Drive:
- Work with and manage your folders better.
- Create folders, rename folders, set up a filing system.
- Share folders with others — just view or editing access.
- Set up and use desktop Windows File Explorer to manage files and folders instead of browser.
- Your specific questions answered.
Google Docs:
- Create, edit and format documents ‘from scratch’.
- Upload and convert MS Word documents and view limitations.
- Use time-saving shortcuts to navigate documents and select text.
- Work with tables to create complex layouts.
- Import and manipulate photos, images, etc, and mix text and graphics.
- Add headers and footers, page numbers, etc.
- Use best-practice suggestions to better present your documents — formatting guidelines, etc.
- Your specific questions answered.
Sharing Google Docs:
- Share documents and work with others on documents.
- Add comments to documents and view all comments efficiently.
- Check previous versions of files and track changes and revisions.
- Convert/download files to different formats (MS Word, Excel, PDF, etc).
- Your specific questions answered.
Google Sheets Essentials and Beyond
This course can be delivered as a 1-day hands-on, face-to-face session or as 2 x 3-hour live online sessions, and participants will learn how to:
- Access Google Spreadsheet.
- Create, edit and format a ‘cloud-based’ spreadsheet.
- Work with important formulas — SUM, AVERAGE, etc.
- Create and edit charts.
- Use shortcuts to navigate and manipulate information.
- Change displays and freeze parts of spreadsheets
- Work with more detailed formulas — IF, LOOKUP, etc.
- Use data analysis tools, such as sorting and filtering.
- Use PivotTables to report the data you want.
- Control the entry and formatting of data through data validation and conditional formatting.
- Download spreadsheets in the format you want.
- Share spreadsheets, view changes, add comments.
- See different/previous versions and drafts of your spreadsheet documents.
- Specific questions from attendees answered.
MYOB
Daily Processing Course
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Set up/check the ‘chart of accounts’, how it works, and how it relates to your business.
- Create and manage items and how they relate to you.
- Enter everyday transactions:
- sales invoices, bills, cash transactions.
- payments for invoices and bills.
- bank transactions—lease payments, etc.
- many more.
- Pay bills electronically via a ‘batch’ process to save time.
- Customise and design better invoices.
- Manage and track the correct GST on transactions.
- Reconcile bank accounts, manually and electronically.
- Reverse and fix errors.
- Use powerful ‘Recurring Transactions’ to save time.
- Work with live bank feeds and bank rules to save time.
- Print reports (P & L, balance sheet, BAS and others)
- Check security and other important options.
- Back up and maintain the file.
Payroll Course
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Describe payroll categories and what they mean.
- Set up general payroll information.
- Set up wages, salaries, superannuation, taxes, deductions, expenses and entitlements.
- Set up ‘unusual’ payroll categories (allowances, tax-exempt and super-exempt categories).
- Set up employee information.
- Set up employees’ pay templates to save time.
- Update any payroll opening balances for employees.
- Describe Tax Tables and load them.
- Create and process pay-runs and timesheets.
- Pay employees electronically to save time.
- Fix employee accrued entitlements with adjustments.
- Design payslips to comply with ATO regulations.
- Produce payroll reports and report PAYG and super.
- Pay PAYG withholding tax and superannuation.
- Describe and implement Single-Touch-Payroll.
Advanced Data Entry and Reporting Course
This is a 1-day hands-on, face-to-face session and participants will learn how to:
- Check your MYOB setup, accounts, GST, etc.
- Use shortcuts and minimise errors for data entry.
- Enter tricky transactions, for example:
- Combined GST and GST-free transactions.
- Combined business and private transactions.
- Credit card purchases and payments.
- Bank loans and entering repayments.
- Jobs to track work and different departments.
- Use live bank feeds and create powerful, ‘split’ bank rules for easier reconciling.
- Use ‘Advanced Find’ features to search for data.
- Reconcile receivables, payables, and others.
- View out-of-balance reports and fix errors.
- Make adjustments to your data correctly.
- Customise, view and interpret important reports.
- Use MYOB’s Data Auditor to find errors quickly.
- Set up and complete the BAS correctly.
- Lock accounting periods and prevent mistakes.
- Set up users and restrict access to some functions.
PhotoShop
Essentials & Beyond Course
This is a 3-hour live, online session and participants will learn how to:
- Enhance greyscale images and colour images.
- Convert image types (colour to greyscale, etc).
- Convert file types (TIF to JPG, PCX to GIF, etc).
- Apply localised enhancement effects (dodge, burn, remove red eye etc).
- Use clean-up techniques (cloning, erase-to-last-saved).
- Add and work with text elements.
- Work with different selection techniques.
- Apply special effects to whole or parts of Images.
- Montage and combine images.
- Work with layers and masks.
- Prepare images for commercial printing and exporting to the Internet.
Zoom
Essentials & Beyond Course
Want to run seamless Zoom meetings? Avoid high-pressure glitches – before they happen? Learn all this and more in this 2-part live, online session:
In the two sessions, participants will learn how to:
PART 1:
- Schedule a Zoom meeting – timing, multiple sessions, options, settings, rooms, collaboration, add-ons, etc.
- Before your Zoom meeting?
- Invite attendees and use password protection and other security.
- Control your video and audio content.
- Adjust your lighting, looking your best and your Zoom Background.
- Practise speaking to the camera and not the screen.
- Prepare your slides and optimise Zoom!
- During your Zoom meeting?
- Admit your participants to the Zoom room!
- Mute, unmute and manage your participants.
- Use the group Chat function.
- Share your screen to show PowerPoint presentations, files, etc!
- Record your Zoom session.
- After your Zoom meeting?
- See who attended your Zoom meeting.
- Access your Zoom recording and follow up with participants.
- Post-meeting Zoom checklist.
PART 2:
- Followup your homework – any issues with test meeting, queries, Q&As, etc.
- Zoom advanced features – breakout rooms, Zoom Polls, Zoom security, Zoom annotation, recurring Zoom meetings, registration automation, Virtual consults, and Zoom shortcuts!
- Zoom Review meeting – How did your homework go, your first Zoom meeting?