Data Management Challenges in Access - Demystified

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | 978 MB

Genre: eLearning | Language: English

Learn effective Data management techniques and functionalities in MS Access

Data is better protected and maintained when it can be shared using a database instead of creating new iterations of the same data stored in new files for every new application. This course enables database users to explore the powerful features of queries.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

Select query

Running a Select Query

The Query Design Window

Creating a query from the query window

Adding fields to a query, Display/Suppress the display of a field

Specifying Text, numeric, date, and logic criteria

Specifying sub string searches using wild Card Characters

Working with Conditions - BETWEEN, AND, OR, NOT, NULL

Types of queries - Make Table Query, Append Query, Delete Query, Update Query