Title: Microsoft Access 2021/365 for Beginners

Title

Microsoft Access 2021/365 for Beginners

Package

Digitale SAP-Bibliothek

Platform

Your learning platform for SAP software

URL

https://et.training/dashboard/product/video/1276 

Status

Deleted

Publication Type

Other

Medium

Empty

Language

First Author

Simon Sez IT

First Editor

Empty

Publisher Name

Empty

Date First in Print

Empty

Date First Online

2023-01-01

Access Start Date

Empty

Access End Date

Empty

Volume Number

Empty

Edition Statement

Empty

Access Type

Empty

Note

Microsoft Access 2021/365 for BeginnersSubheading: Harness the power of Microsoft Access 2021 and journey from database novice to superstar with this beginners’ course from Simon Sez IT.Access 2021 is so much more than a way to create customizable desktop databases. It is a user-friendly tool that allows us to create business applications and templates from scratch without the need for high-level development skills. It allows even the novice database builder to start creating tables, forms, queries, and reports quickly.Access 2021 is the latest on-premises release from Microsoft and the newest addition to the Access family of applications. It is a full life-cycle database management tool that makes creating small to large databases easy.In this course, we will explore the basic functionality of Access and get familiar with the terminology, the interface, and the commands. We’ll look at the available templates and build tables and populate them with data. We’ll create relationships between tables and construct queries to interrogate the data. We’ll look at building nicely formatted forms so others can interact easily with our database and design custom reports to help us gain deeper insight.This course is for the absolute beginner or anyone who is looking to refresh their basic skills. It will provide a fantastic starting point from which to build more advanced Access database knowledge.In this course, students will learn about:The characteristics of a relational databaseDownloading and installing Access 2021The differences between Access 2019 and Access 2021Locating, opening, and saving Access database templatesOpening, closing, and saving a blank database fileNavigating the Access interface, ribbons, and commandsCustomizing the quick access toolbar with frequently used commandsUnderstanding the different menu systems in AccessUsing keyboard shortcuts to navigate and execute commandsAccessing the help filesCustomizing Access optionsCreating tables and fieldsModifying field propertiesUnderstanding index fields and primary keysCreating lookup menusAdding data validation and data validation text to fieldsImporting data into a table from Excel and from a text fileUsing datasheet view to manage dataSorting and filtering records in a tableCreating relationships between tables that share a common fieldCreating relationships between tables using a link tableUnderstanding one-to-many relationshipsDesigning user-friendly forms and setting up sub-formsBuilding simple and complex queries to interrogate table dataAggregating numeric dataBuilding expressions to perform simple calculationsCreating and running a basic reportDesigning a custom reportUsing form controls to add checkboxes, attachments, and option buttons to formsModifying a form’s design and themeCreating a navigation formExporting an Access database to other file formatsProtecting a database file by adding encryption and password protectionPreventing database issues using compact and repair functionsPrinting tables, forms, and reports.

Last Changed External

Empty