Access Courses 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 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 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 Cape Town: 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