Laboratory Exercise 1.2: Creating and Using a New Database in Access 2010This laboratory will provide practice in·Creating a new Access database ·Creating tables-specifying fields and keys·Specifying relationships between tables ·Entering records ·Editing records·Creating queries·Creating simple reports·Creating simple formsFor this lab, you will create a database that keeps track of your vintage music collection and the friends who borrow music from you. 1.Open Access to the Backstage Viewby choosing the Filetab. Choose New from the Filemenu, thenBlank Databasefrom Available Templatesat the top left of the middle panel. In the File Namewindow in the right panel, enter the database name, MyMusic. (Note that if you wish to specify a different directory, you can do so by clicking on the folder icon to the right of the window and changing the destination.) Click on the Createbutton on the bottom of the right-most panel.2.You will see the Tables object chosen in the Navigation Pane, with a new table, Table1, listed. Right-click on the name and choose Design View. In the pop-up window, enter the table name, Music, then click on the OKbutton. On the first line you will see column headings Field Nameand Data Type. In these columns you will specify the names and data types of each of your table columns. The first line under the headings has the name ID and type AutoNumber already displayed. Notice that there is a key icon to the left of theIDfield, which means that Access is assuming that the IDfield is the key for the table. If you click on that icon and look at the ribbon(the horizontal band near the top of the screen) you will see the Primary Keysymbol is highlighted. On the second line, just under ID, enter the name title. Tab to the Data Typewindow on the same line, and click on the down arrow to see the available data types. Choosetext. Move down to the Field Propertieswindow in the bottom panel and type 35as the field size in the first line. Move back to the third line under Field Nameand enter the field name artist, then data type text, and enter the field size 20in the Field Propertieswindow in the bottom panel. Make the fourth field dateAcquiredand choose Date/Timeas the data type. Make the fifth field statuswith data type of text, size 10. Close the table design panel by clicking on theXbutton in the panel, making sure to choose the option of saving the changes to the design. 3.Now you will create a second table of friends who might borrow your music. Choose the Createtab. Choose New Table from the ribbon. A new table, Table1,appears in the Navigation Pane. Right click on that name, choose Design View, and enter the name Friendsin the Save Aswindow that pops up, then choose OK. For the first field delete IDand enter lastName, and make the data type text with field size20. Again you see that Access displays a key icon to indicate that this field is assumed to be the primary key. Continue to create the rest of the fieldsfirstName text, field size 15areaCode text, 3phone text, 7Save this table by clicking on the Xbutton on the top right of the panel and choose to save the changes.4.Create a third table, Borrow. This time for the first field, ID, change the data type to Number, with field size Long Integer. For the remaining fields, specifylastName text, field size20dateBorrowed Date/TimedateReturned Date/TimeThis table needs a composite key consisting of IDand lastName.To create the composite key, move the cursor to the first column to the left of IDand, holding the Ctrlbutton down, move the mouse down one line to select both the IDand the lastName lines. With both highlighted, click the Primary Keyicon in the ribbon. Save the table with its design changes.5.To create relationships between the tables, click on the Database Toolstab and the Relationshipsicon on the ribbon. It consists of three rectangles connected by lines. In the Show Tablewindow that pops up, highlight Music,click on the Addbutton, highlight Borrow, click on Add, highlight Friends,click on Add, then click on Close. The Relationshipwindow opens, showing the three tables. Click onlastNameinFriends and drag to lastNamein Borrow. In the Edit Relationshipwindow that pops up, you should see both fields listed. Check the box Enforce referential integrityand then click on the Createbutton. You will see a line connecting the two tables with 1..∞on it. The 1 should be near theFriends table and the infinity symbol near the Borrowtable. (If this is not the case, you made a mistake in designing the tables. You can click on the relationship line and press the Deletekey to remove the relationship. Then you can return to the table design and correct any error.) Repeat the process, dragging IDinMusicto IDin Borrow and create another relationship, checking on the field names and clicking on Enforce referential integrityin the pop-up window. Close the relationship window, saving changes.6.Double click on the name of the Music table. Now you will enter data into that table. For the Music table, the system will enter an ID(1,2,3..) automatically (because you allowed it to create an AutoNumber key for you), but you should enter the names of albums you might have, the singer or artist, the date you got the album (in the US, use the form mm/dd/yyyy;otherwise use the local convention for dates), and the status. You can leave the status blank or enter borrowed,OK,scratched, or any appropriate string value. You can print the table or any other object at any time by choosing the Filetab, then Print, and then choosing from the print options. When you have entered several albums, save theMusic table and close it.7.Enter data in yourFriends table. This timelastName is the key. You must be careful not to enter two records with the same last name. You can either remember the values you enter for the next step or you can print this table by choosing File, Print. 8.Now you can enter data in theBorrowtable. Access will check to see that anyIDyou enter matches an IDin theMusic table, and any lastName matches one in theFriends table, so be sure the values are valid. The checking is done because you informed Access of the relationships and asked it to enforce referential integrity. Save this table.9.Once you have created a table, you can always add new records by simply opening the table and entering the data. You can update an existing record by moving the cursor to the field to be changed and typing in the new value. You can delete a record by highlighting it and pressing the Deletekey. Practice each of these operations on any table you choose. 10.Now you will create a query that you design yourself. Choose the Create tab. Choose Query Designfrom the ribbon. In the Show Tablewindow, highlight Music,click on the Add button, highlight Borrow,click on the Add button, highlight Friends and click on the Addbutton again. Click on the Closebutton. You are now in the query design window. Observe that you can move the tables around in the top panel by clicking on their title bars and dragging them. You can also right click on any table title and remove that table or see its properties. Choose whatever fields you would like to include in your query. Remember you can choose any of the tables, choose different fields, use . =, , ,and so on, use is null to indicate missing values, write compound conditions for a field using AND, OR, or NOT, put multiple conditions for different fields on the same criteria line to indicate AND, or put conditions on different lines to indicate OR. Explore the options and create several queries. Note that if you wish to compare strings the case must match exactly, so be careful of capitalization. Decide what questions you would like to ask, and design and execute several queries, saving them under names you choose that suggest their contents. Close the query design window.11.Now you should design a report. Choose the Create tab, and the Report Wizardicon from the ribbon. Notice the drop-down window that lists all the tables and queries. You could choose any combination of these objects for your report. Choose one table. From the field list just below, highlight any field you wish to include and press the right arrow button to select it for the report (or simply double click on the field name). Remember that if you accidentally choose an incorrect field, use the back arrow to deselect it. After you have chosen the fields you wish from the tables and/or queries, click on the Next button at the bottom of the Report Wizardwindow. You have to option to view your data by various orders and grouping levels, and to choose a style for your report. Add a title that includes Created by your name .Choose Finish to end the design and run the report. Print the report by choosing File, Print, and a suboption. Close the report, which will be saved under the title you entered.12.Click on the Createtab and choose the Form Wizardicon from the ribbon. Choose the Friendstable, and click on the double arrow to select all its fields. Choose all the default specifications. The form should pop up, showing a record. Use the navigation arrows at the bottom of the form to step through the table’s records one at a time. Remember you can also enter data using the form. After the last record, you will see a blank form, on which you should enter data that you make up about a friend.13.Save all your changes and exit Access.（以上发布均为题目，为保证客户隐私，源代码绝不外泄！！）代写计算机编程类/金融/高数/论文/英文本网站支持淘宝 支付宝 微信支付 paypal等等交易。如果不放心可以用淘宝或者Upwork交易！E-mail:[email protected]微信：BadGeniuscs 工作时间：无休息工作日-早上8点到凌晨3点如果您用的手机请先保存二维码到手机里面，识别图中二维码。如果用电脑，直接掏出手机果断扫描。

所有的编程代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供C语言代写、代写C语言、C语言代做、代做C语言、数据库代写、代写数据库、数据库代做、代做数据库、Web作业代写、代写Web作业、Web作业代做、代做Web作业、Java代写、代写Java、Java代做、代做Java、Python代写、代写Python、Python代做、代做Python、C/C++代写、代写C/C++、C/C++代做、代做C/C++、数据结构代写、代写数据结构、数据结构代做、代做数据结构等留学生编程作业代写服务。