MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 ChGenre: eLearning | Language: English + .VTT | Duration: 2.5 hours | Size: 1.32 GBLearning to use MS Access to its Fullest ExtentWhat you’ll learnThis training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access in order to increase their knowledge and productivity.
RequirementsSome of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
DescriptionMODULE 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 PasswordWho this course is for:Users with a solid understanding of MS Access 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time.
