CALL FREE ON 0800 220454

Access 2013

The Microsoft Access 2013 training course  is available at the Edinburgh, Glasgow, Aberdeen and Inverness Pitman Training Centres or via Online Distance Learning through our Pitman Campus.

It will guide you through a wide range of aspects of Microsoft Access. You will gain hands-on, practical experience throughout, meaning you can put the theory into practice.

Course Duration: 22 Hours

CPD Points: 22

iStock_000001425675XSmall

Lesson One: The terminology used in an Access database, starting the Access 2013 program, opening an existing sample database, opening a table, query, form and report, entering a new record, finding records, sorting records, printing a report, closing a database.

Lesson Two: Planning and design, relationships, design view, defining fields, data types and properties, creating a new blank database, creating tables, entering data using datasheet view, re-sizing columns, using the lookup wizard.

Lesson Three: Defining relationships, creating a table using the datasheet view, formatting the datasheet, modifying the table design, creating a database using a template, renaming an object.

Lesson Four: Editing data in form and datasheet views, adding new records, using print preview, changing page orientation, printing a datasheet, enforcing referential integrity in a relationship, creating a relationship report, creating a form using the form tool, working with controls in form design, using themes, modifying properties in a form.

Lesson Five: Using advanced sort, using filter by form, importing a table from an external database, using a junction table to resolve a many to many relationship, defining a composite (primary) key, adding a new field to a form, using a calculated control on a form, creating a multi-value field, creating an attachment field, creating a form using the form wizard, adding a calculated field to a table.

Lesson Six: Using query wizard, setting sort criteria, using ‘or’ and ‘and’ in queries, using expressions to set criteria, creating different types of queries, creating and naming a calculated field in a query, using aggregate functions.

Lesson Seven: Adding a field with data validation in a table, creating a form with subform, entering data using a form/subform combination, creating a split form, creating a basic report, using the report wizard, creating and modifying the design of a report, using the concatenate expression, inserting a logo to a report, adding a subreport to an existing report.

Lesson Eight: Exporting an html document, understanding object dependencies, importing an excel spreadsheet into a table, exporting a spreadsheet, importing a text file into a table, using the analyse table function, using the analyse performance function, using the database documenter.

Lesson Nine: Adding a chart to a form, modifying a chart in a form, changing the tab order in a form, displaying the current date and time in a form, applying conditional formatting to a field, creating a navigation form, customising the ribbon.

This course is designed for anyone looking to gain experience and knowledge of this popular Microsoft Office database program. If you are looking to update your skills from an earlier version of Microsoft Access, this course will show you all the new features and help you find your way around the 2013 version of the software.

This course will help you learn how to effectively use the 2013 Microsoft Access programme and be able to confidently work with the package in a business setting.

The aim of this course is to enable you to start, build, update and maintain a database competently within this popular program.

There are no prerequisites for this course.

Flexible Workforce Development Fund (FWDF)

Claim up to £15,000 for Training your employees

This fund provides Levy Paying Companies an opportunity to up-skill or re-skill Employees and in turn, support economic growth.

Eligibility Criteria:

  • You must be a Levy Paying Employer
  • The Company must be based or operate in Scotland, wholly or partially
  • Employees must reside in Scotland

For more information on applying for this funding, contact our Course Advisors by clicking below:

———– 

A funded training opportunity is now available to those facing redundancy or those who have been made redundant from March 2020 onward.

The National Transition Training Fund aims to tackle the rise in unemployment caused by Covid-19 by offering short sharp training opportunities for people to learn in-demand skills.

If you are currently under threat of redundancy, or have been made redundant at any time from the 1st March 2020 and are aged 25 or over, you can access an industry recognised qualification to help you gain employment.

For further information on how to proceed then contact us referencing the course(s) you are interested in.

.

For more information on this or any of our courses complete the form

Register for a course

Choose Centre (required)
Name (required) Telephone (required) Email (required) Which course are you interested in? (required) Enquiry Allow Future Contact?