This course introduces delegates to the basics of Microsoft Access and they will learn to create and modify new databases and their various concepts.
Overview
This course introduces delegates to the basics of Microsoft Access and they will learn to create and modify new databases and their various concepts.
Audience
This course is designed for delegates who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work.
It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.
Learning Objectives
By actively participating in this course, you will learn about the following:
Understand the concepts of database design and how a relational database works in Access.
Build tables, working with fields and field types with an understanding of indexing and how to assign Primary Keys.
Manipulate and navigate tables and records using filtering and sorting tools.
Use forms to make it easier to view, access and input data.
Prerequisites
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer.
Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Course Contents
Access 2016 database concepts
Opening a database and security issues
Tables
Fields and field types
Table navigation and modification
Field properties
Manipulating tables and records
Primary keys and indexing
Filtering within Access 2016
Sorting within Access 2016
Searching within Access 2016
Access 2016 forms
At Skilltec, we pride ourselves on the outstanding quality of our courses - we are excited to report that so far in 2023 we have received an average score of 4.8 from our course attendees!
Listening to our customers' feedback is critical to our ability in delivering engaging and interactive training courses. From Power BI to Presentation Skills, we aim to deliver on all of your training requirements with our brilliant team of training specialists.
This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more.
Microsoft Visio course is offered by Olas. Olas uses a variety of delivery methodologies and believe a blended learning approach leads to the participants retaining the knowledge learnt through the learning event.
Microsoft Word course is offered by Eident. Eident deliver scheduled and on-demand IT skills training courses
By the end of this training course, you will be a confident, independent Access user. You will be able to describe and create databases, access, view and process data using queries, produce forms for data entry and view data in report format.
In Access VBA you will learn how to extend the functionality of Access using a programming language called Visual Basic for Applications (VBA). With VBA you can create code which will allow you to automate the functionality of your database.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy