Access Database Management Concepts

In this video tutorial, Deb guides viewers through the process of creating, saving, and managing databases in Microsoft Access 2019. The tutorial begins with a recap of the previous module, then moves on to demonstrate how to create and save databases, including handling warning messages and file management. Deb also explains how to open and manage multiple databases, including accessing files stored locally or in the cloud. The tutorial concludes with instructions on creating a new blank database for a travel company project and clarifies the difference between closing a database and closing the Access application.

What was the focus of the previous module before discussing database creation?

• Exploring Access templates

• Creating a new database

• Managing database security

• Understanding the Access workspace

What must be done before saving a database with a new name?

• Open the backstage area

• Create a new database

• Close all open objects

• Enable content

What is the default file extension for an Access database?

• .docx

• .xlsx

• .mdb

• .accdb

Where can you save a database to access it from multiple devices?

• Cloud storage

• USB drive

• External hard drive

• Local hard drive

What should you do if you see a security warning after opening a database?

• Ignore the warning

• Close the database

• Click 'Enable Content'

• Reopen the database

What is the first step in creating a new blank database?

• Open an existing database

• Select 'New' and choose 'Blank Database'

• Save the current database

• Close all open databases

What is the purpose of adding '01' to the end of a database name?

• To specify the file type

• To denote the file location

• To mark it as a template

• To indicate the version

What is the name of the travel company for which a new database is created?

• Global Tours

• Adventure Travels

• Esprit de Tour

• Travel World

What happens when you click 'Close' under the File menu?

• Access application closes

• Current database closes

• A new database opens

• All databases close

What is the next module about after this one?

• Managing templates

• Database security

• Access workspace and backstage area

• Creating new databases