MS Access

Microsoft Access is a versatile tool used by individuals or professional as a Data Management Application. MS Access Training program focuses on the crucial steps for collecting, managing and reporting the large amounts of data for an Individual or Organisational Level Purposes.

MS Access corporate training and certification oriented remote program aims to upskill you with Database Management, Creating Tables & Forms, Customising Data Forms, Dealing with Records, Designing Table Structures, Using report wizards

Currently due to Covid19 outbreak, the course is available remote and however it can also be accessed online via your nearby Prog360 centre based on local availability.

Course Content:

• Introduction to Access 
•     What is a database? 
•     Computerising a database 
•     Designing an Access database 
•     Defining a data store 
•     Populating a database 
•     Extracting information from a database 
•     Reporting data 
• Access Features
•     Starting Access 
•     Access opening screen 
•     The Title Bar 
•     The Menu Bar 
•     Toolbars 
•     The Status Bar 
•     Menus and Submenus 
•     SpeedKeys 
•     The Database Window 
•     Scroll Bars 
•     Exiting Access 
• Connecting to Office Assistance
•     Using the Office Assistant 
•     Getting help without the Office Assistant 
•     Manipulating the help Window 
•     Help for screen objects - ScreenTips 
• Creating Tables and Adding Records 
•     Creating a table using the Table Wizard 
•     Datasheet view 
•     Adding a record 
•     Saving changes 
•     Moving around the datasheet 
•     Finding a record 
•     Modifying and deleting records 
• Designing Table Structures 
•     Table design - hints and tips 
•     Creating tables 
•     Switching between views 
•     Saving tables 
• Field properties 
•    Field size property 
•     Format and input mask properties 
•     Caption property 
•     Default value property 
•     Required property 
•     Allow zero length property 
•     Indexed property 
• Working with Data 
•     Sorting data 
•     Filtering data 
•     Using advanced filters 
• Forms 
•     What is a form? 
•     Using AutoForm to design forms 
•     Using Wizards to design forms 
•     Entering data using a form 
• And more.