-
Title
-
Microsoft Access 2021/365 for Beginners
-
Package
-
+MS-Office und Programmierung (Zusatzmodul)
-
Platform
-
Your learning platform for SAP software
-
URL
-
https://et.training/dashboard/product/video/1276
-
Status
-
Current
-
Publication Type
-
Other
-
Medium
-
Empty
-
Language
-
-
First Author
-
Sez IT, Simon
-
First Editor
-
Empty
-
Publisher Name
-
Empty
-
Date First in Print
-
Empty
-
Date First Online
-
Empty
-
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
- Date Created
-
2023-08-23 11:37:38
- Last Updated
-
2023-08-23 11:37:38
- UUID
-
da8be42f-0c25-467e-9804-c3e978295535
Identifier Namespace Name |
Identifier Namespace Value |
Identifier |
Title_ID
|
title_id
|
1276
|
Dewey Decimal Classification |
-
Series
-
Empty
-
Parent publication title ID
-
Empty
-
Superseding publication title ID
-
Empty
-
Preceding publication title ID
-
Empty
Price Type |
Value |
Currency |