Course details
In this course, students learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.
Course Outline
1 - Implementing Advanced Form Design
- Add Controls to Forms
- Create Subforms
- Organize Information with Tab Pages
- Enhance Navigation of Forms
- Apply Conditional Formatting
2 - Using Data Validation
- Field and Record Validation
- Form Validation
3 - Using Macros to Improve User Interface Design
- Create a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
- Convert a Macro to VBA
4 - Using Advanced Database Management
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
5 - Distributing and Securing a Database
- Splitting a Database for Multiple User Access
- Implement Security
- Set Passwords
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
6 - Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options
Target Audience: 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.
Updated on 08 November, 2015Course Location
About New Horizons Ireland
With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.
We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.
Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.
See all New Horizons Ireland courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Access - Beginners - Advanced John AcademyEUR 24
EUR 366Duration: 34 Hours - Microsoft Access Complete Diploma Alpha AcademyEUR 24
EUR 270Duration: Upto 1 Day