What are the main steps to creating a table from scratch in Access?
1. Click the create table button
2. Fill in appropriate fields
3. Save the table
100
What kind of data would you use a Yes/No data type for?
Salaried/Non-Salaried
American/Non-American
In State/Out of State
100
What is the steps to creating a compound primary key?
1. Highlight the rows you needed
2. Click the Primary Key button
200
What are the steps to create a table from an ERD?
1. Entity name becomes the table name
2. Attributes become the field names
3. Primary Keys and foreign keys of the ERD become the primary keys and foreign keys of the table as well.
200
What data type would you use when dealing with money?
Currency.
200
Why should the field size be changed?
To reduce the size of the database.
300
What are the main steps to creating a table from Excel or other external data?
1. Click Import Data under the "External Data" tab
2. Choose the file name to select data
3. Follow the Wizard's instructions
300
What is the data type you use when working with phone numbers and/or social security numbers?