Quality Seal Emagister EMAGISTER CUM LAUDE
Certificate in Microsoft Access 2013 – Beginner to

Microsoft Access 2013 – Beginner to Advanced

Global Edulink
Virtual
Precio Emagister

$ 986.438 $ 312.966
+ IVA
*Precio Orientativo
Importe original en GBP:
£ 249  £ 79

Información importante

Tipología Curso intensivo
Nivel Advanced
Metodología Virtual
Horas lectivas 20h
Duración Flexible
Inicio Fechas a escoger
Campus online
  • Curso intensivo
  • Advanced
  • Virtual
  • 20h
  • Duración:
    Flexible
  • Inicio:
    Fechas a escoger
  • Campus online
Descripción

Learn the skills you need from Access experts

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.

On this course, provided by Global Edulink who offer the world’s best online education all in one place, you are taken step-by-step through the software by qualified trainers who are specialists in their field of work. We make it easy for you to understand how to use the software, from the fundamental aspects such as setting up tables, inputting and manipulating table data, and generating reports, through to advanced skills such as carrying out mail merges, entering data using macros, creating and designing forms, and generating queries and reports.

Información importante
¿Esta formación es para mí?

Those with technical roles within the IT industry
Professionals who design and programme system-level software such as database systems, operating systems, and embedded systems
Project-based technical analysts and engineers
Technical support personnel

¿Qué pasará tras pedir información?

On receiving your request, one of our staff members will call you or send you a message by explaining everything about the course you are requesting information, including how you can sign up, payment options, exam, and enrollment requirements etc.

Precio a usuarios Emagister: Special promotion price.

Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
Fechas a escoger
Online
Inicio Fechas a escoger
Ubicación
Online

¿Qué aprendes en este curso?

Access
Options
Database
Database training
Design
Export
Microsoft Access
Manage a Database
Create a Macro
Field and Record Validation

Programa académico

Description

COURSE CURRICULUM

------------ BEGINNER ------------

1. INTRODUCTION TO ACCESS 2013

  • Orientation to Microsoft Access
  • Simple Access Database
  • Get Help in Microsoft Access

2. TABLE DATA

  • Modify Table Data
  • Sort and Filter Records
  • Create Lookups

3. QUERYING A DATABASE

  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Calculations in a Query

4. ADVANCED QUERIES

  • Parameter Queries
  • Action Queries
  • Unmatched and Duplicate Queries
  • Summarize Data

5. GENERATING REPORTS

  • Create a Report
  • Controls to a Report

6. ENHANCE THE APPEARANCE OF A REPORT

  • Appearance of a Report
  • Report for Print

7. THE ACCESS OPTIONS DIALOG BOX

  • The Access Options Dialog Box

------------ INTERMEDIATE ------------

1. RELATIONAL DATABASE

  • Relational Database Design
  • Create a Table – Access
  • Create Table Relationships

2. JOINING TABLES

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Work with Subdatasheets
  • Create Subqueries

3. ORGANIZING A DATABASE FOR EFFICIENCY

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

4. IMPORT AND EXPORT THE DATA

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel

5. MAIL MERGE

  • Create a Mail Merge

6. ADVANCED REPORTING

  • Organize Report Information
  • Format Reports
  • Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Subreport to an Existing Report

------------ ADVANCED ------------

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.

Información adicional

Career path

Software Engineer
Technical Support
Technical Sales
Business Analyst
Web Developer
Software Tester