Get yourself trained on Microsoft Access Advanced with this Online Training Microsoft Access Advanced.
Online Training Microsoft Access Advanced
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
Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.
Learn on your schedule with Udemy
Investing in yourself through Learning
As a society, we spend hundreds of billions of dollars measuring the return on our financial assets. Yet, at the same time, we still haven’t found convincing ways of measuring the return on our investments in developing people.
And I get it: If my bank account pays me 1% a year, I can measure it to the penny. We’ve been collectively trained to expect neat and precise ROI calculations on everything, so when it’s applied to something as seemingly squishy as how effectively people are learning in the workplace, the natural inclination is to throw up our hands and say it can’t be done. But we need to figure this out. In a world where skills beat capital, the winners and losers of the next 30 years will be determined by their ability to attract and develop great talent.
Fortunately, corporate learning & development (L&D), like most business functions, is evolving quickly. We can embrace some level of ambiguity and have rigor when measuring the ROI of learning. It just might look a little different than an M.B.A. would expect to see in an Excel model.