К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Microsoft Access 2021 - Beginner to Advanced · LearnSpace
Назад в каталог
courseraIT и технологии

Microsoft Access 2021 - Beginner to Advanced

Курс от Packt
Средний≈ 31.2 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. This all-encompassing course takes you from the fundamentals of Microsoft Access 2021 to advanced database management and programming. You’ll begin by mastering the Access interface, database creation, tables, and relationships, building a strong foundation in organizing and managing data efficiently. As you advance, you'll explore forms, queries, reports, and automa88tion using macros and Visual Basic for Applications (VBA) to enhance productivity. The course flows naturally from beginner concepts like templates and basic data entry to sophisticated techniques such as SQL queries, multi-user database splitting, security practices, and VBA programming. Practical exercises are integrated throughout to reinforce your learning and provide hands-on experience. You’ll learn how to customize your databases for real-world business scenarios, ensuring you can create reliable, efficient, and secure Access applications. Ideal for database beginners, office professionals, and aspiring developers, this course requires no prior Access experience but benefits those familiar with basic office software. The difficulty ranges from beginner to advanced, making it suitable for a broad audience eager to gain comprehensive Access skills.

Навыки, которые вы освоите

Data SharingMicrosoft SQL ServersReport WritingData IntegrationUser Interface (UI) DesignDatabase DevelopmentData EntryIT AutomationDatabase Architecture and Administration

Программа курса

30 модулей · 174 учебных материалов

01Introduction to the Beginner's Course5 материалов

Introduction to the Beginner's Course

Introduction to Access 2021ВидеоAcquiring Access 2021ВидеоWhat's New in Access 2021?ВидеоExercise 01Видео

Учитесь у экспертов

Packt - Course Instructors

Преподаватель курса

Microsoft Access 2021 - Beginner to Advanced
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 31.2 ч

30 модулей

Язык: Английский

Субтитры: Казахский

Часть программы вашего университета
Full Course ResourcesЧтение
02Get Started with Access 202111 материалов

Get Started with Access 2021

Use Database TemplatesВидеоCreate, Save, and Open DatabasesВидеоExplore the Access Interface and BackstageВидеоCustomize the Quick Access ToolbarВидеоAccess MenusВидеоKeyboard Shortcuts and Key TipsВидеоOnline HelpВидеоAccess OptionsВидеоExercise 02ВидеоExploring Microsoft Access TemplatesDIALOGUEGet Started with Access 2021 - AssessmentЗадание
03Work with Tables8 материалов

Work with Tables

Create a Table and FieldsВидеоIndex Fields, Primary Keys, and Add RecordsВидеоUse the Lookup Wizard to Create a Drop-Down ListВидеоNumeric Fields and Data Validation RulesВидеоAdd More Table FieldsВидеоExercise 03ВидеоCreating and Managing Database Tables in AccessDIALOGUEWork with TablesЗадание
04Import Data5 материалов

Import Data

Importing Data from ExcelВидеоImporting Data from a Text FileВидеоExercise 04ВидеоBulk Importing DataDIALOGUEImport Data - AssessmentЗадание
05Datasheet View6 материалов

Datasheet View

Design in the Datasheet ViewВидеоSort and Filter in Datasheet ViewВидеоEnter and Modify Data in Datasheet ViewВидеоExercise 05ВидеоMaking Design Changes in Datasheet ViewDIALOGUEDatasheet View - AssessmentЗадание
06Create Relationships8 материалов

Create Relationships

Relationships ExplainedВидеоSet Up RelationshipsВидеоCreate a Link Table: Part 1ВидеоCreate a Link Table: Part 2ВидеоEdit the Link TableВидеоExercise 06ВидеоCreate Relationships - AssessmentЗаданиеBuilding and Managing Table Relationships in AccessDIALOGUE
07Forms8 материалов

Forms

Create a Form: Form WizardВидеоForm PropertiesВидеоModify a Form: Single Form Versus Continuous ViewВидеоForms in Layout ViewВидеоForms in Design ViewВидеоExercise 07ВидеоBuilding User FormsDIALOGUEForms - AssessmentЗадание
08Subforms4 материалов

Subforms

Setting Up Subforms: Part 1ВидеоSetting Up Subforms: Part 2ВидеоExercise 08ВидеоSubforms - AssessmentЗадание
09Queries6 материалов

Queries

Create a QueryВидеоINNER, RIGHT, and LEFT JoinsВидеоRun Queries and Aggregate Numeric Data Using Query WizardВидеоExercise 09ВидеоCreating and Using Queries in AccessDIALOGUEQueries - AssessmentЗадание
10Validations and Expressions5 материалов

Validations and Expressions

Set Up More Validations and ExpressionsВидеоBasic Calculations Using ExpressionsВидеоExercise 10ВидеоImplementing Data Validation RulesDIALOGUEValidations and Expressions - AssessmentЗадание
11Reports6 материалов

Reports

Run a Basic ReportВидеоCustom Report DesignВидеоComplex ReportsВидеоExercise 11ВидеоCreating Basic Reports in AccessDIALOGUEReports- AssessmentЗадание
12More Data Types5 материалов

More Data Types

Other Data Types: Yes/NoВидеоOther Data Types: AttachmentsВидеоExercise 12ВидеоExploring YES/NO and ATTACHMENT Data Types in AccessDIALOGUEMore Data Types - AssessmentЗадание
13More About Forms6 материалов

More About Forms

Form Controls: Option ButtonsВидеоForm Themes and DesignВидеоNavigation FormsВидеоExercise 13ВидеоCreating and Using Option Groups in Access FormsDIALOGUEMore About Forms - AssessmentЗадание
14Share an Access Database5 материалов

Share an Access Database

Export Parts of an Access DatabaseВидеоDatabase Properties and EncryptionВидеоExercise 14ВидеоExporting and Encrypting Access ReportsDIALOGUEShare an Access Database - AssessmentЗадание
15Additional Access Features5 материалов

Additional Access Features

Compact and RepairВидеоPrinting and Database DocumenterВидеоExercise 15ВидеоMaintaining and Documenting Access DatabasesDIALOGUEAdditional Access Features - AssessmentЗадание
16Beginner Course Close3 материалов

Beginner Course Close

Course CloseВидеоReviewing MS Access FundamentalsDIALOGUEBeginner Course Close - AssessmentЗадание
17Introduction to the Advanced Course4 материалов

Introduction to the Advanced Course

Course IntroductionВидеоSet Up for Success in Access 2021ВидеоAdvanced Database Management with Microsoft Access 2021DIALOGUEIntroduction to the Advanced Course - AssessmentЗадание
18Primary Keys and Indexes4 материалов

Primary Keys and Indexes

Primary Keys and Indexing Rules and GuidelinesВидеоMore About IndexesВидеоPrimary Keys and Indexes - AssessmentЗаданиеDesigning Efficient Database IndexingDIALOGUE
19Using Datasheet View8 материалов

Using Datasheet View

Set Up the Northwind DatabaseВидеоWork in a Datasheet ViewВидеоCustomize Datasheet ViewВидеоAdvanced Sorting and Filtering in Datasheet ViewВидеоSubdatasheetsВидеоExercise 01ВидеоWorking with Datasheet Views using AccessDIALOGUEUsing Datasheet View - AssessmentЗадание
20Linking to Other Access Databases3 материалов

Linking to Other Access Databases

Linking Two Tables to Other Access DatabasesВидеоLinking Tables in Access DatabasesDIALOGUELinking to Other Access Databases - AssessmentЗадание
21Using ODBC and SQL Servers5 материалов

Using ODBC and SQL Servers

Install SQL Server ExpressВидеоSet Up SQL Server ExpressВидеоExercise 02ВидеоInstalling SQL Server Express and ODBC SetupDIALOGUEUsing ODBC and SQL Servers - AssessmentЗадание
22Splitting an Access Database6 материалов

Splitting an Access Database

Splitting an Access Database into Frontend and BackendВидеоConvert to Local TableВидеоAddressing Multi-User Issues When Sharing DataВидеоExercise 03ВидеоSplitting and Managing an Access DatabaseDIALOGUESplitting an Access Database - AssessmentЗадание
23Macros7 материалов

Macros

Basics of MacrosВидеоMacro on Events; AutoExecВидеоMore About AutoExecВидеоMacro Security SettingsВидеоExercise 04ВидеоMacros - AssessmentЗаданиеCreating and Running Macros in AccessDIALOGUE
24The Ribbon3 материалов

The Ribbon

Customize the Quick Access Toolbar and TabsВидеоThe Ribbon - AssessmentЗаданиеCustomizing Quick Access Toolbar and RibbonsDIALOGUE
25Visual Basic for Applications7 материалов

Visual Basic for Applications

Convert Macros to VBAВидеоRun VBA Code and Error HandlingВидеоCreate Modules: Subs, Functions, Intellisense, and VariablesВидеоScope, Variable Naming, and StringsВидеоStandard Functions: Logical, Case, and LoopsВидеоIntroduction to VBA Programming in AccessDIALOGUEVisual Basic for Applications - AssessmentЗадание
26Access Events Model7 материалов

Access Events Model

Adding Events to Assets DatabaseВидеоExercise 05ВидеоCommon Events: Form and Report EventsВидеоSwitchboard, Navigation Forms, and Error HandlingВидеоExercise 06ВидеоAccess Events Model - AssessmentЗаданиеImplementing Events in AccessDIALOGUE
27Forms7 материалов

Forms

Formatting Bound and Control FormsВидеоSplit Forms and Macro Error HandlingВидеоCreating Form with TabВидеоGo to Combo Box and Its PropertiesВидеоExercise 07ВидеоForms - AssessmentЗаданиеWorking with Access Forms and ControlsDIALOGUE
28Advanced Use of Queries10 материалов

Advanced Use of Queries

Basics of QueriesВидеоSyntax of SQL StatementsВидеоUse of Multiple Where Criteria and Select Statements FunctionВидеоJoins and Join TypesВидеоExercise 08ВидеоAction Queries - Part 1ВидеоAction Queries - Part 2ВидеоSubqueriesВидеоCreating and Using SQL QueriesDIALOGUEAdvanced Use of Queries - AssessmentЗадание
29Protecting the Database and Code4 материалов

Protecting the Database and Code

Protect the Database and VBA CodeВидеоExercise 09ВидеоEncrypting Databases and Protecting CodeDIALOGUEProtecting the Database and Code - AssessmentЗадание
30Conclusion3 материалов

Conclusion

Course CloseВидеоFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание