Database Design and Data Management with Access 4th - 5th December

Database Design and Data Management with Access

Course Duration: 2 Days

Required: Basic Knowledge of Windows and Data Management fundamentals

From using predefined Access  database applications to building them from scratch, This Access standard Training covers each step of understanding, creating, and modifying databases for custom business purposes. The instructor shows even the most database-challenged how to utilize this powerful software for creating reports and charts, as well as for business record keeping and analysis.

Course Schedule:

1. Getting Started with Access 

·         Database concepts and terminology  

·         Starting Access  

·         The Getting Started window  

·         The Quick Access toolbar

·         Opening an existing Access database   

·         The work environment

·         Customizing the Access environment 

2. Creating Databases and Tables

·         Planning and designing databases

·         Working with fields  

·         Choosing keys   

·         Creating tables  

·         Creating fields 

·         Working with records 

·         Working with data  

·         Checking spelling 

3. Working with Fields and Records

·         Modifying table design

·         Finding and editing records  

·         Organizing and sorting records 

 

4. Creating Data Entry Rules

·         Setting field properties

·         Using input masks

·         Setting validation rules 

5. Relational Database Techniques

·         Creating key fields

Venue: Westlands, Nairobi.
     Date: 4th - 5th DEC 2017
Duration: 2 Days
     Fees: 300$ per delegate Inclusive of Meals, Certificates, 6 Month Post training support. (Group discounts available)
    
RSVP: outreach@opencastlabs-africa.com