Course Overview This course provides students with the knowledge and skills to construct relational databases, perform database maintenance, create advanced queries and reports, or integrate Access with other programs. Course Introduction 2m Course Introduction Lesson 01 – Designing a Relational Database 37m Topic A: Relational Database Design Database Relationship Relational Database Design Process Statement of…
Course Overview This course provides students with knowledge and skills such as database management, advanced form design, packaging a database, encrypting a database, and preparing a database for multi-user access. Course Introduction 2m Course Introduction Lesson 01 – Implementing Advanced Form Design 42m Topic A: Add Controls to Forms Types of Controls Other Elements The…
Course Overview This course provides students with the knowledge and skills to utilize Microsoft Outlook 2013 to manage all aspects of email communications. Course Introduction 2m Course Introduction Lesson 01 – Getting Started With Outlook 2013 45m Topic A: Navigate the Outlook Interface Email Addresses Components of the Outlook Interface Components of the Ribbon The…
Course Overview This course provides students with the knowledge and skills to utilize the advanced features provided with the Microsoft Outlook 2013 interface, such as advanced message, calendar, and contacts management. Course Introduction 3m Course Introduction Lesson 01 – Configure Advanced Message Options 41m Topic A: Insert Advanced Characters and Objects Hyperlinks WordArt Equations Symbols…
Course Overview This course provides students with the knowledge and skills to create spreadsheets and workbooks that can be used to store, manipulate, and share data. Course Introduction 1m Course Introduction Lesson 01 – Getting Started with Microsoft Excel 2013 32m Topic A: Identify the Elements of the Excel Interface Microsoft Excel 2013 Spreadsheets, Worksheets,…
Course Overview This course provides students with the knowledge and skills to advance their data analysis skills and abilities through the application of advanced Excel 2013 functionality such as advanced formula creation, tables, charts, PivotTables and PivotCharts. Course Introduction 1m Course Introduction Lesson 01 – Creating Advanced Formulas 30m Topic A: Apply Range Names Worksheet…
Course Overview This course provides students with the knowledge and skills to automate common tasks, audit workbooks to avoid errors, share your data with other people, analyze data, and use Excel data in other applications. Course Introduction 1m Course Introduction Lesson 01 – Automating Worksheet Functionality 42m Topic A: Update Workbook Properties Workbook Properties Demo…
Course Overview This course provides students with the knowledge and skills to setup Lync 2013, use Presence, IM and Contacts, make audio and video calls, and schedule, join and conduct Lync meetings. Course Introduction 1m Course Introduction Unit 01 – Setup Lync 2013 19m Topic A: Sign-In and Get Oriented Signing Into Lync The Lync…
Course Overview This course provides students with the knowledge and skills get started with Microsoft Office 2013, and work with Microsoft Word, Excel, PowerPoint, Access, and Outlook 2013. Course Introduction 1m Course Introduction Unit 01 – Getting Started with Microsoft Office 2013 17m Topic A: Common Features A People Card The Metro Style of Word…
Course Overview This course provides students with the knowledge and skills to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text, graphics, and animations. Course Introduction 1m Course Introduction Lesson 01 – Getting Started with PowerPoint 30m Topic A: Navigate the PowerPoint Environment What Is…