MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 ChGenre: eLearning | Language: English + .VTT | Duration: 2.5 hours | Size: 1.48 GBAdding Functionality to your Databases Using Tables, Forms, Reports and QueriesWhat you’ll learnThis 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.

RequirementsDelegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

DescriptionMODULE 1: Advanced File TasksLearning outcomes: A look at some important administrative features necessary for managing an Access Database file.

Topics covered:Using Windows Explorer within AccessDatabase ManagementSaving Your FilesExporting FilesLinking FilesMODULE 2: Working with TablesLearning 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 TablesTable Properties: FormattingMore Table PropertiesData Validation and Lookup WizardMODULE 3: Working with FormsLearning outcomes: Building professional forms to enhance the user experience and improve effective use.

Topics covered:Basic Form ControlsAdvanced Form ControlsFormatting Your FormFormatting ControlsUsing ThemesMODULE 4: Working with ReportsLearning outcomes: Organize and format your reports professionally and common report tasks you may need to perform.

Topics covered:Organizing Report DataFormatting ReportsCommon Report TasksMODULE 5: Working with QueriesLearning outcomes: Creating a range of different queries from very basic queries through to management queries with advanced functionality.

Topics covered:Basic QueriesDoing More with QueriesCreating Advanced QueriesCreating Management (Action) QueriesWho 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.