The Microsoft Access 2013 Advanced course is a hands-on course for advanced learners to gain an understanding of how to construct advanced queries, record handling, complex data retrieval and how to use pivot charts and pivot tables. Individuals will learn how to use macros in Access and automate tasks, connect macros to forms and tables and add controls to receive targeted results and layouts. The course is a core skill of Microsoft
The Microsoft Access 2013 Advanced course will help learners participate in basic and intermediate levels of a database and understand the advanced potential of the application. Learners will be able to view, extract and organise using advanced data management skills.
The Microsoft Access 2013 Advanced course will give you an understanding of how data can be related and reported, and how to import, export and link data. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Access 2013 Advanced.
As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.
1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.
At the end of the Microsoft Access 2013 Advanced course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.
Those who successfully complete the exam will be awarded the certificate in Microsoft Access 2013 Advanced.
The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.
Once you successfully complete Microsoft Access 2013 Advanced you will be qualified to work in the following positions. The Microsoft Access 2013 Advanced qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to https://www.payscale.com is given below.
➤ Module 01 - Implementing Advanced Form Design | |||
Course Introduction | |||
1.0 Topic A: Add Controls to Forms | |||
1.1 Types of Controls | |||
1.2 Other Elements | |||
1.3 The Original frmInventory View | |||
1.4 The frmInventory Target Layout | |||
1.5 Styling Elements | |||
1.6 Demo 1-1: Changing the Tab Order on a Form | |||
2.0 Topic B: Create Subforms | |||
2.1 Subforms | |||
2.2 Demo 1-2: Creating a Subform | |||
3.0 Topic C: Organize Information with Tabs Pages | |||
3.1 Demo 1-3: Creating Tab Pages | |||
4.0 Topic D: Enhance Navigation of Forms | |||
4.1 Demo 1-4: Creating a Navigation Form | |||
5.0 Topic E: Apply Conditional Formatting | |||
5.1 Demo 1-5: Changing the Display of Data Conditionally | |||
5.2 Lesson 01 Review | |||
➤ Module 02 - Using Data Validation | |||
1.0 Topic A: Field and Record Validation | |||
1.1 Field and Record Navigation | |||
1.2 Field Properties for a Number Data Type Field in tblInventory | |||
1.3 Input Masks | |||
1.4 Input Mask Characters | |||
1.5 Lookup Lists | |||
1.6 Demo 2-1: Validating Data with a Field Property | |||
2.0 Topic B: Form Validation | |||
2.1 Selecting the Type of Combo Box for a Form | |||
2.2 Controls – List Box and Option Group | |||
2.3 Demo 2-2: Using a Combo Box Control to Limit Option Values | |||
2.4 Lesson 02 Review | |||
➤ Module 03 - Using Macros to Improve UI Design | |||
1.0 Topic A: Create a Macro | |||
1.1 Macros | |||
1.2 The Macro Builder Window and Action Catalog | |||
1.3 Macro Actions and Positioning Arrows | |||
1.4 Types of Macro Actions | |||
1.5 Event Options Form Field | |||
1.6 Macro Event Groups | |||
1.7 Events and Supported Controls | |||
1.8 Demo 3-1: Creating a Macro to Open a New Record on a Form | |||
2.0 Topic B: Restrict Records Using a Condition | |||
2.1 The OpenForm Macro Action with Where Condition | |||
2.2 Demo 3-2: Using the Where Condition to Restrict Data | |||
3.0 Topic C: Validate Data Using a Macro | |||
3.1 Validate Data Using a Macro | |||
3.2 Demo 3-3: Using a Macro to Validate Data | |||
4.0 Topic D: Automate Data Entry Using a Macro | |||
4.1 Event Properties for Automating Data Entry | |||
4.2 Demo 3-4: Automating Data Entry with a Macro | |||
5.0 Topic E: Convert a Macro to VBA | |||
5.1 Macros and VBA | |||
5.2 Demo 3-5: Converting a Macro to VBA | |||
5.3 Lesson 03 Review | |||
➤ Module 04 - Using Advanced Database Mgmt | |||
1.0 Topic A: Link Tables to External Data Sources | |||
1.1 External Data Sources | |||
1.2 Demo 4-1: Using an External Data Source | |||
2.0 Topic B: Manage a Database | |||
2.1 Modes to Open a Database | |||
2.2 Maintaining a Database | |||
2.3 Demo 4-2: Compacting and Repairing a Database | |||
3.0 Topic C: Determine Object Dependency | |||
3.1 The Object Dependencies Pane | |||
3.2 Demo 4-3: Viewing Object Dependency | |||
4.0 Topic D: Document a Database | |||
4.1 Database Documenter | |||
4.2 Demo 4-4: Using the Database Documenter | |||
5.0 Topic E: Analyze the Performance of a Database | |||
5.1 Analysis Results | |||
5.2 Demo 4-5: Using the Performance Analyzer | |||
5.3 Lesson 04 Review | |||
➤ Module 05 - Distributing and Securing a Database | |||
1.0 Topic A: Splitting a Database for Multiple User Access | |||
1.1 Viewing Tables in a Split Database | |||
1.2 Demo 5-1: Splitting a Database | |||
2.0 Topic B: Implement Security | |||
2.1 The Message Bar | |||
2.2 Implementing Security | |||
2.3 The Trust Center Dialog Box | |||
2.4 Demo 5-2: Adding a Trusted Location | |||
3.0 Topic C: Set Passwords | |||
3.1 Password Guidelines | |||
3.2 Demo 5-3: Setting a Database Password | |||
4.0 Topic D: Convert an Access Database to an ACCDE File | |||
4.1 ACCDE File Format | |||
4.2 Creating an ACCDE File | |||
4.3 Quick Start Database Templates Menu | |||
4.4 Template Customization | |||
4.5 Saving Your Database as a Template | |||
4.6 Demo 5-4: Converting a Database to ACCDE Format | |||
5.0 Topic E: Package a Database with a Digital Signature | |||
5.1 Packaging a Database with Digital Signatures | |||
5.2 Package and Sign | |||
5.3 Certificates | |||
5.4 Lesson 05 Review | |||
➤ Module 06 - Managing Switchboards | |||
1.0 Topic A: Create a Database Switchboard | |||
1.1 The Switchboard Manager’s Initial Message | |||
1.2 The Switchboard Manager’s Main Screen | |||
1.3 Demo 6-1: Creating a Simple Switchboard | |||
2.0 Topic B: Modify a Database Switchboard | |||
2.1 Demo 6-2: Modifying a Switchboard | |||
3.0 Topic C: Set Startup Options | |||
3.1 Startup Options for the Current Database | |||
3.2 Error Checking Options | |||
3.3 Demo 6-3: Setting Startup Options | |||
3.4 Lesson 06 Review | |||
3.5 Course Closure |