FORGOT YOUR DETAILS?

Learn Microsoft Access Fundamentals 2007/2010 | Training Course

Gain the confidence, skill and practical experience to learn Microsoft Access 2007/2010 to design a database and create and modify simple tables, queries, forms and reports

Microsoft Access is a relational database management system (DBMS) designed to help users store, track and manage data. Whether you want to learn Microsoft Access to keep simple lists of information or build large-scale databases, this powerful application is up to the task.

This two-day course is a great way to learn Microsoft Access basic features. Covering more than our Introduction course, this course will take you through the process of creating a database, structuring a table, creating queries to interrogate your data, and will also provide you with the skills to create and customise reports to effectively output your information.

If you're looking for a good starting point to learn Microsoft Access, this is it.

Requirements

  • You should be familiar with basic PC concepts, and the Windows / Microsoft Office environment.
  • Previous Microsoft Access experience would be advantageous, but not required.

Why take this course?

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

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

Increase efficiency - Save time on tasks by learning how to use Macros.

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

Who should take this course?

  • Anyone not familiar with Microsoft Access interested in learning the fundamentals in the shortest possible time.
  • New users of Microsoft Access wishing to become productive in the shortest possible time.
  • Self-taught users looking for a refresher.
  • Individuals aspiring to achieve Microsoft Certification status.

Request Training

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

Learn Microsoft Access 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
  • Finding data
  • Sorting and filtering data
  • Deleting data
  • Importing data from other sources
  • Creating select queries
  • Sorting data
  • Adding criteria using a variety of data types
  • Working with more complex criteria
  • Querying related tables
  • Modifying join types to cross reference data
  • Using parameters to improve flexibility
  • Performing calculations
  • 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
  • Creating data entry forms
  • Entering and editing data via a form
  • Formatting form items
  • 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-form
  • Creating simple reports using the report wizard
  • Formatting report items
  • 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