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.
Which still Leeds derives it name from the old Brythonic word Ladenses that stands for "people of the fast-flowing river". The river being mentioned here is the River Aire which still flows through Leeds. Originally Leeds referred to a forested area in the 5th to the 7th centuries. The citizens of this city are known as Loiners. They are sometimes also reffered to as Leodensians which is derieved from the city’s Latin name. In Welsh, it is said to be derieved from the word Ilod which means “a place”. Leeds has a population of 2.3 million.
As of today, Leeds economy is the most varied of all the UK's main employment centres. Jobs in Leeds have grown at a faster pace than elsewhere specially in the private-sector. Leeds stands third on the podium when it comes to jobs area. It had 480,000 in employment and self-employment at the start of 2015. Leeds is also ranked as a gamma world city by the Globalization and World Cities Research Network. It is also known as a hub of culture, finance, and commerce in the West Yorkshire Urban Area. There are four universities in Leeds – The University of Leeds, Leeds Beckett University, Leeds Trinity University and the University of Law. In the United Kingdom, the total number of students in Leeds stands at the fourth place.
Cinema in Leeds
First of all it was in the October of 1888 that Louis Le Prince using his single lens camera shot moving picture sequences known as the Roundhay Garden Scene and a Leeds Bridge street scene. These were developed on Eastman’s paper film. The film festival held at Leeds nowdays and called Leeds International Film Festivals International has a Short Film Competition that is named after Louis Le Prince. The second person to do so was Wordsworth Donisthorpe who like Prince had a strong connection to the Leeds Philosophical and Literary Society. Donisthorpe applied for a patent for his camera that could capture moving images twelve years earlier to Prince's.
Leeds has been known to host the rich film exhibitions now and then. Besides hosting the Leeds International Film Festival and Leeds Young Film Festival, it plays host to many independent cinemas and pop-up venues for screening films. The two movie houses - Cottage Road Cinema and Hyde Park Picture House – have since the early 20th century been showing and are ranked among the oldest cinemas to do so in the whole of UK.
Culture
Leeds has been home to many artists such as Kenneth Armitage, John Atkinson Grimshaw, Jacob Kramer, Barbara Hepworth, Henry Moore and Edward Wadsworth, who belonged to diverse fields. The history of art exhibitions in Leeds goes far beyond the 1888 when the first art gallery opened in Leeds. A series of exhibitions termed as 'Polytechnic Exhibitions' were regularly held from 1839. Established in 1903 and lasting upto 1923 the Leeds Arts Club founded by Alfred Orage had members which included Jacob Kramer, Herbert Read, Frank Rutter and Michael Sadler. This club advocated the philosophy of Friedrich Nietzsche, and German Expressionist ideas about art and culture. Noted sculptors Barbara Hepworth and Henry Moore started their carrersr in the 1920’s at the Leeds College of Art.
The club acted as a centre for essential art education in the middle of the 20th century guided by artists such as Harry Thubron and Tom Hudson, and the art historian Norbert Lynton. In the 1970s the Leeds College of Art split from the college to form the center of the new multidisciplinary Leeds Polytechnic which later came to be known as Leeds Beckett University. The University of Leeds served as the alma mater of Herbert Read, one of the leading international theorists of modern art. It was also the place where Marxist art historian Arnold Hauser taught from 1951 to 1985. Leeds acted as a centre for radical feminist art, with the Pavilion Gallery, which opened in 1983, showing the work of women. The University of Leeds School of Fine Art was another center dedicated to the development of feminist art history in the late 1980’s and 90’s.