You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.
This course is suitable for anybody wanting to learn 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.
Instructor led, group-paced, classroom-delivery learning model with structured... more details
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Target Students
Students taking this course are database administrators or... more details
Students taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills.
This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2013.
Prerequisites
To ensure your success, knowledge of basic and... more details
To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. The following courses or equivalent knowledge is also recommended:
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Course Objectives
Upon successful completion of this course, students will... more details
Upon successful completion of this course, students will be able to:
Implementing Advanced Form Design Using Data Validation Using Macros to Improve User Interface Design Using Advanced Database Management Distributing and Securing a Database Managing Switchboards
Course Content
Lesson 1: Implementing Advanced Form Design
Topic A: Add... more details
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
Locations
Infero Training Ltd is based in the Lace... more details
Infero Training Ltd is based in the Lace Market in Nottingham. Training courses take place at the following locations including Nottingham, London, Loughborough, Mansfield, Chesterfield, Burton-on-Trent, Lincoln, Leicester, Sheffield, Stoke-on-Trent, Tamworth, Wolverhampton, Walsall, Birmingham, Solihul, Coventry, Nuneaton, Peterborough, Grantham.
What you get
Professional Microsoft Certified Trainer
Comfortable Premises, equipped with all the technology you need
