Data Management Challenges in Access - Demystified
Data Management Challenges in Access - Demystified
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | 978 MB
Genre: eLearning | Language: English
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
Data Management Challenges in Access - Demystified
