An Introduction to Microsoft Access Database Vocabulary

Watch this video for an introduction to Microsoft Access database vocabulary. Microsoft Access has a lot of terms that may be new to a beginner, so we thought it would be a good idea to give an introduction to some of those terms. We have included vocabulary explanations for Microsoft Access databases; objects including tables, queries, forms, reports, macros, and modules; relationships; and MORE! This is a great video for beginners starting to use Microsoft Access.

⌚ Time Stamps:
00:00 - Introduction to An Introduction to Microsoft Access Database Vocabulary in Microsoft Access
00:41 - Microsoft Access Database Terms
02:18 - Microsoft Access Database Object Terms
03:14 - Microsoft Access Database Table Terms
05:30 - Microsoft Access Database Relationship Terms
07:16 - Microsoft Access Query Terms
10:00 - Microsoft Access Form Terms
12:40 - Microsoft Access Report Terms
13:37 - Microsoft Access Macro Terms
14:33 - Microsoft Access Module Terms
14:51 - Conclusion for An Introduction to Microsoft Access Database Vocabulary
------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...

🔥 OUR BEST EXCEL RESOURCES 🔥

------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MicrosoftAccess #Access #AccessVocabulary #Office365 #MSAccess #AccessForBeginners #MyExcelOnline

[mortenrobinson]

Is there a way to delete a record entirely, so that it also decrements the autonumber back to it's previous value and/or updates the autonumber on all records? Or is there a way to manually decrement this autonumber? I would like to be able to make mistakes when working in access and then still keep things neat and tidy when I correct those mistakes. My obsessive compulsive disorder simply can't handle seeing a giant hole in the autonumbering due to deleted record entries 😱😱😱 Is Access something that people with OCD should just avoid altogether?

Your Manufacturers table for example, it starts the autonumbering from 11, because you apparently initially made a mistake or changed you mind or something on your first 10 entries, and then you deleted them and made 10 new entries that now start from 11 😱😱😱 How can you be fine with looking at such a mess? Is there simply no way to correct this other than starting a new database from scratch and being diligent not to make any mistakes?