Microsoft Excel/Access Students in Microsoft IT Academies benefit from world-class Microsoft curriculum and software tools to tackle real-world challenges in the classroom environment. In the first part, students will learn to use the newest version of Microsoft Excel interface, commands, and features to create, enhance, customize, share and create complex documents, and publish them. In the second part, students will learn to use the newest version of Microsoft Access interface, commands, and features to create, enhance, customize, and deliver presentations. English language arts are reinforced.
1.00 Understand basic, intermediate and advanced spreadsheet software skills using Microsoft Excel. 1.01 Overview 1.02 Working with Microsoft Excel 2013 1.03 Using Office Backstage 1.04 Using Basic Formulas 1.05 Using Functions 1.06 Formatting Cells and Ranges 1.07 Formatting Worksheets 1.08 Managing Worksheets 1.09 Working with Data and Macros 1.10 Using Advanced Formulas 1.11 Securing and Sharing Workbooks 1.12 Creating Charts 1.13 Adding Pictures and Shapes to a Worksheet
MICROSOFT ACCESS 50%
2.00 Understand basic database software skills using Microsoft Access. 2.01 Database Essentials 2.02 Create Database Tables 2.03 Work With Tables And Database Records 2.04 Modify Tables And Fields 2.05 Create Forms 2.06 Create Reports 2.07 Create And Modify Queries 2.08 Use Controls In Reports And Forms 2.09 Advanced Tables 2.10 Advanced Forms 2.11 Advanced Reports 2.12 Advanced Queries 2.13 Display And Share Data 2.14 Import And Export Data 2.15 Database Tools