Access Courses South Africa

Access Courses South Africa

Access Courses South Africa

Comments Off on Access Courses South Africa

Access Courses South Africa

MS Access Training – South Africa

South Africa is a country on the southernmost tip of the African continent, marked by several distinct ecosystems. Inland safari destination Kruger National Park is populated by big game. The Western Cape offers beaches, historicol winelands around Stellenbosch to Paarl, jagged cliffs at the Cape of Good Hope, lush forest and lakes along the Garden Route, and beneath flat-topped Table Mountain is the city of Cape Town.

Access Course Outlines in South Africa
  • SQL in Microsoft Access. 14 hours.
  • VBA For Access & Excel. 21 hours.
  • Access – podstawy. 14 hours.
  • Access VBA. 21 hours.
  • Access – Data Base Designing. 21 hours.
  • Access Advanced. 21 hours.
  • Access Intermediate. 14 hours.

Frequently asked questions about the Microsoft Access Course in South Africa.

Microsoft Access 2010/2013/2016/2018 Course

  • All in all how to share and organize data and information in tables.
  • Create multiple databases, tables and so much more.
  • Learn some coding (queries) syntax such as sql (structured query language)
  • Overal control data entries.
  • Not to mention how to save, import and export data and databases

Access: Level 1

  • Identify the elements of the access interface and the different structure of a database.
  • Overall focus of the relational database design process.
  • Not to mention work with fields and and datatypes.
  • Create a basic database.
  • All in all create tables and work with design view.
  • In turn modify table structures and create table relationships.
  • Overall create sql queries and using joins.
  • Modify table data using sort and filter.
  • In addition retrieve data using select queries.
  • Overall query a database.
  • In turn work on sub data sheets and forms.
  • Overall work on forms and modify forms.
  • Not to mention organize reports using procedures.
  • All in all import and export data.

Access: Level 2

  • Improving the table structure by creating a junction table.
  • Overall create sub queries and duplicate queries.
  • In turn summarize data using a crosstab query.
  • Not to mention create a pivot table and chart.
  • In addition create macros and modify them.
  • Overall validate data using macros.
  • Not to mention create create reports and publish reports.
  • All in all link tables and create relationships.
  • Document databases in access.
  • Thus maintain a database and monitor it.

Access Courses South Africa: Level 3

  • Import an export XML data into an access database.
  • Overall collect data and export it.
  • Not to mention split databases and implement security through passwords.
  • In addition package a database and use the ACCDE File format.
  • Create and modify a database switchboard.
  • Including working offline.
  • Overall exporting and importing data to sharepoint list.

About the author:

Business Info

info@schoolofit.co.za
+2782 696 7749

Business Contact Times

Mon to Thur: 9am to 5pm SAST
Fri: 9am to 4pm SAST

Somerset West:

Appointment only:

155 Main Road,
Somerset West Central,
7130

Company Details

The School of IT International Pty Ltd
Enterprise no: 2019/278233/07
Tax no: 9227879237

Connect

    Subscribe to our newsletter today to get discounts off your next course!
 

Follow us

The School of IT International Copyrights. © 2015 - 2024

Back to Top