Mastering Analysis Techniques of DatabasesMP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | Lec: 15 | 1.03 GBGenre: eLearning | Language: EnglishMs AccessMicrosoft Access queries and reports let you slice and dice your data and present it in detail or summary form regardless of how the data is.

It also offers a great deal of power and flexibility to analyze and present results.

This course empowers you with the techniques used in analyzing Access data sets.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:The Query Design WindowCreating a query from the query windowAdding fields to a query, Display/Suppress the display of a fieldSpecifying sub string searches using wild Card CharactersWorking with Conditions - BETWEEN, AND, OR, NOT, NULLCreating Reports using Wizard and Design WindowWorking with Report Layout View and use Design view to create simple reportsIncluding Subtotals, Headers and Footers