Microsoft Access 2013 for beginners:Start Migration to Database - Course Assessment Answers


This course assessment will review what you have learned to assess your knowledge and understanding of the Microsoft Access 2013 for Beginners course.
Start your database journey

The following learning outcomes will be assessed against:

• Discuss how to navigate Microsoft Access using the ribbon and toolbars.
• Identify ways to customize Access to meet your specific needs.
• Discuss using the desktop or web app version.
• Identify how to create tables and establish relationships between those data tables.
• Identify how to sort, filter, enter, and search data in the database. • Describes how to properly design Access tables, including using Design view and field properties.
• Understand how forms are created, designed, and edited.

To use this website effectively and easily answer Allison's question, watch this quick tutorial that's helpfully put together in the video below.

1. True or False:
The shortcut buttons on the right side of the Access 2013 status bar depend on the selected object. truth
Incorrect
answer:
truth

2. Select Which of the following data types is not a valid data type in Access 2013?
memo
short text
long text
currency
answer:
memo

3. Fill in the blanks:
In design view, the form is divided into his three sections: Header, ________, and Form Footer. answer:
detail


4. This is a shortcut key for creating a new record in the table. Drag the correct answer into the box.
Ctrl+Enter
Ctrl+Insert
Ctrl++
Ctrl+=
answer:
Ctrl++

5. Fill in the spaces:
When creating an Access web app database, the data in the database must be in _______. position
answer:
Central

6. True or False:
In Access 2013, the keyboard shortcut for accessing online help is F1.
truth
Incorrect
answer:
truth

7. True or False:
The Short Text data type in Access 2013 was called Memo in previous versions of Access.
truth
Incorrect
answer:
Incorrect

Eighth. Fill in the blanks:
________ speeds up searching and sorting on fields.
answer:
index

9. Which table field property labels the field when used in the view? Drag the correct answer into the box.
input screen
Indexed
subtitles
Default value
answer:
subtitles

Ten There are many ways to create forms in Access. Please enter the answer numerically.
answer:
Four

11. Select Which tab in the Access 2013 ribbon has relationship groups? database tools
external data
create
House
answer:
database tools


12. Select which of the following is not one of the tooltip style options available in Access 2013?
Show function description in tooltip
Show tooltip
don't show tooltip
Do not display function descriptions in tooltips
answer:
Show tooltip

13. Press which key to display a KeyTip in the Access 2013 Ribbon? Choose.
layer
F1
Year
Control
answer:
Year

14. Select which of the following values ​​will be used by default for AutoNumber fields?
Decimal
long integer
short integer
Part-Time Job
answer:
long integer

15 True or False:
Access 2013 The Quick Access Toolbar always appears above the ribbon.
truth
Incorrect
answer:
Incorrect

16. Fill in the blanks:
To create a lookup field in an Access database, set the data type of the field to Lookup ________.
answer:
magician

17. True or False:
In Access 2013, you can use the Undo command to undo the deletion of records. truth
Incorrect
answer:
Incorrect

18. Select the layouts available when creating forms. pick four
browser
Tabular format
columnar
data sheet
justification
table
answer:
Tabular, columnar, datasheet, justified


19. True or False:
An Access 2013 lookup field can get its value from another table in your database.
truth
Incorrect
answer:
truth

20 Fill in the blanks:
Filtering in Access is very __________ because it depends on the data type of the column.
answer:
Contextual

21. Select Which of the following Access 2013 Ribbon tabs has the Clipboard group?
House
create
format
database tools
answer:
House

twenty two Fill in the blanks:
The key ______ connects two different tables with a relationship.
answer:
foreign country

twenty three 

Comments

Post a Comment

Popular posts from this blog

Concept of quality content

Image
The significance of content cannot be overemphasized in the context of blogging. The distinction between a commendable blog and a mediocre one lies in the caliber of its content. Crafting superior blog posts involves several key components that distinguish them from other posts in the blogosphere. Initially, a high-quality blog entry must exhibit proficient writing abilities and possess well-defined underlying concepts. It is essential for writers to exhibit a fervent dedication towards their chosen topic and effectively communicate this enthusiasm in their discourse. The body of work produced should aim to captivate readers and sustain their interest, without displaying an intrusive or patronizing tone. Moreover, a well-crafted blog entry must be substantiated with statistics. In the field of statistical analysis, metrics can encompass a range of factors, including but not limited to pageviews, likes, and comments. This signifies that the substance is compelling and merits...
Read more

How to get paid search engine traffic in 3 easy steps.

Image
If you're a website owner or blogger, you probably know how important search engine traffic is. It's the lifeblood of any online business and one of the most valuable sources of targeted, quality traffic. But getting search engine traffic can be a daunting task, especially if you're just starting out. Fortunately, it doesn't have to be difficult. This blog post will show you how to get paid search engine traffic in three easy steps.  Step 1:Conducting Keyword Research The first step in generating search engine traffic is keyword research. Keyword research is finding the keywords people use to search for information related to your business or blog. There are many keyword research tools, both free and paid. Some of the most popular include Google Keyword Planner, SEMrush, Ahrefs, and Moz. These tools help identify keywords with high search volume and low competition. Once you have identified your target keywords, you should start optimizing your website or bl...
Read more

How to Peel a Difficult Boiled Egg Successfully

Image
The finest kitchen tips are, as a rule, passed along from companions, guardians, or—if you work in an office with a kitchen—from colleagues. And such is the case with superbly cooked hard-boiled eggs. We all learned to cook them from someone, someplace; they're individual, nostalgic, and conjointly lovely virtuosos. But make no mistakes—they can be finicky and, when hard-boiled, a genuine torment to peel. Here are the steps to peel a hard-boiled egg impeccably: 1. Tap the egg: After bubbling the egg, let it cool down. Tap the hard-boiled egg on the countertop or a difficult surface to make splits all around its shell. 2. Hold the egg beneath running water: Hold the egg beneath running water, which makes a difference in extricating the shell and makes it less demanding to peel off. 3. Peel the shell: Begin to peel the shell at the bigger conclusion of the egg, where there's a discussion stash. Utilizing your thumb, gradually and carefully peel the shell from the egg. 4. Flush th...
Read more