Access Courses Stellenbosch

Access Courses Stellenbosch

Access Courses Stellenbosch

Comments Off on Access Courses Stellenbosch

Access Courses Stellenbosch

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 Stellenbosch: 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.

See the full list of Microsoft Office Courses

Microsoft Access Product

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