- الموقع: Bukit Merah - Central
- مدة الدورة التدريبية: 2 Days
تفاصيل الدورة
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
تحديث بتاريخ 08 November, 2015نبذة عن معهد 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
عرض الجميع دورات New Horizons Singapore- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- MS Office 2016 Access for Beginners One Education31 SGD
628 SGDمدة الدورة التدريبية: Upto 5 Hours - Microsoft Access - Beginners - Advanced John Academy34 SGD
519 SGDمدة الدورة التدريبية: 34 Hours
