• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
12/18/2018 12/18/2018
  • VLT
Live Online

91006: Microsoft Office Access 2013: Part 3 About this Course 

You've secured a significant number of the fundamental elements of Microsoft® Office Access® and now you're prepared to learn propelled Access components, for example, database administration, propelled shape configuration, bundling a database, scrambling a database, setting up a database for multi-client get to and that's only the tip of the iceberg. Learning of these components isolate database experts from the easygoing database clients or intermittent creators. The present preparing added to what you've picked up from the past two days round out your Access instruction and give you attractive employment abilities. 

You can likewise utilize the course to plan for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013. 

91006: Microsoft Office Access 2013: Part 3 Audience Profile

Understudies taking this course are database overseers or forthcoming database directors who have encounter working with Access 2013 and need to learn propelled abilities. 

91006: Microsoft Office Access 2013: Part 3 course is likewise for understudies who look for the Microsoft Office Specialist (MOS) accreditation and who need to get ready for Exam 77-885, Microsoft Office 2013.

91006: Microsoft Office Access 2013: Part 3 Description

Lesson 1: Implementing Advanced Form Design 

  • Subject A: Add Controls to Forms 
  • Subject B: Create Subforms 
  • Subject C: Organize Information with Tab Pages 
  • Subject D: Enhance Navigation of Forms 
  • Subject E: Apply Conditional Formatting 

Lesson 2: Using Data Validation 

  • Subject A: Field and Record Validation 
  • Subject B: Form Validation 

Lesson 3: Using Macros to Improve User Interface Design 

  • Subject A: Create a Macro 
  • Subject B: Restrict Records Using a Condition 
  • Subject C: Validate Data Using a Macro 
  • Subject D: Automate Data Entry Using a Macro 
  • Subject E: Convert a Macro to VBA 

Lesson 4: Using Advanced Database Management 

  • Subject A: Link Tables to External Data Sources 
  • Point B: Manage a Database 
  • Point C: Determine Object Dependency 
  • Point D: Document a Database 
  • Point E: Analyze the Performance of a Database 

Lesson 5: Distributing and Securing a Database 

  • Point A: Splitting a Database for Multiple User Access 
  • Point B: Implement Security 
  • Point C: Set Passwords 
  • Point D: Convert an Access Database to an ACCDE File 
  • Point E: Package a Database with a Digital Signature 

Lesson 6: Managing Switchboards 

  • Point A: Create a Database Switchboard 
  • Point B: Modify a Database Switchboard 
  • Point C: Set Startup Options

Awards