A Beginners Guide For Creating a Microsoft Access Database

Watch this video for a beginners guide for creating a Microsoft Access database. We will cover all the basics for beginners to create a Microsoft Access Database including defining a relational database and its objects, how to start Microsoft Access, creating database objects including tables, queries, forms, and reports, an overview of table relationships, and MORE. This is a great introduction guide for Microsoft Access for any beginner.

⌚ Time Stamps:
00:00 - Introduction to A Beginners Guide For Creating a Microsoft Access Database
00:24 - Defining a Relational Database in Microsoft Access
01:34 - Starting Microsoft Access
03:14 - Creating Tables in a Microsoft Access Database
11:37 - Creating Relationships in a Microsoft Access Database
12:31 - Creating Queries in a Microsoft Access Database
18:46 - Creating Forms in a Microsoft Access Database
20:26 - Creating Reports in a Microsoft Access Database
21:24 - Defining Microsoft Access Database Objects
22:14 - Conclusion for A Beginners Guide For Creating a Microsoft Access Database
------------

👨‍🏫 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 #IntroToAccess #Office365 #MS Access #AccessForBeginners #MyExcelOnline

[mortenrobinson]

11:31 How come I don't see any of those system tables when I click the relationships button in the database tools?

[mortenrobinson]

6:04 How come the ID autonumbering starts at 11 when you paste from the excel? I didn't paste from excel, but my autonumbering starts at 1 and not 11, and I can't edit that field at all since it is set to auto, so how do you get it to start from 11? I think it makes sense that my autonumber ID starts at 1, but it doesn't make much sense that yours skip the first 10 numbers and start at 11.

[designerphotography]

how did you get the asset Id column to go away right before you pasted the spreadsheet data?