Data Management Challenges in Access - Demystified

Course details

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