The Microsoft Access Masterclass training course provides the delegates with the knowledge to help them create and manage databases and their components. The users get to learn about tables, queries, forms, reports their data without having to consider the intricacies involved in doing so. Reports help them to get the data they wish to analyse, and Macros are used to automate certain tasks they wish to perform again and again. Delegates are also taught the uses of Sub-Forms and Sub-Reports i.e. when the user has to enter data in Master-Child form or retrieve data from multiple tables.
Data can be analysed and summarized using Pivot Tables, and also integrated with the web. The course will allow the delegates to learn various aspects related to the Microsoft Access database such as Designing databases, managing databases, performing backup and recovery, designing the graphical interfaces using Forms and reports and automating tasks with Macros and other utilities.
MSP TrainingFeatured Program Courses for PROFESSIONALS!
The Microsoft Access Masterclass training course provides the delegates with the knowledge to help them create and manage databases and their components. The users get to learn about tables, queries, forms, reports their data without having to consider the intricacies involved in doing so. Reports help them to get the data they wish to analyse, and Macros are used to automate certain tasks they wish to perform again and again. Delegates are also taught the uses of Sub-Forms and Sub-Reports i.e. when the user has to enter data in Master-Child form or retrieve data from multiple tables.
Data can be analysed and summarized using Pivot Tables, and also integrated with the web. The course will allow the delegates to learn various aspects related to the Microsoft Access database such as Designing databases, managing databases, performing backup and recovery, designing the graphical interfaces using Forms and reports and automating tasks with Macros and other utilities.
Learn to work with Tables and Queries in MS Access
Understand the various types of Queries
Learn how to build a Graphical Interface for entering data into Access tables
Automate Tasks using Access Macros
Perform Administrative tasks in MS Access to safeguard your data
Perform Administrative tasks in MS Access to safeguard your data
Find out what's included in the training programme.
Clear and concise objectives to guide delegates through the course.
Courseware will also be provided to the delegates so that they can revise the course after the training.
Delegates will get certification of completion at the end of the course.
A dedicated tutor will be at your disposal throughout the training to guide you through any issues.
A basic knowledge of working in the windows environment is required though not mandatory.
Anybody having the basic skills to work with windows applications can attend this course. The following are liable to sit for the course:
Enquire Program
Fill in the form below & we'd get back to you.
The delegates, during the course, are introduced to managing databases using MS Access. They learn about the various features of MS Access such as Tables, Relationships, Queries, Forms, Reports, and Macros. Besides they are also introduced to tools that help them to administer the database for purposes such as backup and recovery. The delegates also learn how to protect their data from unauthorised access by the use of encryption techniques. With this course the delegates gain the knowledge required of them to design relational databases, write complex queries, customise reports, perform validations, and modify existing data effectively whenever and wherever required.
Fundamentals of MS Access
The Microsoft Access User Interface
Microsoft Access Reports
Tables
Handling Queries
Forms
Advanced Query Techniques
Share Data with other Applications
Maintaining the Access Database
Enquire Now
----- OR -------
Reach us at 0121 368 7851 or info@msptraining.com for more information.
Swansea is a coastal city lies on the south coast of Wales with a population of around 241,300 in 2014. The county of Swansea is the second largest and most populous city in the Wales followed by Cardiff. The city is situated between the ancient Welsh and Glamorgan‘s historic county boundaries and surrounded by Bristol Channel and Swansea Bay. The city was also known as Copperopolis due to the presence of copper industry in the 19th century. The town got the city status in 1969 during the Prince Charles’s tour to Wales. The city comprises four physical areas include Gower Peninsula, urban and suburban zone stretching to the towns of Gorseinon, Lliw uplands and coastal strip around Swansea Bay.
History
The name of the city is derived from Sveinn’s island, referring settlement is developed on the raised ground in marshes. The early evidence of the area demonstrated the Bronze Age, Stone Age and Iron Age. It has been suggested that the city has developed as a Viking trading post. The first charter was granted to the city in the 11th century and it gained the status of the borough. A marcher lordship was formed in the city after the Norman Empire and incorporated land around the manor of Kilvey, Swansea Bay and the peninsula. The borough charter was granted between 1158 and 1184 and gained the status of chief lordship town.
During the Industrial Revolution, the city served as the key logical base for copper smelting works. The wool, cloth, wine and coal was traded through the Swansea port. The population of the city expanded significantly in the 18th century. The lower Swansea valley was filled with waste products and derelict works due to decline in heavy industries in the town in the 20th century. The Lower Swansea Valley Scheme was introduced in the city to bring the wasteland into the usable condition. This resulted in the construction of Enterprise Zone over the wasteland and north and south dock became Parc Tawe and Marina respectively. The city was the prime target of German bombers during the Second World War due to the presence of the heavy industries in the town and the centre of the town was significantly affected.
Economy
The economy of the city was based on metals, copper and mining industry in the 18th century. These heavy industries declined and the majority of the copper ores were melted in the lower Swansea valley. The trend of the economy shifted to light industries and service sector. More than 90% of the workforce is engaged in the service sector including banking, finance, education, public administration and insurance. Headquarter of the Driver and Vehicle Licensing Agency is based in the city and provided employment to around 6000 people in the city while other major employers in the city include Virgin Media, Amazon, Admiral Group, BT and HSBC. The city is home to the worldwide customer care centre of the Virgin Atlantic, handling baggage claims, customer relations, reservations and sales.
Education
The city has six infants, one nursery, five junior, fifteen comprehensive and seventy-seven primary schools in the city. The campus of Swansea University is located in the Singleton Park for higher education. The engineering department of the university has done an outstanding work for solving engineering design problems and acknowledged as a centre of excellence. The other departments of the university such as Physics, Computer Science and History were also renowned for their achievements. The third best medical school in the country after Cambridge and Oxford ‘Swansea University Medical School’ is located in the city. The other higher educational institutes are Gower College and University of Wales Trinity Saint David.