Edit 
Delete - Last Modified By: man at 18/11/2016 10:21:33 AM
Creating Data Input forms with back-end databases in Microsoft Access 2016
You will create a Microsoft Access 2016 Database and Data Entry Form that will give a user a friendly interface to submit records into a back end database. There is a step by step activity, and then a final section where Internal Students will continue on with their Year Long Assessment: A Preventative Maintenance survey form of their own with a back-end database
Edit Delete - Last Modified By: man at 14/11/2016 10:10:42 AM
Creating a Preventative Maintenance Survey using Google Forms - External Students
In this activity, you will create your own basic Preventative Maintenance Survey using Google Forms.
Edit Delete - Last Modified By: man at 14/11/2016 10:03:32 AM
Excel Based Invoice Template
You will create an invoice template in relation to the ICTSAS303 Activity FLET-S01-01-06 (IT Site Survey / Hardware Requirements Specification).
Edit Delete - Last Modified By: man at 14/11/2016 10:04:05 AM
Microsoft Access to Excel PowerPivot Import task
The below Activity will introduce you to:
- The Microsoft Excel PowerPivot Add-In
- Importing data from Microsoft Access Database (Contoso V2 Database) using the PowerPivot Add-In
You will need to open the ContosoSales Access 2016 Database to understand the make up of the database tables you will be working with.
Have a look at their fields in the Design View of each table, then open up the Stores.xlsx (Located within the Contoso V2 Database) to start the task.
Edit Delete - Last Modified By: MAN at 17/01/2016 11:55:25 AM
Microsoft Access to Excel PowerPivot Import task 2
In this second activity (below) there are 2 parts.
In Part 1, you will:
- create your own database with it's own unique data in Microsoft Access
- create relationships between tables in Access
- create very basic SQL Queries.
In Part 2, you will:
- perform a database import within Excel using the SQL Queries you developed in Access
Edit Delete - Last Modified By: MAN at 17/01/2016 12:32:48 PM
Performing a Mail Merge using Excel and Word
The below looks at the ability for Microsoft Word to perform a basic Mail Merge by gathering unique dynamic data from an Excel Spreadsheet.
Edit Delete - Last Modified By: man at 16/11/2017 9:29:13 AM
Creating a Microsoft Stream Presentation in Office 365 PowerPoint
The below link navigates to the Microsoft Stream website.
Microsoft Stream is a feature in Office 365 PowerPoint, and basically gives you everything you need to easily create and share interactive online videos, either through the stream cloud or exporting them as MP4 formats. It is useful in compiling a whole PowerPoint Slideshow and exporting that Slideshow into an interactive video / mp4 as well.
Continue on to create your own instructional video!
Edit Delete - Last Modified By: man at 16/11/2017 9:47:23 AM
Create your own Instructional Office Stream Demonstration
You are Instructed to complete an IT Related Instructional Office Stream Demonstration using the Recording function within Office 365 PowerPoint.
Edit Delete - Last Modified By: man at 9/09/2016 3:17:56 PM
Documentation Essentials
For use within the structure of basic formatting of headers, footers and page layout within a word document
Edit Delete - Last Modified By: man at 9/09/2016 3:18:18 PM
Create Instructional Documentation
In this activity, you will create 5 instructional documentation pieces for use within the IT Service Desk
Edit Delete - Last Modified By: man at 8/10/2017 11:37:39 AM
Microsoft Excel Tutorial 1: Data Entry and Formulas
You will be introduced to 3 Excel Formulas useful for performing calculations on numbers entered within a Spreadsheet.
Edit Delete - Last Modified By: man at 8/10/2017 1:18:37 PM
Microsoft Excel Tutorial 2: Data Entry and Formulas
Continuation of Excel Formulas and Data Entry. You will need to watch the video tutorial and replicate each step to come up with a workable cost forecast spreadsheet table.
Edit Delete - Last Modified By: man at 14/11/2016 10:19:57 AM
Google / Access Forms 2016 - Preventative Maintenance Survey Form Review
You will review your overall performance of your Preventative Maintenance Survey form, as well as include evidence of completion. This is coupled with your final submission of your Preventative Maintenance Survey Spreadsheet with evidence of your logs.
Edit Delete - Last Modified By: man at 8/10/2017 11:20:41 AM
VLOOKUP Function in Office 365 Excel 2016
Learn how to use the VLOOKUP Function in Office 365 Excel 2016, and then create your own lookup table.
Edit Delete - Last Modified By: man at 16/11/2017 10:17:34 AM
Demonstrate a Packet Tracer network build using Office 365 Stream
In this Activity, you will demonstrate a Packet Tracer network build using the Office 365 Stream Feature in Microsoft PowerPoint
Edit Delete - Last Modified By: man at 9/09/2016 3:22:30 PM
Designing a Company Newsletter using Microsoft Word