Microsoft Access 2013 Beginner to Advanced Training

Microsoft Access 2013 Beginner to Advanced Training

Course Description:

Microsoft Access is the database management system of choice for IT professionals. This course is a comprehensive guide to the programme and offers teaching on the fundamental aspects like setting up tables, manipulating data, reports, mail merges, macros, and much more. This certificate will be a great enhancement to your CV, as it is widely used by businesses.

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

• Generate databases and reports
• Mail merge
• Import / export data
• Advanced form design
• Data validation
• Database management

What is the target audience?

• This course would be suitable for anyone who would like to learn alongside work or childcare
• This course is suitable for those who work in, or would like to work in, technical roles within the IT industry

How will I be assessed?

• At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
• Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.

Course Curriculum Total Units : 64
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

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

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