Module 1 Getting Started with Access - Visual Workshop

Open the IL_AC_1-4.accdb database from the location where you store your Data Files and save it as IL_AC_1_CollegeCourses, then enable content if prompted. Use the Simple Query Wizard to create the query shown in FIGURE 1-23 that contains the ClassNo, Description, and Credits fields from the Classes table, and the SectionNo, MeetingDay, and Time fields from the Sections table. Name the query DepartmentOfferings.

Comments

Post a Comment

Popular posts from this blog

Module 1 Creating Documents with Word - Independent Challenge 1

download You work at the Riverwalk Medical Clinic, a large outpatient medical facility staffed by family physicians, specialists, nurses, and other allied health professionals. Your boss has drafted an information sheet to help seasonal allergy sufferers and asks you to edit and format it so that it is eye catching and attractive.  a. Open the file IL_WD_1-5.docx from the drive and folder where you store your Data Files, save it as IL_WD_1_AllergyInfo, then read the document to get a feel for the content. FIGURE 1-32 shows how you will format the info sheet. FIGURE 1-32 Riverwalk Medical Clinic Advice for Seasonal Allergy Sufferers b. Show the rulers in your document window if they are not already visible. c. Accept or ignore all suggested spelling and grammar changes in the document. d. Insert the Riverwalk Medical Clinic logo file Support_IL_WD_1-6.jpg at the top of the document. Change the height of the logo to 1", then position the logo in the bottom right with...
Read more

Module 1 Getting Started with Access - Independent Challenge 2

download You are working for a city to coordinate a series of community-wide preparedness activities. You have started a database to track the activities and volunteers who are attending them. a. Start Access, then open the IL_AC_1-3.accdb database from the location where you store your Data Files. Save it with the name IL_AC_1_Volunteers and then enable content if prompted. b. Open each table’s datasheet to study the number of fields and records per table. c. In a Word document named IL_AC_1_VolunteerTables, re-create the following table and fill in the blanks: d. Close all open tables, then use the Simple Query Wizard to create a query using the following fields in the following order: FirstName and LastName from the Volunteers table, and ActivityName, ActvityDate, and ActivityHours from the Activities table. Show detail records, name the query VolunteerActivity, then open it in Datasheet View. e. In the ActivityName field, change any occurrence of Shelter Fundamentals ...
Read more

Module 1 Creating Documents with Word - Independent Challenge 2

download Yesterday you interviewed for a job as the administrative assistant in the Business Department at Jericho College. You spoke with several people at the college, including Sonia Alvarado, director of human resources, whose business card is shown in FIGURE 1-33. You need to write a follow-up letter to Ms. Alvarado, thanking her for the interview and expressing your interest in the college and the position. She also asked you to send her some samples of your work as evidence of your Word skills. a. Start Word and save a new blank document as IL_WD_1_AlvaradoLetter to the location where you store your Data Files. b. Begin the letter by clicking the No Spacing button in the Styles group. You use this button to apply the No Spacing style to the document so that your document does not include extra space between paragraphs. c. Type a personal letterhead for the letter that includes your name, address, telephone number, email address, and webpage or LinkedIn address, if ...
Read more