IT Training

ACCESS - INTRODUCTION

AIM To introduce users to basic database concepts.
WHO SHOULD ATTEND? Users with a requirement to learn the basics about database procedures in order to meets the needs of their job role.
OBJECTIVES By the end of the course, participants will be able to ;
  • Understand the principles of database design.
  • Design & use a data entry form.
  • Extract information using queries.
  • Design and produce reports.  
CONTENT During the course, delegates will cover the following topics: -  
  • Create A Database Table.
  • Input / Modify Data.
  • Sort & Filter Data.
  • Create / Modify / Run, Queries.
  • Design & Set Criteria.
  • Design & Modify Data Entry Forms.
  • Create Reports.
  • Grouping Data In A Report.
DURATION 1 Day

ACCESS - ADVANCED

AIM To introduce users to advanced functionality of database concepts.
WHO SHOULD ATTEND? Users with a requirement to modify & design databases, in order to meets the needs of their job role.
OBJECTIVES By the end of the course, participants will be able to;
  • Create & design complex relational databases.
  • Create & use a sub-forms.
  • Create & modify action queries.
  • Automate procedures by creating macros.  
CONTENT During the course delegates will cover the following topics: -
  • Create A Relational Database.
  • Understand Relationships.
  • Design Forms / Sub-Forms.
  • Create / Modify / Run, Action Queries.
  • Design Complex Reports.
  • Create Action Buttons.
  • Create / Use & Modify Macros.
DURATION 1 Day

 

 

 

< BACK