×
Search for Schools

Contact Page - Microsoft Access course in London

Image of Pitman Training London Pitman Training London:
As the oldest-established office skills training organisation in the UK, Pitman Training in London's Notting Hill and High Holborn offers a wide-range of courses leading to nationally recognised qualifications.

Email: Contact us below    

( or request a callback ).

Access Training - Proficient Level Course

This very popular Access course will equip you with all the skills you need to build databases in Microsoft Access. In only 20 study hours at our comfortable High Holborn or Notting Hill training centres, you'll grow from novice to intermediate in database design.

Not only will you receive a high quality workbook to keep for future reference, at the end of the course, providPhoto of Contact Page - Microsoft Access course in Londoned you pass our exam, you'll receive a handsome Pitman Training certificate - proof of your skill level!

What Is Covered:

Lesson 1:
Understand the following terms - table, record, field, query, form, report, common field, one-to-one relationship, one-to-many relationship, primary key and foreign key. Understand the planning and design of an Access database containing related tables and recognise relationships between tables. Use the Office Assistant.

Lesson 2:
Define fields, data types and properties for three tables using design view. Enter data into tables using datasheet view. Set primary keys and establish relationships. Navigate records in a table. Use the Lookup Wizard to create a field that looks up data from another table and to establish a relationship. Use Find to locate specific entries. Sort records. Use the Table Wizard to create a table, modify the table design and enter data into the table. Use the Input Mask Wizard.

Lesson 3:
Edit data in form and datasheet views. Add new records. Change page orientation. Enforce referential integrity in a relationship. Work with controls in form design.

Lesson 4:
Import a table from an external database. Use a junction table to resolve a many to many relationship. Add a new field to a form. Use a calculated control on a form. Create a query. Use criteria to retrieve selected data. Create and name a calculated field in a query.

Lesson 5:
Add a field with data validation in a table. Enter data using a Form/Sub form combination. Perform summary calculations on a group of records in a Query. Create and modify the design of a Report. Save a table as a Web page. Add a hyperlink in an existing Web page.

Contact Us Today - Send a Quick Email here:


( or request a callback ).

Remaining characters
See Also: - Request a Callback
- About
- Courses / Programs
- Location
Address: WC1V 7JZ, London, England , UK / GB
Some interested visitors submitting program inquiries to our school up to 2023-02-21 were from:

Marlow; south west London; Reading; London; london; SW London; and more.
Related Schools & Programs. Inquire to our admissions team today:
Pitman Training London
Courses / Programs
Pitman Training London have training centres in central London, located in High Holborn, Notting Hill and Paddington. We provide training in Microsoft Word, Excel, Access, PowerPoint, and Outlook as well as a Microsoft Office diploma course. The use of technology is paramount to the efficiency and effectiveness of a business, and a total command of Microsoft’s universally accepted software is crucial.

Our Microsoft courses will give you increased satisfaction and could increase your earnings potential and enhance your career prospects in today's competitive job market. Learning Microsoft Office skills is easy with Pitman Training. Our tried and trusted methods are the best available. You will work at your own pace in our comfortable premises, helped by experienced tutors as required. You choose your own hours and keep the reference materials when the course is over.

On completion, you will receive a Pitman Training Diploma that is recognised nationally and internationally by employers. We have a full range at every level to suit all-comers, whether you need your skills as serious working tools or simply to keep up with the kids.
Microsoft Office Plus Diploma Training Course includes the following core subjects:

- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Outlook
- Microsoft Access

Training in individual Microsoft Office applications can also be taken as separate courses.
Learning Solution, London
Courses / Programs
Learning Solution offers a range of courses in the fields of IT, Social Media and Mobile Development, including Microsoft, Cisco and CompTIA certifications. We are conveniently located in the borough of Southwark in Central London, just 2 minutes walking distance from London Bridge and Liverpool Street tube stations.

At Learning Solution, we are committed to helping build tomorrow's business leaders. Dedicated to creating global competence in IT, Business and Accounting, we have designed our courses to be world class, stay industry relevant and market responsive, and most importantly, keep our students way ahead of the rest.

Our teaching is modelled to be case-study based and application oriented, where students and faculty evaluate theories and principles in the context of everyday business needs and challenges. Our student-faculty ratio, is one of the healthiest in the industry, and creates the ideal environment for one on one mentoring and academic engagement between the student and faculty. We also encourage joint involvement between students and faculty, in corporate projects and research opportunities.
- Microsoft courses
- Cisco courses
- CompTIA courses
- Sun Microsystem courses
- Oracle courses
- Red Hat courses
- Web Design & Development courses
- Project Management courses
- Accounting courses
- Social Media courses
- Mobile Development courses
& more...
Tresham College of Further and Higher Education
Courses / Programs
Tresham is a College of Further and Higher Education with campuses located one hour from London in the English East Midlands. At Tresham we offer an extensive range of computing courses to suit all abilities, right up to the Higher National Diploma offered in association with the University of Northampton.

Tresham College is an approved academy for CompTIA, CISCO and Microsoft offering a range of specialist programmes for technicians and engineers.
Full-time BTEC Diploma Courses:
- 3D and Multimedia
- Games and Software Development
- IT Technicians
...

Part Time Courses:
- Adobe - Dreamweaver
- Adobe - Flash
- Microsoft PowerPoint (Beginner to Advanced)
- Microsoft Outlook
- Search Engine Optimisation
...
Giant Training & Development, Belfast
Courses / Programs
Giant Training is a computer training school in the heart of Belfast City offering a wide range of courses to cater for the creative markets. We provide professional training in the graphic design, publishing, internet, internet marketing, multimedia, communication, print and photographic industries. Our courses provide a wealth of training and vocational knowledge for businesses and students alike in both tailored and scheduled courses.

We have an Apple Mac and PC Training suites setup to cater for 6 trainees. Courses take place for 1-6 trainees depending upon what you require. If we do not list the course you are looking for please contact us. We have a wide network of Industry experts at hand that can cater for your needs.
Our training courses include:

- Apple
- Adobe (Photoshop, Lightroom, Illustrator, Indesign, Fireworks, Flash, Dreamweaver)
- Quark Xpress (Highest Qualified Quark trainer)
- Microsoft Office
- Social Media (Twitter for business, Facebook)
- Wacom Demonstrators
- Final Cut Pro
- Adobe Premiere
- After Effects
- Digital Photography
and many more...
Erp Training
Courses / Programs
ERP Training is Europe’s premier SAP institute based in Croydon in South London in the London Borough of Croydon, providing customer project-based Training and Placements in SAP. At ERP Training, we believe in imparting modern, high quality in-class training to both aspiring graduates and talented professionals to keep them abreast with the changing needs of the competitive market place.

We have a full team of ERP professionals including SAP, Oracle and Microsoft technologies in the areas of business processes, across various industries and organisational settings. The job opportunities available in the UK are in implementation, customisation, support, scaling, maintenance, and job upgradation, including opportunities in Europe and USA.

With years of international experience in technology and functional domains related to ERPs, we are confident in designing and delivering substantial training to individuals and corporate businesses in these areas. Our aim is to be a one-stop shop for all your training & documentation needs.

East Croydon Railway Station provides services to Central London to the north and to Sussex, Surrey, and Kent to the south.
Customer project based Training and Placements in the following areas of SAP:

* SAP Financials & Management Accounting (FICO)
* SAP Human Capital Management (HR)
* SAP Sales Order Management (SD)
* SAP Procurement (MM)
* SAP Customer Relationship Management (CRM)
* SAP Business Intelligence (BI)
* SAP Business Objects (BO)
* SAP Netweaver Administration (BASIS)
* SAP ABAP
Microsoft Training London
Courses / Programs
Microsoft Training London have provided Microsoft training (Microsoft office training) in London and UK wide since 1992 with Microsoft qualified trainers. MS office software training is provided in a range of formats, including bespoke solutions all with Instructor led training classes.
Public schedule, on-site, closed company, tailored and one-to-one courses include MS Project, Access, Excel, Powerpoint, Word, Outlook, Lotus notes, Dreamweaver, Frontpage, TNA, Visio.