FORGOT YOUR DETAILS?

Microsoft Access Intermediate 2007/2010 | Training Course

This training session provides a solid foundation for people looking to use the more advanced Access features.

This Microsoft Access Intermediate training will give you a good introduction to the more advanced features of Microsoft Access 2007/2010. It focuses on the skills to create and manipulate a database to suit any task or project.

Microsoft Access is a powerful relational database management system that is designed to make databases easier to create and manage. Many businesses today, from sole traders to mega-corporations, choose to use Microsoft Access because it’s versatile, easy to maintain and requires little support.  

This 1-day Microsoft Access Intermediate level course is designed to build on your existing knowledge of Microsoft Access, and will provide the knowledge and skills to help you to take advantage of the more advanced features of Access. You will expand your knowledge of relational database design and learn how to sort and filter data, generate more complicated queries and create more advanced forms and reports.

The material covered in this Microsoft Access Intermediate course provides a solid foundation for our Microsoft Access Advanced course.

Requirements

  • You should be familiar with basic PC concepts, and the Windows / Microsoft Office environment. Any previous database experience would be advantageous, but not required.
  • You should be confident using Microsoft Access at a basic level or have gained similar knowledge in the workplace. Attendance of our Microsoft Access Introduction Course would be an advantage.

Why take this course?

Create database systems – Learn how to quickly and easily set up a robust database system.

Take control of your data - Harness the power of Microsoft Access to effectively manage and control your data

Improve your data presentations – Learning how to create and customise forms and reports will allow you to better output information from your data.

Enhance your career prospects – Learning Microsoft Access can open up more opportunities for employment or promotion.

Who should take this course?

  • Anyone with a basic working knowledge of Microsoft Access wishing to gain more advanced skills
  • Anyone who needs to develop the skills to create databases, design data tables, design forms and reports, and create queries.
  • Individuals aspiring to achieve Microsoft Certification status.

Duration

1 day

Request Training

t: 0203 941 4100 | e: info@escalla.co.uk

1-Day Course Content

  • Finding data
  • Sorting and filtering data
  • Importing data from other sources
  • Working with more complex criteria
  • Modifying join types to cross reference data
  • Updating data using update queries
  • Deleting data using delete queries
  • Archiving data using make table queries
  • Copying information between tables using append queries
  • Summarising data using total and cross tab queries
  • Using form sections appropriately
  • Modifying form and form item properties
  • Adding custom windows controls to a form
  • Adding calculated items to a form
  • Displaying related data via sub-forms
  • Using report sections appropriately
  • Modifying report and report item properties
  • Adding custom windows controls to a report
  • Adding calculated items to a report
  • Displaying related data via sub-reports
  • Sorting and grouping data
TOP