Microsoft Access 2013 - Microsoft Office Specialist (MOS) exam and BCS ECDL exam

Blended learning in Wembley

£ 410 VAT inc.
  • Typology

    Training

  • Level

    Intermediate

  • Methodology

    Blended

  • Location

    Wembley

  • Class hours

    22h

  • Duration

    3 Months

  • Start

    Different dates available

Description

Microsoft Access is great programme to work with and mastering this popular database application will provide you with skills needed in a variety of employments sectors.

Important information

Government funding available

Facilities

Location

Starts

Wembley (Middlesex)
Hazel House 1-3 Lancelot Road, HA0 2AL

Starts

Different dates availableNow taking bookings

To take into account

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. By the end of the course you will be able to start, build, update and maintain a database competently within this popular programme.

Anyone looking to gain experience and knowledge of this popular Microsoft Office database programme. If you’re 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.

You don’t need any experience with Microsoft Access itself but some prior experience of the Microsoft Office applications would be an advantage to you at the start of this course.

During Enrolment, you will have an interview and/or assessment with Course Advisor to make sure that the course you have chosen is right for you. During this process we will also check your exam certificates and discuss which course is suitable for you.

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

What you'll learn on the course

  • Access
  • Database Design
  • ECDL
  • Office IT
  • Database
  • Database training
  • Design
  • Ms Office
  • Microsoft Access
  • Microsoft Office
  • MOS

Teachers and trainers (1)

Darshana Edirisinghe

Darshana Edirisinghe

Centre Supervisor

Course programme

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.

£ 410 VAT inc.