- Other Location: Bukit Merah - Central
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.
What will I learn?
Lesson 1: Implementing Advanced Form Design
- Add Controls to Forms
- Create Subforms
- Organize Information with Tab Pages
- Enhance Navigation of Forms
- Apply Conditional Formatting
Lesson 2: Using Data Validation
- Field and Record Validation
- Form Validation
Lesson 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
Lesson 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
Lesson 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
Lesson 6: Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options
Prerequisites
Access 2013 - Level 1
Updated on 08 November, 2015Course Location
About New Horizons Singapore
Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business
See all New Horizons Singapore courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Access 2016 for Beginners Adams AcademySGD 34
SGD 308Duration: Upto 26 Hours - Microsoft Access 2013 – Intermediate Global EdulinkSGD 118Duration: Upto 6 Hours
