Microsoft Access Intermediate .MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | 1.48 GB Duration: 2.5 hours | Genre: eLearning Video | Language: English
Adding Functionality to your Databases Using Tables, Forms, Reports and Queries Adding Functionality to your Databases Using Tables, Forms, Reports and Queries What you'll learn This training course has been designed to give delegates a solid understanding of more advanced tools and concepts for Access in order to increase their knowledge and productivity. Requirements Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course. Description MODULE 1: Advanced File Tasks Learning outcomes: A look at some important administrative features necessary for managing an Access Database file. Topics covered: Using Windows Explorer within Access Database Management Saving Your Files Exporting Files Linking Files MODULE 2: Working with Tables Learning outcomes: Further developing an understanding of tables, looking deeper into a table's properties fine tuning data types and use data validation. Topics covered: Customizing Tables Table Properties: Formatting More Table Properties Data Validation and Lookup Wizard MODULE 3: Working with Forms Learning outcomes: Building professional forms to enhance the user experience and improve effective use. Topics covered: Basic Form Controls Advanced Form Controls Formatting Your Form Formatting Controls Using Themes MODULE 4: Working with Reports Learning outcomes: Organize and format your reports professionally and common report tasks you may need to perform. Topics covered: Organizing Report Data Formatting Reports Common Report Tasks MODULE 5: Working with Queries Learning outcomes: Creating a range of different queries from very basic queries through to management queries with advanced functionality. Topics covered: Basic Queries Doing More with Queries Creating Advanced Queries Creating Management (Action) Queries Who this course is for: Users with a basic understanding of MS Access 2007, 2010, 2013 or 2016 who want to consolidate and expand on their knowledge of the basic features in a short space of time.
Download link : (If you need these, buy and download immediately before they are delete)