Question: Fields Examples Data Type Field Length (Number of Characters) 1 R adius from home 20 Miles Short Text 255 2 P rice $20,000.00 Currency 255
|
| Fields | Examples | Data Type | Field Length (Number of Characters) |
| 1 | Radius from home | 20 Miles | Short Text | 255 |
| 2 | Price | $20,000.00 | Currency | 255 |
| 3 | Age (in yrs old) | 3 | Number | 255 |
| 4 | Mileage | 45,000 | Number | 255 |
| 5 | Make | Ford | Short Text | 255 |
| 6 | Model | Edge | Short Text | 255 |
| 7 | Doors | 4 | Number | 255 |
| 8 | Leather | Yes | Yes/No | 255 |
| 9 | Back Up Camera | No | Yes/No | 255 |
| 10 | Bluetooth | Yes | Yes/No | 255 |
Part 2 - Describe how you could use the following MS Access 2013 features with your database. You must use specific fields and examples that you provided in Part 1 (above). Apply what you have learned from MS Access 2013 Unit A-D Assignments in your textbook and refer to the Web Site Links for examples, as necessary. (45 points - 15 points each)
Queries:
Forms:
Reports:
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
