Access Courses Cape Town
Access Courses Cape Town
July 13, 2024 Comments Off on Access Courses Cape TownAccess Courses Cape Town
Access Course Outlines in Cape Town
- 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.
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
💰 Starting from:
R12900/ $850 / €850
Courseware inclusive
1-on-1 expert
Flexible hours
Commence anytime
MS Office Brochure:
ⓘ Write your international exams in the comfort of your own home!
🏅 Internationals
All international exams are additional in price: per exam (dependent on exchange rate when booked). We assist you booking online and choosing an approved centre closest to you to write or via online proctoring! PS: you can write online or onsite worldwide!
Excel Associate (Excel and Excel 2019)
