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 course is designed for individuals who possess basic Excel skills and want to elevate their proficiency to an intermediate level. It caters to professionals, analysts, administrators, and anyone seeking to enhance their data analysis and spreadsheet management capabilities using Excel.
This PowerPoint Advanced course is intended to help all users get up to speed on many of the different features found in PowerPoint and to become familiar with its more advanced selection of features.
MS Excel is one of the most utilized tools in any organisation. It can be used to create complex analysis, store databases of information, create visual representations of vast amounts of data and many more useful functions.
Microsoft Visio is a dynamic application of Microsoft Office mainly, which is used mainly for drawing flowcharts, diagrams, and vector graphics.
This Intermediate course assumes that you will have a good working knowledge of all of the principles covered in the introductory Excel course.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy