Overview

With every ZandaX Microsoft course, you get a workbook and exercises (downloadable from the "Introduction" module at the start of each course). There are two types of exercises: first of all, exercises to match the lessons (called Lesson 1.1, Lesson 1.2, etc) where you can "follow along" with the instructor, and also Skill Sharpeners, where you are given exercises that will reinforce your learning. These all correspond exactly to the manual. So remember to download them, and the manual, from the "Introduction" module at the start of the course. People tell us that the Skill Sharpeners are a real bonus!MODULE 1: Advanced Data ManagementLearning outcomes: A look into table relationships and referential integrity along with introducing SQL, the language database professionals use to manage a database. Topics covered: Referential IntegrityTable RelationshipsAn Introduction to SQLModal Dialog BoxesMODULE 2: Advanced Form TasksLearning outcomes: Creating navigation forms and sub-forms along with some of the advanced form controls necessary to create a fully rounded user interface. Topics covered: Using SubformsCreating a Navigation FormAdvanced Form ControlsExporting a FormOther Form TasksMODULE 3: Automating ReportsLearning outcomes: Create Reports in Access that can return data quickly by using a form to control and launch reports. Look at modifying form properties including combo boxes and link a query to a form. Topics covered: Creating the Report FormBuilding Query CriteriaMODULE 4: SQL and Microsoft AccessLearning outcomes: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries. Topics covered: Understanding SQLUsing the SELECT StatementUsing SubqueriesUsing SQL JoinsMODULE 5: Macros and Visual Basic for Applications (VBA)Learning outcomes: Using Macros and Visual Basic to create some advanced functionality to your Access Database. Topics covered: Macro BasicsMore about MacrosAccess and VBABuilding Advanced ProceduresUsing VBA in a DatabaseMODULE 6: Finishing the ApplicationLearning outcomes: Look at finishing touches to control how users interact with a database using start-up and sharing options. Identify security measures by creating an ACCDE and encrypting a database with a password. Topics covered: Setting Start Up OptionsSharing/Splitting the DatabaseCreating an ACCDEEncrypting the Database with a Password

Skills

Reviews