100 megs data gift for every genuine quote requested

Microsoft Access 2013 is the latest software that introduces web apps to Access. Now, you can easily build an Access web app and share it with others as a SharePoint app in a web browser.

This advanced training course in Access 2013 provides expert knowledge and skills in customising apps, using advanced field tasks, working with Expression Builder, creating queries, handling data, creating forms and reports, and more.

This dynamic training course is now available in Gauteng, Durban and Cape Town.

Contact us today for a group quote.

Excel

Word

PowerPoint

Outlook

Access

Project

Who Should Attend

This course is designed for people who have attended the Access Intermediate course or have a comprehensive working knowledge of Access.

They should be confident in designing tables, forms queries and reports.

Upon completion of the Advanced Access course, students will be able to work with Select and Action queries, they will gain an understanding of the impact of relationships including enforcing referential integrity, cascade and delete updates when creating and designing a relational database.

They will be able to work confidently with properties and expressions in queries, calculations in forms, pivot table and pivot chart creation and macro design.

This course also introduces the concept and use of VBA in database design.

Learning Outcomes - Microsoft Access 2013 Advanced Training Course

This extensive training course empowers participants with advanced understanding and skill development in Access 2013 to help them master it.

After completing this course, participants will have learned to:

  • Customise a form layout to improve usability and efficiency of data entry.
  • Add user interface features to validate data entry.
  • Use macros to improve user interface design.
  • Organise data into appropriate tables to ensure data dependency and minimise redundancy.
  • Lockdown and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the startup options.

Course Content - Microsoft Access 2013 Advanced Training Course

Lesson 1: Implementing Advanced Form Design
Topic A: Add Controls to Forms
Topic B: Create Subforms
Topic C: Organize Information with Tab Pages
Topic D: Enhance Navigation of Forms
Topic E: Apply Conditional Formatting

Lesson 2: Using Data Validation
Topic A: Field and Record Validation
Topic B: Form Validation

Lesson 3: Using Macros to Improve User Interface Design
Topic A: Create a Macro
Topic B: Restrict Records Using a Condition
Topic C: Validate Data Using a Macro
Topic D: Automate Data Entry Using a Macro
Topic E: Convert a Macro to VBA

Lesson 4: Using Advanced Database Management
Topic A: Link Tables to External Data Sources
Topic B: Manage a Database
Topic C: Determine Object Dependency
Topic D: Document a Database
Topic E: Analyze the Performance of a Database

Lesson 5: Distributing and Securing a Database
Topic A: Splitting a Database for Multiple User Access
Topic B: Implement Security
Topic C: Set Passwords
Topic D: Convert an Access Database to an ACCDE File
Topic E: Package a Database with a Digital Signature

Lesson 6: Managing Switchboards
Topic A: Create a Database Switchboard
Topic B: Modify a Database Switchboard
Topic C: Set Startup Options