Learning Objectives
Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion
Pre-Requisites
Basic computer skills. Knowledge of basic database concepts is helpful but not required.
Description
This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course.
Course Curriculum
| Module 1: Getting Started with Access | |||
| What is a Database | 00:03:00 | ||
| Database Terminology | 00:05:00 | ||
| The Access Interface | 00:08:00 | ||
| What is a Flat File Database | 00:03:00 | ||
| What is a Relational Database | 00:10:00 | ||
| Relating Tables | 00:10:00 | ||
| Reviewing The Access Ribbon | 00:02:00 | ||
| Module 2: Working with Data | |||
| Working with Tables | 00:07:00 | ||
| Navigating Tables | 00:04:00 | ||
| Editing Data | 00:03:00 | ||
| Adding New Records | 00:05:00 | ||
| Using Subdatasheets | 00:04:00 | ||
| Module 3: Creating Databases and Objects | |||
| Understanding Database and Table Design Principles | 00:08:00 | ||
| Using Table Data Sheet View | 00:03:00 | ||
| Working with Field Data Types | 00:07:00 | ||
| Using Table Design View | 00:04:00 | ||
| Calculating Numbers | 00:05:00 | ||
| Calculating Dates | 00:02:00 | ||
| Calculating Strings | 00:03:00 | ||
| Using The Lookup Wizard | 00:12:00 | ||
| Lookup Wizard Linking Tables | 00:09:00 | ||
| Using Indexes | 00:04:00 | ||
| Module 4: Working with Queries | |||
| What are Queries? | 00:08:00 | ||
| Creating Simple Queries | 00:05:00 | ||
| Entering Criteria-Exact Match and Range Operators | 00:05:00 | ||
| Understanding And Versus Or | 00:06:00 | ||
| Using Wildcards | 00:05:00 | ||
| Using Key Words | 00:04:00 | ||
| Sorting and Hiding Fields | 00:03:00 | ||
| Creating Multi-Table Queries | 00:03:00 | ||
| Additional Tips C4 | 00:06:00 | ||
| Module 5: Working with Reports | |||
| What are Reports | 00:05:00 | ||
| Understanding Report Types | 00:03:00 | ||
| Building Good Reports | 00:02:00 | ||
| Using AutoReport | 00:08:00 | ||
| Understanding The Report Wizard | 00:11:00 | ||
| Using the Report Design View | 00:08:00 | ||
| Printing Reports | 00:04:00 | ||
| Creating labels | 00:08:00 | ||
| Additional Tips C5 | 00:10:00 | ||
| Module 6: Working with Forms | |||
| What are Forms | 00:04:00 | ||
| Understanding Form Types | 00:03:00 | ||
| Creating Forms | 00:03:00 | ||
| Navigating Forms | 00:03:00 | ||
| Editing Data in Forms | 00:05:00 | ||
| Understanding the Form Wizard | 00:05:00 | ||
| Using Form Design View | 00:04:00 | ||
| Working with Controls | 00:10:00 | ||
| Using Form Layout View | 00:04:00 | ||
| Additional Tips C6 | 00:07:00 | ||
| Resource | |||
| Resource – Access 365 Beginner | 00:00:00 | ||
FAQs
This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.
No prior qualifications are needed to take this course.
You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!
Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.
Don’t worry if you fail the test, you can retake it as many times as you want.
You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.
We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.
After you complete the course, you’ll immediately receive a free printable PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.
Related Courses
E Commerce Income Essentials
£319.00 0Instagram Marketing
£319.00 0
