Menu
Use Code
Training95
For CPD & QLS
Use Code
Training90
For Opera PMS
Use Code
Training80
For BTEC, NCFE CACHE
Menu

  • No products in the basket.

Microsoft Access 2013 Advanced Course Online

0( 0 REVIEWS )
86 STUDENTS
ACCREDITED BY
Buy Now

Overview:

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.

Why consider 1Training?

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.

Learning Outcomes

  • Understand how to create and normalise a database
  • Gain an understanding of Primary Keys and Relationships
  • Learn how to work with Dates in a Query
  • Learn how to create relationships between database Tables
  • Learn how to optimise a database and improve network performance

Course Titles

  • Module 01: Implementing Advanced Form Design
  • Module 02: Using Data Validation
  • Module 03: Using Macros to Improve UI Design
  • Module 04: Using Advanced Database Mgmt
  • Module 05: Distributing and Securing a Database
  • Module 06: Managing Switchboards

Access Duration

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.

Who is this Course aimed at?

  • The course is aimed at individuals who want to gain an advanced understanding of Access.
  • Students looking to improve their skills in Microsoft Office Access 2013.
  • The course is ideal for individuals like an office manager and professionals working in an office environment.
  • Anyone interested in developing their skills in Microsoft Office Access 2013.

Entry Requirements

  • You must be over the age of 16 and have a basic understanding of Maths, English and ICT
  • Job seekers / graduates / school leavers

Method of Assessment

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.

Certification

Those who successfully complete the exam will be awarded the certificate in Microsoft Access 2013 Advanced.

Awarding Body

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.

Progression and Career Path

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.

  • Programmer – £44,873 per annum
  • Office Manager – £24,073 per annum
  • Web Developer – £24,833 per annum
  • Project Assistant – £20,785 per annum
  • Business Executive – £23,667 per annum
  • Business Analyst – £35,543 per annum
  • Technical Support Analyst – £22,753 per annum

Other Benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Excellent Tutor Support Service (Monday to Friday)
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Quizzes, tests mock exams, practice exams to ensure you are 100% ready
  • Eligible for a NUS discount card
  • Free Career Support Service
  • 25% Discount on personal Statement and covering letter writing service
  • Free Access to Over 150 courses for 2 days (48 hours)
  • Free access to course before you purchase (For selected courses only)
Course Curriculum Total Units : 78
➤ 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
WhatsApp chat