MS Access 2013/16 – Intermediate

access-2013
  • Category : Microsoft Office 2013/16
  • Course Name : MS Access 2013/16 – Intermediate
  • Instruction Language : English
  • No. of Courses : 1
  • No. of Lessons : 26
  • Price : R725 ( Includes Vat % ) | (USD $49)

MS Access 2013/16: Intermediate

MS Office 2013

In the course MS Access 2013/16: Intermediate, you will learn to create calculated fields in queries that operate with functions. You will create totals queries and parameter queries. You will familiarise yourself with the properties of table joins and will examine how they can affect the result of queries. You will create forms in the Design view and will learn to insert calculated fields into them. You will also design and edit reports and will learn to perform various calculations in them. You will also learn how to insert controls into forms and reports, including subforms and subreports.

Lessons:

  • Copy and import data
  • Query with parameters
  • Join properties
  • Custom joins
  • Function and Expression Builder
  • Other function categories
  • Indexing fields and validating data
  • Totals
  • Aggregate functions
  • Crosstab query
  • Sort and pick data in forms
  • Form in Design View
  • Form creation in Design View
  • Edit a form
  • Form controls
  • Calculated form fields and conditional format
  • Combo Box in forms
  • Option buttons in forms and change form source
  • Form fields organizing
  • Form with subform creation
  • Subforms and aggregate functions in Design View
  • Command button
  • Totals in reports
  • Calculations and sorting in reports
  • Additional report options
  • Reports graphical editing

College Africa Group is the African Continent’s authorised partner for Gopas. GOPAS is one of the major IT training providers. Its technical courses are annually attended by almost 30,000 students, mostly IT specialists.


System Requirements

The courses have been developed using Flash technology. For this reason the minimum system requirements for a user PC are very low:

  • Any of following internet browsers: Internet Explorer 8.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
  • 1 GHz CPU; 512 MB RAM; OS Windows XP or higher
  • Display resolution of 1280 x 1024
  • Sound card, speakers or headphones are recommended

System Requirements For Using LMS

  • Processor: 1 GHz or higher
  • Memory: 512 MB RAM
  • Display resolution 1280 × 1024 or higher
  • Any of following internet browsers: Internet Explorer 8.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
  • Operating system for online or internal LMS use: Windows XP or higher or Mac OS (+ Opera browser)
  • Sound card and speakers/headphones are recommended

MS Office 2013

Download TOC for MS Access 2013/16- Intermediate
Buy