- Duration: 1 Hour
Course details
Queries are used in Access 2010 to convert data into useful information and are an essential part of any database application. This course demonstrates how to create and modify a query in order to achieve specific results. It covers creating basic select queries, using Expression Builder, calculated fields, and grouping options for displaying query results. This course also demonstrates how to create crosstab, unmatched, and find duplicates queries.
- recognize the basic characteristics of queries
- create basic select queries
- modify queries
- use calculations to refine query data
- apply grouping and calculating functions to query results
- create crosstab queries
- create unmatched queries
- create find duplicates queries
- create and modify a Select query
- refine a query using groupings and calculations
- create a Crosstab query
- create a Find duplicates query
About New Horizons Lebanon
As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Ms Word, Ms Excel, Ms PowerPoint NextGen LearningUSD 272Duration: Upto 50 Hours
- Microsoft Access 2016 Complete Diploma Alpha AcademyUSD 27
USD 520Duration: Upto 1 Day
