Start Access. Open the file Student$\_$Access$\_1$A$\_$Advising.accdb downloaded with this project. Then, in your textbook, turn to Project $1$A and complete all of the steps in Activities $1\mathrm{.}01-1\mathrm{.}17.$

$0$

$2$

Complete Activity $1\mathrm{.}01$ Using Good Design Techniques to Plan a Database

$0$

$3$

Complete Activity $1\mathrm{.}02$ Starting with a Blank Desktop Database.

$0$

$4$

Complete Activity $1\mathrm{.}03$ Assigning the Data Type and Name to Fields.

$10$

$5$

Complete Activity $1\mathrm{.}04$ Renaming Fields, Changing Data Types, and Setting Field Size in a Table.

$4$

$6$

Complete Activity $1\mathrm{.}05$ Adding a Record to a Table.

$10$

$7$

Complete Activity $1\mathrm{.}06$ Adding Additional Records to a Table.

$10$

$8$

Complete Activity $1\mathrm{.}07$ Importing Data from an Excel Workbook into an Existing Access Table.

$10$

$9$

Complete Activity $1\mathrm{.}08$ Deleting a Table Field in Design View.

$5$

$10$

Complete Activity $1\mathrm{.}09$ Adding Field Descriptions and Changing Field Size

$9$

$11$

Complete Activity $1\mathrm{.}10$ Viewing the Primary Key in Design View.

$1$

$12$

Complete Activity $1\mathrm{.}11$ Adding a Second Table to a Database by Importing an Excel Spreadsheet.

$9$

$13$

Complete Activity $1\mathrm{.}12$ Adjusting Column Widths and Viewing a Table in Print Preview.

$0$

$14$

Complete Activity $1\mathrm{.}13$ Viewing a Table in Print Preview.

$0$

$15$

Complete Activity $1\mathrm{.}14$ Creating a Query by Using the Simple Query Wizard.

$10$

$16$

Complete Activity $1\mathrm{.}15$ Creating a Form.

$9$

$17$

Complete Activity $1\mathrm{.}16$ Creating and Modifying a Report.

$11$

$18$

Complete Activity $1\mathrm{.}17$ Closing a Database and Close Access.

$2$

$19$

Save and close the file, and then submit the Access$\_1$A$\_$Advising.accdb database for grading.