Advanced Data Management in Access 2007 New Horizons Lebanon
Price: TBA
  • Duration: 4 Hours

Course details

You can use Microsoft Access 2007 to manage your data efficiently using advanced techniques. There are many advanced methods that can be used for modifying and enhancing tables, reports, queries, and forms in order to meet your business needs. This course explains and demonstrates retrieving and validating data, using subforms and subreports, as well as applying conditional formatting in Access 2007 tables, forms, and reports. Advanced query methods 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 2007 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.

  • add a lookup field to an Access 2007 table
  • add a subdatasheet to a table
  • add attachments to Access 2007 records
  • implement data validation in Access 2007
  • add a lookup field to a table
  • add a subdatasheet to a table
  • w
  • add a subdatasheet to a table
  • w
  • use Expression Builder to construct a rule
  • add Subforms to an Access 2007 database
  • add Subreports to an Access 2007 database
  • apply conditional formatting to a form in Access 2007
  • add a subform to an existing form
  • apply conditional formatting to a form
  • add a subreport to a database
  • create and edit joins in Access 2007 databases
  • create and use simple parameter queries
  • create and run update and append queries in Access 2007
  • create and run a make table query
  • delete data from an Access 2007 database
  • create union queries in Access 2007
  • recognize how to create or modify Access 2007 tables and indexes using data-definition queries
  • perform SQL processing on a server
  • edit the SQL of a SELECT query and use subqueries
  • specify a join in a query
  • create and run a parameter query
  • create and run an update query
  • edit the SQL of a SELECT query
  • use SQL to create Access 2007 queries
Updated on 09 November, 2015

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.

See all New Horizons Lebanon courses

Database Management Related Questions

Courses you can instantly connect with... Do an online course on Database Management starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or