Microsoft Access 2013 – Advanced Este curso é ministrado em inglês

Course details

Microsoft Access 2013 is the number one database application in the world and is designed to make databases easier to create and use. It’s essentially used to store a set of information, query that information, build easy-to-use graphical interfaces, and create reports on the stored data. It’s where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services.

As a leading UK training provider, Global Edulink understands the training requirements of professionals who are not just starting out in their learning of a specific skill, but so too those who are looking to build on existing skills and knowledge with a view to using these to progress up the career ladder. This is why we’ve created this Microsoft Access 2013 advanced course to meet your specific requirements.

Our online training guides you expertly through skills such as advanced form design, data validation and user interface design, to understanding how to secure a database, database distribution and switchboard creation and modification.
On completion of this course, you’ll understand the advanced features of Microsoft Access 2013 and be capable of not only creating databases but manipulating them to suit tasks or projects you’re working on in the way you best see fit.
 
COURSE CURRICULUM

1. ADVANCED FORM DESIGN

• Create Subforms
• Organize Information with Tabs Pages
• Navigation of Forms
• Conditional Formatting

2. DATA VALIDATION

• Field and Record Validation
• Form Validation

3. USER INTERFACE DESIGN

• Create a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro

4. DATA ENTRY USING A MACRO

• Automate Data Entry Using a Macro
• Convert a Macro to VBA

5. DATABASE MANAGEMENT

• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database

6. SECURING A DATABASE

• Splitting a Database for Multiple User Access
• Implement Security
• Set Passwords

7. DISTRIBUTING DATABASE

• Convert an Access Database to an ACCDE File
• Analyze the Performance of a Database

8. SWITCHBOARDS

• Create a Database Switchboard
• Modify a Database Switchboard
• Set Startup Options

Benefits you will gain:

• High quality e-learning study materials and mock exams.
• Tutorials/materials from the industry leading experts.
• 24/7 Access to the Learning Portal.
• Benefit of applying NUS extra Discount Card.
• Recognised Accredited Qualification.
• Excellent customer service and administrative support.

Certification:

Successful candidates will be awarded a certificate in Microsoft Access 2013 – Advanced
 
  Ultima actualização em  10 December, 2024