Database Design, Tools & Techniques with Microsoft Access

Date Format Fees  
20 Feb - 23 Feb, 2024 Classroom ₦300,000 Register
03 Sep - 06 Sep, 2024 Classroom ₦300,000 Register
20 Feb - 23 Feb, 2024 Classroom ₦300,000 Register

Event Details

Participants of the Database Design, Tools & Techniques with Microsoft Access will gain fundamental understanding of the application’s environment and basic database design principles. They will be able to complete tasks independently, correctly apply the principle features of Access 2016, create and maintain basic Access database objects, including tables, relationships, data entry forms, multi-level reports, and multi-table queries.

CONTENT

Create and manage a database

  • Create and modify databases
  • Manage relationships and keys
  • Navigate through a database
  • Protect and maintain databases
  • Print and export data

Build tables

  • Create tables
  • Manage tables
  • Manage records in tables
  • Create and modify fields

Create queries

  • Create a query
  • Modify a query
  • Create calculated fields and grouping within queries

Create forms

  • Create a form
  • Configure form controls
  • Format a form

Create reports

  • Create a report
  • Configure report controls
  • Format a report

 

FOR WHOM: CIOs, IT Development Managers, Heads of Department, System Administrators/Engineers, IT Professionals and others who want to sharpen their knowledge in IT world.

 

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.

 

  • Venue

    Alpha Partners Professional Training Conference Centre. 200, Muritala Mohammed Way (3rd Floor), Yaba Lagos.

Share this course