Access Lesson 2 Pt. 2

Where is the command for creating a new table from Table Design view?

• File tab
• Home Ribbon
• Create Ribbon
• Database Tools Ribbon

Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. What data type should he use?

• Auto Number
• Currency
• Yes/No
• Hyperlink

Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?

• Determine what information to include
• Discuss the database with users
• Gather the information
• Input data

Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. What is auto numbering an example of?

• Data Type
• Description
• Field name
• Properties

Curt needs to create a backup to his existing database on an external hard drive. What action should he take?

• Close 
• Create New
• Open from Existing 
• Save As

Matt needs to add his contacts to the Driver Education database. To do this quickly, what predefined object can he create?

• Application Parts
• Quick Start
• Sharepoint List
• Database Object

What are three valid methods for saving a database in Microsoft Access?

• Alt + S, File tab Save command, Quick Access Toolbar Save command
• Alt + S, Home Ribbon Save command, Quick Access Save command
• Alt + S, File tab Save command, Shortcut Save command
• Ctrl + S, File tab Save command, Quick Access Save command