Title of the Workshop
The tittle of the workshop is ‘Two Days Workshop on Microsoft Access with Visual Basic for Applications’
Overview
This workshop is designed to give an intermediate and advanced topicin Microsoft Access 2016 software. It can be learn to design tables properly and build relationships; create forms and reports and then modify the design; make simple and complex queries and create calculated fields; import information from other sources such as Excel; and use Visual Basic for Applications (VBA) to create command buttons to open forms and reports, set properties, track modification dates.The Visual Basic for Applications will be added to Access, with just a few lines of code. Learning these techniques will help to build application that has customers, services, invoices, and would be good for anyone in a service business.
In completion a ‘Participation Certificate’ will be awarded IT Centre, Vavuniya Campus of the University of Jaffna.
Target Group
This workshop is designed for school students in age 15 or above, school leavers from GCE Ordinary Level as well as GCE Advanced Level,students from undergraduates as well as postgraduates, business professionals, and workers from government and non-government organisation.
Duration and Schedule
Two days workshop, 8 Hours on Saturday – 9am to 4pm, and 7 hours on Sunday – 10am to 4pm
Fee Per Participant
Rs 4750 for Students and Rs 5000 for workers/ staff
Medium of Instruction
This workshop is conducted in bilingual languages including English and Tamil. Participants can use both English and/or Tamil in the lecture discussions.
Method of Teaching and Learning
The workshop will be delivered in a combination of lectures, computer laboratory practical sessions, and group works.
Objectives of the workshop
The objective of the workshop is:
- To provide theintermediate and advanced knowledge in Microsoft Access 2016 software.
- Use both Access and Visual Basic for Applications to create build application for an organisation.
Learning outcomes
After completing this workshop, the participants should be able to:
- Create a database.
- Enter and retrieve data into database.
- Handle different type od datatypes.
- Construct relationship between tables.
- Create and modify charts.
- Create main form to enter and display data.
Course Outline
- Access Basics
1.1 Welcome to Access
1.2 Enter Data into Tables
1.3 Create a Form and Combo Box
1.4 Modify Form Design
1.5 Customize Form with Colours and Close Button
1.6 Create a Query, Grouped Report and Auto Report
- Importing and Navigating
2.1 Import Objects from Access
2.2 Import Data from Excel
2.3 Create a Query with Calculations
2.3 The Navigation Pane
2.4 Perspective on Access Objects
- Data Types
3.1 Number Data Types
3.2 Text Data Types
3.3 Currency Data Type and Windows Region Settings
3.4 Yes/No Data Type
3.5 Date/Time Data Type
3.6 Data Type Review
- Relationships, Mainform & Subform, Quick Access Toolbar
4.1 Relationships and Relationships Diagram
4.2 Mainform and Subform
4.3 Customize Quick Access Toolbar for Form and Report Design
- Building Reports
5.1 Complex Query for Grouped Report
5.2 Creating Reports in Access
5.3 Design Report from Scratch
5.4 Group and Sort
5.5 Modify Relationship Properties to Show All Records
5.6 Report View, Design View, Layout View and Print Preview
5.7 Calculated Controls and Control Names
5.8 Page Breaks and Page Setup
5.9 Back Colour, Alternate Back Colour and
5.10 Running Sum and Hide Duplicates
5.11 Repeat Sections, Show or Hide Continued Label
5.12 Change Sort to Group, Set Default View to Print Preview
5.13 Hide Sections and Controls, Key Fields
5.14 Page Header, Page Numbers, Date & Time, Report Caption
- Main Menu Form