In this Introduction to Microsoft Access training course delegates will then learn to design and create databases and tables, query those tables, and create forms and reports.
Overview:
In this Introduction to Microsoft Access training course delegates will then learn to design and create databases and tables, query those tables, and create forms and reports. Delegates will also gain an understanding of database concepts and terminology and learn: the Access interface; to work with table views, queries, forms, reports, and macros and modules; database design fundamentals; to work with forms and the Form Wizard; and to work with reports and the Report Wizard.
Course Outline:
The Access Environment
Opening and Closing a Database
Using Save and Save As
Creating a Basic Database & using views
Creating a Table
Table modification and navigation
Modifying Table fields
Setting Field properties
Creating Data Validation
Using Input masks
Manipulating Records & Tables
Table Filtering & Sorting
Advanced Table Filtering
Table Relationships
Printing in Access
World’s most popular database application program
Classroom, Virtual and Online courses available
Expert instructors with 5 Star customer ratings
Onsite and customised training courses available
ReAct and Access funding accepted
This course includes:
Training from an experienced Microsoft trainer
Computer / Laptop to use for the duration of the course (classroom & onsite courses only)
Detailed course notes and sample exercises
Full colour course manual
Free online training videos
Refreshments (classroom courses only)
A recording of the training course (virtual courses only)
NILC Training is Wales’ leading provider of professionally accredited IT, Project Management and Business Skill training courses and computer-based certifications.
NILC currently works throughout Wales and the South West of England to advance the knowledge and skills of individuals, organisations and government departments through our comprehensive range of learning and development solutions.
We’re proud to work with some of the UK’s most renowned examination bodies, so whether you’re a complete beginner and looking for a career change, or an expert in your field looking at gaining an industry recognised qualification, we can help.
This practical course is designed to enable you to create spreadsheets which allow secure data sharing and integration with other applications. You will learn how to implement advanced functions and features such as macros and will be familiar with the basics of Visual Basic for Applications (VBA).
Many organisations have large databases in Access that have built up over the years; staff have learned enough to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports.
Understanding this software is essential for successfully navigating your tasks and accomplishing your career goals. Pitman Training provides a variety of courses for office workers to polish their skills and jumpstart their careers with improved computer skills.
Microsoft PowerPoint is an easy program to use and a powerful tool for giving a presentation. Whether your presentation needs a visual kick, tools for collaboration, easy access or the ability to share information beyond the initial meeting, PowerPoint is a good option.
This course is for new or inexperienced users of Visio who want to gain a basic understanding of how to use its main tools and features. Visio is a powerful diagramming program, which enables you to easily create many drawings from flowcharts and organization charts to network and web diagrams.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy