Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Access 365 Beginner
Learn to create databases and update information.Preview the first lesson free — get full access to all 45 lessons.
Beginner Provider : Douglas Bush 8 chapters · 45 Lessons · 2h 49m in Arabic, English, Spanish
Course Description
Understand the basic topics of Access 365. Microsoft Access is a program for creating and updating database information. In this course you will learn about accessing, manipulating, and using database information.
What You'll Learn
- Navigate the Access 365 interface, objects, and Help feature
- Create databases from templates, application parts, or from scratch
- Build tables in Datasheet View and Design View using field properties and data types
- Apply field controls such as required fields, default values, input masks, lookup lists, and data validation
- Add specialized fields including hyperlink and attachment fields
- Create and edit forms using Quick Forms, the Form Wizard, and Layout View
Key Takeaways
- Microsoft Access is a program for creating and updating database information.
- The course covers accessing, manipulating, and using database information.
- It introduces foundational concepts such as database terminology and naming conventions.
- Tables can be created in both Datasheet View and Design View, with control over data types and field properties.
- Forms can be built quickly with Quick Forms and the Form Wizard, then refined in Layout View.
Frequently Asked Questions
What is this course about?
It teaches the basic topics of Access 365, covering accessing, manipulating, and using database information in Microsoft Access.
Who is this course for?
It is a beginner course for those wanting to understand the basic topics of Access 365.
What skills will I gain?
The course develops skills in Microsoft Access, Access Query Languages, Data Access, Microsoft Data Access Components, Microsoft 365, and Microsoft Office 365.
Does the course cover creating tables and forms?
Yes. It covers working with tables (in Datasheet View and Design View) and working with forms, including Quick Forms, the Form Wizard, and editing a form in Layout View.
What database fundamentals are introduced?
The course introduces what Access is, database terminology, naming conventions, starting Access, and navigating the interface and objects.
