Save the changes to the table design and close the Agents table.7Open the Properties table in Design View. Save the table as Agents.4Switch to Datasheet view and add the following records letting Access assign the AgentID number: FirstName LastName Title Guillaume Picard BrokerKeith Martin AgentUsa-chan Yang AgentSteven Dougherty Agent in TrainingRajesh Khanna Agent in TrainingJuan Rosario President5Sort the Agents table by the LastName field in ascending order.6Apply a selection filter so that everyone with a title other than Agent in Training displays. Accept Short Text as the data type for all fields. Change the Data Type for AgentID to AutoNumber and set AgentID as the Primary key for the table.3Add the following field names to the table: FirstName, LastName, and Title (in that order). Open the downloaded Access file named exploring_a01_grader_h2.2Create a new table in Design view.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |