HIGHLIGHTS
• Advanced Microsoft Access 2013 Course.
• Course holds for Two (2) days [3 Hours daily]
• Dates: Thursday 5th – Friday 6 February, 2015.
• Venue: 32 MBONU Street [opposite OldSpice Restaurant], D-Line, Port Harcourt, Rivers State.
• Certificates will be presented upon course completion.
• Course manual will be provided upon Registration.
• Conducive learning environment.
• Certified & Experienced Tutors.
• Course Fee: N10,000

DETAILS
Students with no prior database experience will acquire expert skills to use, create and manage MS Access 2013. This instructor lead, hands-on course provides lectures, lab exercises and assignments that are designed to provide students with applied skills.
Students will learn best practices to design database systems with the latest version of MS Access. They learn to create custom and sophisticated forms and reports, as well as work with basic MS Access macros.
By the end of this course, successful participants will understand the MS Access 2013 approach to relational database management.
 

COURSE OUTLINE
• Introduction
• Course Overview
• What Access Is
• Access Grows Up
• The Future of Access
• Access Alternatives

Database 101
• What a Database Is
• Database Types
• Database Organization
• Understanding Tables
• Understanding Data Types
• Primary Key Basics
• Understanding Indexes

Database Design 101
• Database Design Options
• Understanding Normalization
• Understanding Relationships
• Relationship Types
• Understanding Integrity

Getting Started with Access 2013
• Access Database Objects
• Installing Access 2013
• Creating a Database
• Access Interface Tour
• Database Backups

Working with Tables
• Creating Our Database
• Datasheet or Design
• Creating Tables
• Data Types
• Editing Table Structures
• Date/Time Formats
• Using Input Masks
• Deleting Rows
• Required Fields
• Adding a Primary Key
• Creating an Index
• Deleting a Table

Access Relationships
• Identifying Relationships
• Design Meets Relationships
• Creating Relationships
• Managing Relationships
• Viewing Object Dependencies

Data Retrieval
• Understanding Queries
• Access and SQL
• Query Types
• Creating Queries
• Make Table Queries
• Understanding Join Queries
• Union Queries
• Top Queries
• Distinct Queries
• Query Filters
• Append Queries
• Delete Queries
• Data Management Options

Data Forms and Reports
• Understanding Forms
• Why Use Forms
• Using Auto-Forms
• Using the Form Wizard
• Forms from Scratch
• Design or Layout
• Working with Controls
• Setting the Tab Order

Using External Data
• Data Here and There
• Exporting Data
• Importing Data
• Data Linking
• Data Linking Example

Access Gets Friendly
• What SharePoint Is
• A Budding Relationship

Enquiries:
08037971139;
08091018746

Registration is now ongoing.
For enquiries please call: 08037971139; 08091018746