Design Databases

by Tilde skills

Published 30 January 2011
Tilde skills Design Databases - Microsoft Access 2010 contributes directly to achieving the unit of competency BSBITA401A Design databases (Business Services Training Package BSB07). This book would be of interest to those seeking to design and develop a relational database.

Tilde Skills: Design and Develop Complex Text Documents plus Challenges and Assessment tasks plus Challenges with Managing Business Document Design & Development - Microsoft Word 2010 contributes directly to achieving the unit of competency BSBITU401A Design and develop complex text documents and BSBADM506B Manage business document design & development in the Business Services Training Package (BSB07). This book follows on from Tilde's 'Tilde skills Design and Produce Text Documents' and would be of interest to students seeking to build on their advanced word processing skills.

Tilde skills Design and Produce Text Documents - Microsoft Word 2010 contributes directly to achieving the unit of competency BSBITU303A Design and produce text documents in the Business Services Training Package (BSB07). This would be of interest to students seeking to build on their basic word processing skills.

Tilde Skills: Produce Complex Desktop Published Documents - Microsoft Publisher 2010 contributes directly to achieving the unit of competency BSBITU404A Produce complex desktop published documents in the Business Services Training Package (BSB07). This book would be of interest to those undertaking an advanced course in desktop publishing skills focusing on Microsoft Publisher.

Create and Use Spreadsheets

by Tilde skills

Published 30 September 2014
Tilde skills Create and Use Spreadsheets - Microsoft Excel 2013 contributes directly to achieving the unit of competency BSBITU202A Create and use spreadsheets in the Business Services Training Package (BSB07).

This book would be of interest to those undertaking a first course in spreadsheet tasks.

Key features of this book include:
  • exploring the new Microsoft Excel 2013 environment;
  • creating, producing and finalising simple spreadsheets with charts;
  • providing a calculations-first approach which integrates formatting and organising data at appropriate times;
  • supplying 81 hands-on exercises, 16 consolidation tasks, 1 workplace scenario, 3 skills challenges and 3 assessment tasks to bring skills together; plus
  • supplying additional appendix material on shortcut keys, saving to PDF & Help.

Produce Spreadsheets

by Tilde skills

Published 30 August 2014
Tilde skills Producing Spreadsheets - Microsoft Excel 2013 contributes directly to achieving the unit of competency BSBITU304A Produce spreadsheets in the Business Services Training Package (BSB07).

This book would also be of interest to any student requiring a spreadsheet course which encompasses formulas, functions, formatting and charts.

Key features of this book include:
  • planning, designing and creating spreadsheets with charts;
  • providing a calculations-first approach which integrates formatting and organising data at appropriate times;
  • supplying 96 hands-on exercises, 15 consolidation tasks, 4 workplace scenarios, 3 Skills Challenges and 4 Assessment tasks to bring skills together; plus
  • supplying additional appendix material on keyboard shortcuts, saving to PDF and Help.

Tilde skills Develop and Use Complex Spreadsheets - Microsoft Excel 2013, contributes to achieving the unit of competency BSBITU402A Develop and use complex spreadsheets in the Business Services Training Package (BSB07).

This text would also be of interest to any student undertaking a spreadsheet course in Excel 2013 which takes their skills to a complex level.

Key features of this course:
  • creating complex worksheets which include a variety of functions (including nested functions), linked worksheets, charts, imported and exported data, filtered data using tables and PivitTables, subtotals, grouping and outlines, conditional formatting, consolidated data, macros and templates
  • 68 hands-on exercises, 11 consolidation tasks, 3 workplace scenarios, 10 Skills challenges and 5 Assessment tasks that bring skills together and can act as assessment tools
  • additional appendix material including keyboard shortcuts and Help.

Tilde skills Create Electronic Presentations - Microsoft PowerPoint 2013 contributes directly to achieving the unit of competency BSBITU302B Create electronic presentations in the Business Services Training Package (BSB07).

This book would be of interest to anyone wanting to acquire electronic presentation skills.

Key features of this book include:
  • exploring the Microsoft PowerPoint 2013 environment;
  • preparing, creating, running and finalising an electronic presentation which is engaging and balanced;
  • presenting advanced features including slide masters, charts, organisational charts, slide transitions, object animations, importing text, custom shows and packaging a presentation onto a CD;
  • providing 57 hands-on exercises, 6 consolidation tasks, 3 Skill challenges and 7 Assessment tasks; plus
  • supplying additional appendix material on shortcut keys, customising the Quick Access Toolbar and Help.

Tilde skills Produce Simple Word Processed Documents -Microsoft Word 2013 contributes directly to achieving the unit of competency BSBITU201A Produce simple word processed documents (Business Services Training Package BSB07).

This book would be of interest to those undertaking a first course in word processing.

Key features of this book include:
  • exploring the new Microsoft Word 2013 environment;
  • preparing, designing and producing simple word processed documents;
  • presenting detailed steps and knowledge on a range of fundamental word processing skills;
  • providing 107 hands-on exercises, 9 consolidation tasks, and 8 workplace scenarios; plus
  • supplying additional appendix material on keyboard shortcuts and using Help.

Tilde skills Produce Desktop Published Documents - Microsoft Publisher 2013 contributes directly to achieving the unit of competency BSBITU309A Produce desktop published documents in the Business Services Training Package (BSB07).

This book would be of interest to those undertaking a first course in desktop publishing skills.

Key features of this book include:
  • exploring the Microsoft Publisher 2013 environment;
  • creating and finalising desktop published documents;
  • presenting detailed steps and knowledge on a range of desktop publishing skills, e.g. page layout and design, page setup, working with text and text boxes, importing text, linking text boxes, working with pictures and drawing objects, tables master pages, styles and templates;
  • providing 68 hands-on exercises, 14 consolidation tasks, 3 Skills challenges and 4 Assessment tasks; plus
  • supplying additional appendix material on shortcut keys, Help, exporting to Word and saving to a PDF for distribution.

Complex Legal Documents

by Tilde skills

Published 30 August 2014
Tilde skills Complex Legal Documents – Microsoft Word 2013 can contribute to achieving the unit of competency BSBLEG401A Prepare and produce complex legal documents in the Business Services Training Package (BSB07).

This book would be of interest to those using Microsoft Word at an advanced level in a legal environment.

Key features of this book include:
  • providing the skills to prepare, design, and produce complex legal documents in Word 2013;
  • presenting detailed steps and knowledge on a range of complex word processing skills, e.g. automating documents, complex mail merge, working with long documents, using formulae, and customising and automating tasks (macros & templates);
  • providing 62 hands-on exercises and 15 workplace scenarios which all include a legal emphasis; and
  • supplying additional appendix material on shortcut keys, formatting a backsheet, formatting legal documents, and formatting legal correspondence.

Create and Use Databases

by Tilde skills

Published 30 August 2014
Tilde skills Create and Use Databases - Microsoft Access 2013 contributes directly to achieving the unit of competency BSBITU301A Create and use databases in the Business Services Training Package (BSB07).

This book would also be of interest to those seeking to understand, create and use a relational database.

Key features of this book include:
  • creating database tables, including defining and modifying field properties;
  • joining database tables, including an introduction to referential integrity;
  • creating queries, including sorting, adding criteria, calculations, totals and grouping;
  • creating and modifying forms based on tables and queries;
  • creating and modifying reports based on tables and queries;
  • supplying 35 hands-on exercises, 4 consolidation tasks, 6 challenge tasks and 5 assessment tasks; plus
  • supplying additional appendix material on the Quick Access toolbar, saving reports as PDF file and using Help.