e Create a new table using the Table data sheet view with the following fields and datatypes, and in the following order: ID(autonumber which is automatically added by access) CommentDate (date&time), and comments (long text). Save the t

create a new database from the contacts template with the name Contacts and save it to the default folder - correct answer click contacts under file name, type "Contacts" Click Create Create a new table using the Table data sheet view with the following fields and datatypes, and in the following order: ID(autonumber which is automatically added by access) CommentDate (date&time), and comments (long text). Save the table with clientcomments as the table name - correct answer Click create ribbon click table click the "click to add" heading select date & time type CommentDate select long text type comments press ENTER click the save button (red at top) save as: type ClientComments click ok in data sheet view of the clients table, change the data acquired field to date/time data type - correct answer click 1st cell under date acquired click fields click data type arrow select date/time ChangethefieldnameofCostPerPersonwithFeeasthenewname - correct answer right click "manager email address" click rename field type email press enter with the clients table in data sheet view, change the field size of the state field to 2 and click yes to the warned about some data being lost. Save the table - correct answer click the cell under "state" click fields under the properties group, type 2 in field size Press enter Click yes click save in data sheet view of the managers table, add a new field named Notes with the Long text data type - correct answer click "Click to Add" click long text type Notes press ENTER in Datasheet view of the clients table, enter Address as the Caption property of the street field - correct answer click Address click field in the properties group, click Name & capture under Caption, type Address click ok with the managers table open in data sheet view, change the format property to DateOfHire field to medium date - correct answer click 1st cell in "DateofHire" click fields under the formatting groups, click format arrow click the medium Date view the managers table in design view - correct answer in the navigation pane, right click the managers table click the design view in table design view of clients table, change the field size property to 2 for the state field. Then, save the table and click yes when prompted - correct answer click "state" cell under general, format size: type 2 press ENTER click yes with the Managers table in data sheet view, enter a new record with M-13 as the managers ID, shin as the first name, Li as the last name, and as the email address (do not enter any punctation) - correct answer in the records group, click new type M-13 press TAB type Shin press TAB type Li press TAB type open the ClientEntry form in From view - correct answer double click "clientEntry" (in the navigation pane) in table datasheet view, delete client ID 113 SC logistics record from the clients table - correct answer click the dark grey part of the cell (to highlight the whole cell) press DELETE move to the first record in the clientEntry form - correct answer in the bottom tool bar labeled "Record" click the arrow all the way to the left with the clientEntry form open in form view, navigate to the pervious record - correct answer click the arrow left Primary Key?? - correct answer click "clientID" cell click Design click Primary key with the managers table in design view, change the hire data field to date/ time data type - correct answer click the data type cell for the hire date click Date/Time in design view of the Clients table, enter address as the new field name for the street field - correct answer click the Street type Address in design view, add a fieldname notes and long text - correct answer click the empty cell type Notes Press ENTER under data types, click the arrow select long text create a new table in design view with the following field names and data types: ManagerID, shorttext; Rating, Number. Save the table with the table with the name ManagerRatings and do not set a primary key field at this time - correct answer click Create click table design type managerID click shorten