Deck 1: Creating a Database and Tables

Question 1

The Save,Undo,and Redo commands are by default displayed on the Quick Access toolbar.

Answer 1

True

Question 2

In the Object Designers category of the Access Options dialog box,you control the settings and options used in Design view of the different database objects.

Answer 2

True

Question 3

You can customize the Ribbon to add a new group to a tab or add commands you commonly use that are not included on the Ribbon.

Answer 3

True

Question 4

If you upgrade from Office 2010 to Office 2013,many of your settings are automatically transferred for you.

Question 5

Members you invite to your SkyDrive group do not need a Microsoft account to access the group.

Question 6

It is possible to reset your Ribbon and your Quick Access toolbar to their original settings.

Question 7

If you're using SkyDrive on a public computer,do not check the Keep me signed in check box.

Question 8

With Office Web Apps,you can work with Office files online without having Office 2013 installed on the computer you are using.

Question 9

You can customize Access's global settings using the Access Options dialog box.

Question 10

Using the General category in the Access Options dialog box,the background and theme you select apply to just Microsoft Access,not all the Office applications.

Question 11

SkyDrive group members have the same access as owners and co-owners.

Question 12

Most changes you make in the Proofing category only affect your settings in Microsoft Access.

Question 13

Some programs you install on your computer are recognized by Office as add-in programs such as Google Desktop,Acrobat PDFMaker,or Snag-It.

Question 14

Most of the Object Designers settings have no impact when viewing an object in Datasheet or Layout view.

Question 15

When you have a Microsoft account,you also have a SkyDrive account.

Question 16

Cloud storage means you don't have to be tied to one computer.

Question 17

In the Page Setup dialog box,you can set SkyDrive as the default save location.

Question 18

You can add commands new commands to,and remove existing commands from,existing groups.

Question 19

If you belong to a team at work or school or an organization,you can create a SkyDrive group to store and share documents.

Question 20

With Windows 8,SkyDrive is one of your storage location folders,similar to your Documents or Pictures folders.

Question 21

In the Access Options dialog box,which category lets you show or hide horizontal and vertical gridlines between cells,modify the appearance of a cell,and change the default column width?

A) General
B) Datasheet
C) Proofing
D) Object Designers

Question 22

How do you access the Access Options dialog box?

A) File menu
B) View menu
C) Page Setup dialog box
D) Backstage view

Question 23

In the General category of the Access Options dialog box,you can change your user name and initials and make it so your Access settings are imposed for all users on the current computer.

Question 24

In Excel and Access Web Apps,you can add comments to a file,review comments from others,reply to comments,mark comments as done,and delete comments.

Question 25

In the Access Options dialog box,which category enables you to customize the appearance of ScreenTips?

A) General
B) Datasheet
C) Proofing
D) Object Designers

Question 26

In the Access Options dialog box,which category lets you tell Access to automatically create an index for any fields with names that contain the characters entered in the box?

A) General
B) Datasheet
C) Proofing
D) Object Designers

Question 27

Office Web Apps is as robust in terms of features as Office 2013.

Question 28

If you edit a document in SkyDrive,your file opens in the corresponding Office Web App and is displayed in either read-only mode or edit mode.

Question 29

In the Access Options dialog box,which category lets you control the settings and options used in Design view?

A) General
B) Datasheet
C) Proofing
D) Object Designers

Question 30

Office Web Apps lets you synchronously or asynchronously collaborate on an Office file with others who have access to the shared file.

Question 31

You create a custom tab with groups and add command buttons you regularly use into groups on that tab.

Question 32

The Trust Center helps keep your documents safe and prevents your documents and computer from becoming infected with viruses.

Question 33

In the Access Options dialog box,which category lets you add,edit,or delete words from a custom dictionary?

A) General
B) Datasheet
C) Proofing
D) Object Designers

Question 34

The language settings in Office are determined by the default language you selected in Office Web Apps.

Question 35

The difference when printing in Office Web Apps and in Office 2013 is that Office Web Apps creates a PDF file.

Question 36

The working environment in Office Web Apps is very similar to Microsoft Office.

Question 37

In the Access Options dialog box,which category lets you control Design view for forms and reports?

A) General
B) Datasheet
C) Proofing
D) Object Designers

Question 38

In the Access Options dialog box,which category would you use to enable or disable Live Preview?

A) General
B) Datasheet
C) Proofing
D) Object Designers

Question 39

In the Access Options dialog box,which category would you use to enable or disable hardware graphics acceleration?

A) General
B) Datasheet
C) Proofing
D) Object Designers

Question 40

In the Access Options dialog box,which category lets you customize how Access corrects and formats the content in your databases?

A) General
B) Datasheet
C) Proofing
D) Object Designers

Question 41

Which of the following must members you invite to your group have in order to access the group?

A) Microsoft account
B) user name
C) password
D) all of the above

Question 42

Which of the following statements is not true about customizing the ribbon?

A) You can rearrange groups on tabs.
B) You can rearrange tabs on the Ribbon.
C) You can rearrange existing commands within existing groups.
D) You can rearrange commands in custom groups.

Question 43

Which of the following is a "cloud" storage area where you can store files in an online location?

A) SkyDrive
B) SharePoint
C) Windows
D) OneNote

Question 44

In the Access Options dialog box,which of the following categories can you use to help keep your documents safe and prevent them from becoming infected with viruses?

A) Language
B) Advanced
C) Add-Ins
D) Trust Center

Question 45

Which category in the Access Options dialog box lets you create a new group on the Home tab that includes a button to go back after clicking a hyperlink?

A) Customize Ribbon
B) Quick Access Toolbar
C) Add-Ins
D) Trust Center

Question 46

In the Access Options dialog box,which of the following categories can you use to add functionality to your Office programs?

A) Language
B) Advanced
C) Add-Ins
D) Trust Center

Question 47

What happens when you download items from SkyDrive?

A) The items are removed from SkyDrive.
B) The items are not removed from SkyDrive.
C) You are prompted to give the files new names.
D) You will be asked whether you want to add a password to the files.

Question 48

Which of the following statements is true about emailing SkyDrive group members?

A) When you create a group,you choose an e-mail address for the group.
B) You can send an email to the group using the SkyDrive group email address.
C) When you send an email to a SkyDrive group,it is sent to each of the group members.
D) all of the above

Question 49

When are your Microsoft user name and password set up?

A) when you purchase your computer
B) when you purchase Office 2013
C) when you install Office 2013
D) both B and C

Question 50

Which of the following commands are displayed by default on the Quick Access toolbar?

A) Save
B) Undo
C) Redo
D) all of the above

Question 51

Which of the following is a type of Microsoft account?

A) Live
B) Hotmail
C) Messenger
D) all of the above

Question 52

Which of the following can you use to share a file?

A) SkyDrive
B) SkyDrive group
C) Office Web Apps
D) all of the above

Question 53

Which of the following does your Microsoft account enable you to sign into?

A) Windows
B) Office
C) free Microsoft online services
D) all of the above

Question 54

Which of the following statements is true about resetting the Ribbon and the Quick Access toolbar?

A) You can reset your Ribbon to their original settings.
B) You can reset your Quick Access toolbar to their original settings.
C) When resetting the Ribbon,it is possible to reset a specific tab.
D) all of the above

Question 55

Which of the following can you insert in Word Web App and PowerPoint Web App that you can't insert in Access?

A) text
B) graphics
C) titles
D) comments

Question 56

Which of the following statements is not true about using SkyDrive in a Windows folder?

A) The primary difference between the SkyDrive folder and other Windows folders is the physical location where the files are stored.
B) If you save a document in your Documents folder,you also have access to this file on the SkyDrive cloud.
C) When you save a document in your SkyDrive folder,the file is stored on the SkyDrive cloud.
D) When a document is stored on the SkyDrive cloud,you have access to the file from your computer and any other computer with Internet access.

Question 57

In the Access Options dialog box,which of the following categories do you use to select the language to use for spelling,grammar,dictionaries,and sorting?

A) Language
B) Advanced
C) Add-Ins
D) Trust Center

Question 58

After creating a SkyDrive group,what does your group then have?

A) a name
B) a web address
C) a group email address
D) all of the above

Question 59

Which of the following statements is not true about customizing the Quick Access toolbar?

A) You can customize the Quick Access toolbar for the current database only.
B) You can customize the Quick Access toolbar for all databases.
C) You can add frequently used commands to the Quick Access toolbar.
D) The Quick Access toolbar is located on the bottom of the Access window.

Question 60

Which of the following happens when you upload files to your SkyDrive?

A) You are removing the files from the original location.
B) You are copying the files from the original location.
C) You are prompted to give the files appropriate SkyDrive names.
D) You will be asked whether you want to add a password to the files.

Question 61

In the Access Options dialog box,which of the following tasks can you perform with the Datasheet options category?

A) change how database content is displayed
B) show or hide horizontal and vertical gridlines between cells
C) modify the appearance of a cell
D) all of the above

Question 62

When you invite people to become members of a SkyDrive group,what is their permission level by default?

A) owners
B) co-owners
C) members
D) none of the above

Question 63

Which of the following statements is not true about the Ribbon?

A) All Access commands are included on the Ribbon.
B) Not all available commands are included in the Ribbon.
C) You can create a custom tab with groups and commands.
D) all of the above

Question 64

How do you access Office Web Apps?

A) Backstage view
B) SkyDrive web page
C) File tab
D) Share tab

Question 65

Which of the following statements about printing an Office Web Apps file is not true?

A) You can print files from Office Web Apps similarly to how you print files in Office.
B) The difference when printing in Office Web Apps is that the program creates a PDF file when you print a document.
C) You can print from only read-only mode.
D) The PDF format retains the document's original formatting.

Question 66

After you create a group and invite members,which of the following can you do?

A) add new members
B) remove members
C) change roles of members
D) all of the above

Question 67

Which of the following lets you work with Office files online without having Office 2013 installed on the computer you are using?

A) SkyDrive
B) SharePoint
C) Office Web Apps
D) All of the above

Question 68

Which of the following statements is not true about the options in the Language category?

A) You can add a new language.
B) You can set a language as the default language.
C) You can remove a language.
D) The default language in Access is always English.

Question 69

If you edit an Excel worksheet in SkyDrive,what does your worksheet open in?

A) Office Web App
B) Excel Web App
C) SharePoint
D) OneNote

Question 70

How many people must be collaborating in Office Web Apps for collaboration information to be displayed in the Status bar in the bottom right corner of the Office Web Apps window?

A) two
B) three
C) four
D) five

Question 71

When customizing the Quick Access toolbar,which of the following statements is true?

A) You can choose to customize it for all documents.
B) You can choose to customize it for the current document only.
C) both A and B
D) The Save button is not displayed on the Quick Access toolbar by default.

Question 72

After customizing the Ribbon and the Quick Access toolbar,which of the following tasks might you want to perform?

A) remove commands
B) remove groups
C) remove tabs
D) all of the above

Question 73

Which of the following can you do with Office Web Apps?

A) create new Word documents
B) create new Excel workbooks
C) create PowerPoint presentations
D) all of the above

Question 74

Which of the following should you do if you are using your Microsoft account on a public computer?

A) save your work
B) copy your work
C) close your document
D) log out of your Office account

Question 75

Which of the following can create files and folders,and edit them,but can't customize group options?

A) owners
B) co-owners
C) members
D) none of the above

Question 76

Which of the following can you use to create a few Microsoft account?

A) www.live.com
B) www.microsoft.com
C) www.hotmail.com
D) www.messenger.com

Question 77

Which of the following have full access to create,edit,and delete files and folders in the group?

A) owners
B) co-owners
C) members
D) both A and B

Question 78

Which of the following is a true statement about how Access proofs a datasheet?

A) Access checks the spelling of all database objects.
B) Access checks the spelling of control names.
C) Access only checks the spelling of the actual data values entered into the table fields.
D) all of the above

Question 79

Which of the following is a note-taking application that is part of Microsoft Office?

A) Office Web App
B) Word Web App
C) SharePoint
D) OneNote

Question 80

Which of the following can you do with Office Web Apps?

A) create and edit documents
B) print and share documents
C) insert comments on files
D) all of the above