FORGOT YOUR DETAILS?

Microsoft Access Introduction 2007/2010 | Training Course

This course provides a solid foundation for designing and creating databases.

This Microsoft Access Introduction training course will provide you with a good working knowledge of Microsoft Access basics, and the confidence to start using Access to effectively control your data.

Almost all jobs today involve some form of data management. A versatile database application such as Microsoft Access can help you to collect and manage large amounts of data easily.

This practical 1-day Microsoft Access Introduction course will provide you with the skills and knowledge to allow you to create a database from scratch, enter and edit data in a table, and work with forms, queries and reports efficiently.

You'll find out how to structure a table, use primary and foreign keys, interrogate data using queries and use different parameters to make your database more user-friendly. You'll also learn how to create and customise forms and reports to make your databases more transparent and easier to navigate.

Requirements

Before enrolling on this Microsoft Access Introduction training:

  • You should be familiar with basic PC concepts, and the Windows / Microsoft Office environment. Any previous database experience would be advantageous, but not required.
  • A working installation of Microsoft Access. Purchase it or obtain a trial version from the Microsoft website.

Why take this course?

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

Build database systems – Learn how to design and create a database from scratch.

Improve your data presentations – The topics covered in this course will allow you to output your data more accurately.

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

Who should take this course?

  • Anyone looking for a Microsoft Access Introduction and wants to set up their own databases or manage an existing database.
  • New users of MS Access who wish to become productive in the shortest possible time.
  • Self-taught users looking to master the fundamentals of Microsoft Access.
  • 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

  • Understanding database terminology
  • Working with the Access interface
  • Navigating multiple windows
  • Creating a new database
  • Using the help tools
  • Structuring a table
  • Using appropriate data types
  • Modifying field properties
  • Relational database
  • Using primary and foreign keys
  • Relationships and referential integrity
  • Understanding and using different join types
  • Viewing related records
  • Using indexes
  • Adding new data to a table
  • Editing existing data
  • Deleting data
  • Creating select queries
  • Sorting data
  • Adding criteria using a variety of data types
  • Querying related tables
  • Using parameters to improve flexibility
  • Performing calculations.
  • Creating data entry forms
  • Entering and editing data via a form
  • Formatting form items
  • Creating simple reports using the report wizard
  • Formatting report items
TOP