Microsoft Access is a database management system that allows you to store and manage large amounts data, create custom reports, perform data analysis and more.
Microsoft Access is a database management system that allows you to store and manage large amounts of data, create custom reports, perform data analysis, and more. We offer courses for beginner to advanced Access users, covering everything from the basics to VBA programming.
Microsoft Access Level 1
Students enrolled in this course will learn to identify the components of a database, open a table and find information stored in it, create and customize table designs, enter data and validate using input validation formulas, create relationships between tables to ensure data accuracy, and deploy referential integrity.
Other topics include creating forms for entering data into tables, creating, editing, running queries, creating, enhancing, and previewing reports, and importing and exporting data to and from various sources.
Course Details
Prerequisites:
Good understanding of Windows and Microsoft software
The University of Alberta in Edmonton is one of the top teaching and research universities in Canada, with an international reputation for excellence across the humanities, sciences, creative arts, business, engineering and health sciences.
Mission:
Within a vibrant and supportive learning environment, the University of Alberta discovers, disseminates and applies new knowledge through teaching and learning, research and creative activity, community involvement and partnerships.
The U of A gives a national and international voice to innovation in our province, taking a lead role in placing Canada at the global forefront.
Vision:
To inspire the human spirit through outstanding achievements in learning, discovery and citizenship in a creative community, building one of the world's great universities for the public good.
This Introduction to Microsoft Word 2016 training class is designed for students new to working with Microsoft Word in Windows. Students will learn to create, edit, format, and print Microsoft Word documents.
Learn a variety of Excel features through this half-day workshop. The user will be introduced to pivot tables and pivot charts, lookup functions, auto outlines, subtotals, scenarios, financial functions, filters, and advanced tips and tricks.
This intermediate-level course is designed to help users who are familiar with Word’s basic features to take their skills to the next level.
The course covers from basic to advance functions and features of Access. Students will learn how to design and create databases; work with tables, fields and records; sort and filter data; and create queries, data entry forms, multilevel reports, and multi-table queries.
Introduction to Microsoft Excel training empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy