- Duration: 1 Hour
Course details
Advanced query methods in Access 2010 make it easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a way that the data is easy to interpret and analyze. This course describes the various types of join and parameter queries that can be used in Access 2010 and provides demonstrations on the use of action queries, including update, append, delete, and make table queries. It also explores the use of SQL-specific queries such as data-definition, pass-through, subquery, and union queries.
- create and edit joins in Access 2010 databases
- creates a parameter query
- modify data in existing tables
- create a new table from data in other tables
- delete data from an Access 2010 database
- identify how to create a union queries
- modify an object within a database using a data-definition query
- access a hosted database with a view to running a pass-through query
- remove duplicate records from a table using a subquery
- specify a join in a query
- use action queries to modify a database
- create and refine queries using SQL
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
- Level 3 Diploma in Microsoft Access John AcademyUSD 34
USD 720Duration: 34 Hours - Ms Word, Ms Excel, Powerpoint, Access Academy for Health & FitnessUSD 218Duration: Upto 130 Hours
