Microsoft Access 2013 – Advanced

Provided by

  • Sector IT
  • Course Type Online
  • Duration 30 Hours
  • Price £49 + VAT

Enquire about this course

About the course

COURSE CURRICULUM

1. ADVANCED FORM DESIGN

  • Create Subforms
  • Organize Information with Tabs Pages
  • Navigation of Forms
  • Conditional Formatting

2. DATA VALIDATION

  • Field and Record Validation
  • Form Validation

3. USER INTERFACE DESIGN

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro

4. DATA ENTRY USING A MACRO

  • Automate Data Entry Using a Macro
  • Convert a Macro to VBA

5. DATABASE MANAGEMENT

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

6. SECURING A DATABASE

  • Splitting a Database for Multiple User Access
  • Implement Security
  • Set Passwords

7. DISTRIBUTING DATABASE

  • Convert an Access Database to an ACCDE File
  • Analyze the Performance of a Database

8. SWITCHBOARDS

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

Benefits you will gain:

  • High quality e-learning study materials and mock exams.
  • Tutorials/materials from the industry leading experts.
  • 24/7 Access to the Learning Portal.
  • Benefit of applying NUS extra Discount Card.
  • Recognised Accredited Qualification.
  • Excellent customer service and administrative support.

Certification:

Successful candidates will be awarded a certificate in Microsoft Access 2013 – Advanced

Who is this course for?
  • Those with technical roles within the IT industry
  • Project-based technical analysts and engineers
  • Technical support personnel
  • Professionals who design and programme system-level software such as database systems, operating systems, and embedded systems
Career path
  • Software Engineer
  • Technical Support
  • Technical Sales
  • Business Analyst
  • Web Developer
  • Software Tester

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

Could you be making CV mistakes that are sabotaging your job search? It’s quite possible, and easily fixed, by addressing these common CV mistakes.