Access 2019 Database Concepts

This video tutorial by Devin introduces Microsoft Access 2019, focusing on setting up the application on Windows, navigating the Start screen, and using templates to create databases. It covers the Contacts template in detail, explaining how to manage and customize it. The tutorial also addresses security considerations when using templates and demonstrates how to reopen databases and utilize welcome screens. The session concludes with a preview of the next module, which will cover saving and opening databases.

What is the first step to open Microsoft Access on a Windows 10 computer?

• Open Access from the Control Panel

• Install Access from a CD

• Download Access from the internet

• Search for Access in the Start menu

Why is it recommended to pin Access to the taskbar?

• To automatically update the application

• To access it quickly without searching

• To prevent it from being uninstalled

• To change its default settings

What can you find on the Access Start screen?

• A collection of database templates

• A list of installed applications

• A list of recent documents

• A tutorial on using Access

What are the two types of databases you can create in Access 2019?

• Local and Cloud

• Static and Dynamic

• Desktop and Web App

• Personal and Professional

What is the benefit of using a template in Access?

• It provides a pre-built structure to start with

• It automatically fills in all data fields

• It prevents data loss

• It increases the speed of the application

What information is provided when you select a template in Access?

• A list of all available templates

• A tutorial video

• A preview and description of the template

• A list of all users

What is the file extension for Access databases?

• .xlsx

• .docx

• .mdb

• .accdb

Why might you receive a security warning when opening a template?

• The template is not compatible with your system

• The template is from an unverified source

• The template is too large

• The template is outdated

What should you do if you trust the source of a template but receive a security warning?

• Delete the template

• Ignore the warning

• Click 'Enable Content'

• Restart Access

What is the purpose of a welcome screen in a shared database?

• To show a list of all users

• To display recent changes

• To offer a tutorial on using the database

• To provide a login interface