Baza danych w Access - praktyczny tutorial 2021

Share
FizykaTV
Published at : 05 Dec 2021
62557 views
874
16

Praktyczne nagranie, jak szybko i dobrze utworzyć relacyjną bazę danych w oprogramowaniu Microsoft Access 2016 bądź nowszym.

Link do pobrania bazy:
https://drive.google.com/file/d/1lnevNFSLjl5O-aMf2rGfoTafqro1BYXn/view

00:50 Podstawy tworzenia tabel
04:36 Typy danych
05:00 Tabela: widok projektu, poprawność danych, maski
15:15 Relacje między tabelami, łączenie tabel, kreator odnośników
18:00 Reguły sprawdzania poprawności
19:17 Pola obowiązkowe
20:00 Lista dozwolonych wartości w tabeli
22:00 Formularze
26:50 Formularze - przyciski nawigacyjne
29:06 Formularz - menu bazy danych
33:00 Makro AutoExec - autostart przy otwarciu bazy
34:45 Kwerendy - wyciąganie danych z tabel
47:30 Raporty - kreator
accesstutorialbaza danych

Top 5 Income ETFs to Buy | QYLD vs RYLD vs JEPI and More

Top 5 Income ETFs to Buy | QYLD vs RYLD vs JEPI and More

The Perfect Breakfast Food (Chilaquiles 2 Ways)

The Perfect Breakfast Food (Chilaquiles 2 Ways)

Superbly proportioned modern lifestyle retreat

Superbly proportioned modern lifestyle retreat

Mr. Joe dropped Car Keys in Pool and started blow drying them to Started Race on Lancer 10 - 13+

Mr. Joe dropped Car Keys in Pool and started blow drying them to Started Race on Lancer 10 - 13+

Sero ft. Hkeem - Expensive (Official Music Video)

Sero ft. Hkeem - Expensive (Official Music Video)

a *MATERIAL GWORL* Christmas wishlist.

a *MATERIAL GWORL* Christmas wishlist.

مسلسل الأزهار الحزينة | الحلقة 175

مسلسل الأزهار الحزينة | الحلقة 175

Fifty Two Gaj Ka Daman । Pranjal Dahiya । Aman Jaji । Renuka Panwar । Hariyanavi Song । New Version

Fifty Two Gaj Ka Daman । Pranjal Dahiya । Aman Jaji । Renuka Panwar । Hariyanavi Song । New Version

Concerns Grow Over Possible Winter Coronavirus Surge

Concerns Grow Over Possible Winter Coronavirus Surge

10 – Remember, Do Not Forget

10 – Remember, Do Not Forget

Squares And Roots |  Vedic Math Module-3 | Practically

Squares And Roots | Vedic Math Module-3 | Practically

DO THIS DAILY To Increase Your Lifespan & REVERSE AGING! | Dr. Valter Longo & Lewis Howes

DO THIS DAILY To Increase Your Lifespan & REVERSE AGING! | Dr. Valter Longo & Lewis Howes

Israel Vibration - Live And Give

Israel Vibration - Live And Give

What makes YOU unique?

What makes YOU unique?

Addressing the concerns on Runescape content...

Addressing the concerns on Runescape content...

2021 KIA Rio MHEV - The Real Fabia (ENG) - Test Drive and Review

2021 KIA Rio MHEV - The Real Fabia (ENG) - Test Drive and Review

Scary Videos V18

Scary Videos V18

How to deal with police in Thailand

How to deal with police in Thailand

10 Amazing (Less Known) Excel Tricks You Should Know

10 Amazing (Less Known) Excel Tricks You Should Know

How to install a driver and configure a Sharp MFP - Windows Device

How to install a driver and configure a Sharp MFP - Windows Device

"I'm the one that receives, but with the intention to fulfill the Creator."

"I'm the one that receives, but with the intention to fulfill the Creator."

CHỒNG TÔI DẠY TÔI ĐIỀU GÌ VỀ BÌNH ĐẲNG GIỚI?

CHỒNG TÔI DẠY TÔI ĐIỀU GÌ VỀ BÌNH ĐẲNG GIỚI?

Why did no one tell us it could be this EASY #25

Why did no one tell us it could be this EASY #25

How to FIND YOUR WORTH, Let Go of SHAME and Own Your VALUE | Sarah Jakes Roberts on Women of Impact

How to FIND YOUR WORTH, Let Go of SHAME and Own Your VALUE | Sarah Jakes Roberts on Women of Impact

Hotline Miami 2 - "Remorse" [Nightclub Version]

Hotline Miami 2 - "Remorse" [Nightclub Version]

SQUID GAME SCARY DOLL GOT TRAPPED OF MY FAMILY MINIONS iN MINECRAFT ! - Gameplay green light traps

SQUID GAME SCARY DOLL GOT TRAPPED OF MY FAMILY MINIONS iN MINECRAFT ! - Gameplay green light traps

10 most important priority to consider to become Successful in life

10 most important priority to consider to become Successful in life

Η Γη της Ελιάς Επ. 58 | Sneak Preview

Η Γη της Ελιάς Επ. 58 | Sneak Preview

Metal sculptures created from 100000 automobile parts. Created by Rajhardstyle

Metal sculptures created from 100000 automobile parts. Created by Rajhardstyle

🙏 Asking For Forgiveness

🙏 Asking For Forgiveness

CPS cannot be canceled: Sajjala Ramakrishna Reddy sensational | PRC | CPS CANCEL | paru media works

CPS cannot be canceled: Sajjala Ramakrishna Reddy sensational | PRC | CPS CANCEL | paru media works

English File Elementary 10A

English File Elementary 10A

“Third time is the charm” ✝️💍 VERY SPECIFIC Marriage Word from the Lord 🤍

“Third time is the charm” ✝️💍 VERY SPECIFIC Marriage Word from the Lord 🤍

X Factor 2021 | Anteprima Repower della FINALE

X Factor 2021 | Anteprima Repower della FINALE

The Point Of View: The latest on the E-Levy; what it may mean for you

The Point Of View: The latest on the E-Levy; what it may mean for you

Top fancy and Attractive Velvet Slimfit Bodycon Dress Design ideas Collection 2k20

Top fancy and Attractive Velvet Slimfit Bodycon Dress Design ideas Collection 2k20

لا تفتح حساب في بنك wise قبل مشاهدة هذه الفيديو

لا تفتح حساب في بنك wise قبل مشاهدة هذه الفيديو

LOBA BUT WITH MOVEMENT

LOBA BUT WITH MOVEMENT

Short Men Are Generally More Disrespectful and Insecure When Approaching Me! What Can I Do?

Short Men Are Generally More Disrespectful and Insecure When Approaching Me! What Can I Do?

Custom Rooms With Banana Guy  | Chance to Win UC

Custom Rooms With Banana Guy | Chance to Win UC

BOYFRIEND vs. CARTOON CAT! (Cartoon Animation)

BOYFRIEND vs. CARTOON CAT! (Cartoon Animation)

Strong storm for December 13th with high winds, heavy rain and significant mountain snowfall.

Strong storm for December 13th with high winds, heavy rain and significant mountain snowfall.

2021 Mercedes-AMG Project ONE  - Forza Horizon 5 | Logitech G29 [4K]

2021 Mercedes-AMG Project ONE - Forza Horizon 5 | Logitech G29 [4K]

STONE GIANT vs 5x EVERY GOD | TABS - Totally Accurate Battle Simulator

STONE GIANT vs 5x EVERY GOD | TABS - Totally Accurate Battle Simulator

IF FOOD WERE PEOPLE || Candy is Person! Cool Food Pranks and Funny Tricks by 123 GO! FOOD

IF FOOD WERE PEOPLE || Candy is Person! Cool Food Pranks and Funny Tricks by 123 GO! FOOD

Level Up PIGMENT POWDERS & FAUX Josephs Coat #shorts

Level Up PIGMENT POWDERS & FAUX Josephs Coat #shorts

For That Reason

For That Reason

An elegant Lisbon expedition....

An elegant Lisbon expedition....

Balinese Dance #3 - solo- a girl is performing a traditionally boy's part, who came back from war

Balinese Dance #3 - solo- a girl is performing a traditionally boy's part, who came back from war