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.

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.

See the full list of Microsoft Office Courses

Microsoft Access Product