Question

Document1 - Word Please do all steps and make screen shots for each step. Book: Relational Databases and Microsoft Access V4.0These exercises refer to the Library database. 2. Consider the Member table. The id field was defined with the AutoNumber datatype. Experiment by adding new members and you will note that id values increase by 1 . Now try deleting the last two members that you added. If you add those members back in, what id values do they get? Are id values reused?please click on create submission then write the answeare only in the text box, you dont need to save the experiments. 3. Consider the Member table. Previously you added a gender field. Open the Member table in design view and change the datatype for gender to be Lookup Wizard. The wizard will automatically present 3 successive popup windows where you will: i) specify that you are providing the lookup values; ii) enter the values (Male and Female); iii) specify that values are to be limited to your list. Save the table and enter datasheet view so you can test out the datatype you have just Ireated. You will notice the user sees a drop-down list containing Male and Female, and so the user cannot enter/select an inappropriate value.

          Document1 - Word
Please do all steps and make screen shots for each step. Book: Relational Databases and Microsoft Access V4.0These exercises refer to the Library database.
2. Consider the Member table. The id field was defined with the AutoNumber datatype.
Experiment by adding new members and you will note that id values increase by 1 . Now try deleting the last two members that you added. If you add those members back in, what id values do they get? Are id values reused?please click on create submission then write the answeare only in the text box, you dont need to save the experiments.
3. Consider the Member table. Previously you added a gender field. Open the Member table in design view and change the datatype for gender to be Lookup Wizard. The wizard will automatically present 3 successive popup windows where you will:
i) specify that you are providing the lookup values;
ii) enter the values (Male and Female);
iii) specify that values are to be limited to your list.
Save the table and enter datasheet view so you can test out the datatype you have just Ireated. You will notice the user sees a drop-down list containing Male and Female, and so the user cannot enter/select an inappropriate value.

Added by Anita B.

Question

Please give Ace some feedback