Www.abss.k12.nc.us
Competency AssessmentProject 1-1: Personalizing AccessWhen working in Access or another Microsoft Office application, it is useful to personalize your copy of the software. Personalizing your software helps credit you as the creator of the Access database or other Office application.GET READY. LAUNCH Access if it is not already running.1. Click the File tab.2. Click the Options button to display the Access Options dialog box.Throughout this lesson you will see information that appears in black text within brackets, such as [Press Enter], or [your e-mail address]. The information contained in the brackets is intended to be directions for you rather than something you actually type word-for-word. It will instruct you to perform an action or substitute text. Do not type the actual text that appears within brackets.3. In the Personalize your copy of Microsoft Office section of the dialog box, key [your name] in the User name box and key [your initials] in the Initials box.4. Click OK to close the dialog box.LEAVE Access open for the next project.Project 1-2: Using the Navigation PaneAs a busy editor at Lucerne Publishing, you use Access to organize and manage your task list.GET READY. LAUNCH Access if it is not already running.1. OPEN task_list from the data files for this lesson.2. Click the Shutter Bar Open/Close Button to display the Navigation Pane.3. Click the Contacts group header in the Navigation Pane to display those database objects.4. Click the Supporting Objects group header to display those database objects.5. In the Supporting Objects group, double-click Tasks to open that table.6. In the Tasks group, double-click Tasks By Assigned To to open that report.7. In the Navigation Pane, click the Tasks Navigation header to display the menu and then click Object Type.8. CLOSE the database.LEAVE Access open for the next project.Proficiency AssessmentsProject 1-3: Understanding Database DesignYou work at Margie’s Travel, a full-service travel agency that specializes in providing services to senior citizens. You plan to create a database of tours, cruises, adventure activities, group travel, and vacation packages geared toward seniors, but fi rst you want to learn more about database design.GET READY. LAUNCH Access if it is not already running.1. Open Access Help.2. Search for database design.3. Read the article about database design basics.4. OPEN a new Word document.5. List the steps that should be taken when designing a database with a short description of each.6. SAVE the document as database_design and then CLOSE the file.LEAVE Access open for the next project.Project 1-4: Planning Table FieldsYou are a volunteer for the Tech Terrace Neighborhood Association that holds an annual March Madness 5K Run. In the past, all data has been kept on paper, but you decide it would be more efficient to create a database. Decide what fields would make sense for a table holding data about the runners.GET READY. LAUNCH Access if it is not already running.1. Think about what fields would be useful in a database table that contains information about the runners in an annual 5K road race.2. OPEN a new Word document.3. In the document, key a list of the names of at least six possible fi eld names.4. SAVE the document as race_fi elds and keep the file open.LEAVE Access open for the next project.Mastery AssessmentMastery AssessmentsProject 1-5: Planning Data Types for FieldsNow that you have decided what fields to use in a database table containing information about runners in an annual 5K road race, you need to determine what data type should be used for each field.USE the document you used in the previous project.1. Beneath the name of each possible field name for the table about runners in the annual 5K road race, key the data type that would be used with a short explanation of why you chose that type.2. SAVE the document as data_type and then CLOSE the file.LEAVE Access open for the next project.Project 1-6: What’s New in Microsoft Access 2010Your supervisor at Margie’s Travel has suggested that you research what’s new in Access 2010 before you begin to create a database.GET READY. LAUNCH Access if it is not already running.1. Open the Backstage view and access the Help menu.2. Use Access Help to locate the article “What’s New in Microsoft Access.”3. Read the overview.CLOSE Access. ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.