Microsoft Access Advanced

Learning to use MS Access to its Fullest Extent
Instructed by: ZandaX Training | Subject: Office Productivity, Microsoft

Description

MODULE 1: Advanced Data Management Learning 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 Integrity Table Relationships An Introduction to SQL Modal Dialog Boxes MODULE 2: Advanced Form Tasks Learning 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 Subforms Creating a Navigation Form Advanced Form Controls Exporting a Form Other Form Tasks MODULE 3: Automating Reports Learning 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 Form Building Query Criteria MODULE 4: SQL and Microsoft Access Learning outcomes: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries. Topics covered: Understanding SQL Using the SELECT Statement Using Subqueries Using SQL Joins MODULE 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 Basics More about Macros Access and VBA Building Advanced Procedures Using VBA in a Database MODULE 6: Finishing the Application Learning 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 Options Sharing/Splitting the Database Creating an ACCDE Encrypting the Database with a Password Who 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.

@https%3A%2F%2Fwww.udemy.com%2Fmicrosoft-access-advanced%2F%3Futm_medium=linkshare

Course Info

• 46 Lectures
• 2 Hours
• Language: English
• Subject: Office Productivity, Microsoft
• Instructed by: ZandaX Training
• Platform: Udemy