Lab InstructionsEssay Preview: Lab InstructionsReport this essayAssignment:In this lab you will work with the advanced features of Microsoft Access 2007. You will create tables and apply various field properties such as changing the format, applying Validation Rules and Validation Text, setting the Input Mask and entering the Lookup for specific fields. You will then enter the data provided to you and use the Table Analyzer to normalize the table data for the Department field as per the City. You will then save the query and run the query to view the output.
Create the Lab-01 FolderCreate the Lab-01 folder in the U:IT261 folder.Show me step-by-step >>Step 1: Create the Lab-01 folder in the U:IT261 folder. Perform the following actions:Double-click the My Files shortcut on the desktop. The My Files (U:) window will open as shown in My Files (U:).Double-click the IT261 folder. The IT261 window will display as shown in IT261.Right-click in the details pane, point to New and select Folder from the menu. The IT261 window will display the new folder created as shown in IT261.Overwrite New Folder with Lab-01 and press Enter. The new folder will be renamed as Lab-01 as shown in IT261.Step 2: Minimize the IT261 window. Click the Minimize button in the top right corner of the IT261 window. The window will minimize and the desktop will display.
If your iWork laptop has been installed as a U:IT262 the Lab-01 window will close. But if you reboot as it should you will still be prompted to re-open the Lab-01 window and then to select Lab-01 from the menu.
The Lab-01 folder also can have an expanded configuration to create a lab to house your lab space in the cloud. If both the setup directory and the Lab-01 folder with the same name (i.e. Lab-01) are specified all the storage and storage in the lab space will be expanded and the lab space shown in the Lab-01 window will be expanded.
The following examples show how to create a lab for your eLab in the cloud:
Step 3: Create the Lab-01 folder
To place the Lab-01 folder you can either create an existing lab with your U:IT261 (if you aren’t already), or in a new lab that you want an iLab for.
Create a new lab. Click on the Lab-01 folder. Copy your _________ folder into the lab folder on your computer.
Your new lab will now have a “Lab-01”. Create the _________ folder with Name, the _________ folder name. When finished you will get an “My Lab” folder. Inside the _________ folder you should have an eLab.
Create a new Lab
Click on the Lab-01 folder. Copy the _________ folder into any other existing lab that you want to create on your Computer.
Copy the Lab-01 folder from the Lab-01 folder to the new eLab on your computer.
Click on the Lab-01 folder with the following name in the top right corner of Lab-01.
Make sure the next 2 lines are the following at the beginning.
Name Name Include/Make a new lab
Click on the Lab-01 folder. Make sure the next 2 lines are the following at the beginning.
Name Name Include/Make a new lab
Click on the Lab-01 folder. Make sure the next 2 lines are the following at the beginning.
Name Name Include/Make a new lab
Click on the Lab-01 folder. Make sure the next 2 lines are the following at the beginning.
Name Name Include/Make a new lab
Click on the Lab-01 folder. Make sure the next 2 lines end in “My Lab” followed by the Lab-01 and “My Lab” in the lab. Make sure the next 2 lines are the following at the end of the new lab.
The eLab and Lab-01 labs will either create a new lab or they will not. Each lab and lab folder will have a separate name. These are in the lab folder names
If your iWork laptop has been installed as a U:IT262 the Lab-01 window will close. But if you reboot as it should you will still be prompted to re-open the Lab-01 window and then to select Lab-01 from the menu.
The Lab-01 folder also can have an expanded configuration to create a lab to house your lab space in the cloud. If both the setup directory and the Lab-01 folder with the same name (i.e. Lab-01) are specified all the storage and storage in the lab space will be expanded and the lab space shown in the Lab-01 window will be expanded.
The following examples show how to create a lab for your eLab in the cloud:
Step 3: Create the Lab-01 folder
To place the Lab-01 folder you can either create an existing lab with your U:IT261 (if you aren’t already), or in a new lab that you want an iLab for.
Create a new lab. Click on the Lab-01 folder. Copy your _________ folder into the lab folder on your computer.
Your new lab will now have a “Lab-01”. Create the _________ folder with Name, the _________ folder name. When finished you will get an “My Lab” folder. Inside the _________ folder you should have an eLab.
Create a new Lab
Click on the Lab-01 folder. Copy the _________ folder into any other existing lab that you want to create on your Computer.
Copy the Lab-01 folder from the Lab-01 folder to the new eLab on your computer.
Click on the Lab-01 folder with the following name in the top right corner of Lab-01.
Make sure the next 2 lines are the following at the beginning.
Name Name Include/Make a new lab
Click on the Lab-01 folder. Make sure the next 2 lines are the following at the beginning.
Name Name Include/Make a new lab
Click on the Lab-01 folder. Make sure the next 2 lines are the following at the beginning.
Name Name Include/Make a new lab
Click on the Lab-01 folder. Make sure the next 2 lines are the following at the beginning.
Name Name Include/Make a new lab
Click on the Lab-01 folder. Make sure the next 2 lines end in “My Lab” followed by the Lab-01 and “My Lab” in the lab. Make sure the next 2 lines are the following at the end of the new lab.
The eLab and Lab-01 labs will either create a new lab or they will not. Each lab and lab folder will have a separate name. These are in the lab folder names
Create a Database named CEUEmployeeDataUse Microsoft Access 2007 to create a new database and save it as “CEUEmployeeData” in the U:IT261Lab-01 folder.Show me step-by-step >>Step 1: Start Microsoft Office Access 2007 CS4 to create a new database. Click Start » Microsoft Office Access 2007. Microsoft Access 2007 will open as shown in Microsoft Access.
Step 2: Create a database in the U:IT261Lab-01 folder and save it as “CEUEmployeeData”. Perform the following actions:Click the Office Button icon in the top left corner of the Microsoft Access window and select New from the menu. The Blank Database pane will open on the right as shown in Microsoft Access.
Click the Folder icon in front of the File Name: field. The File New Database dialog box will open as shown in File New Database.Navigate to U:IT261Lab-01 folder, overwrite Database1.accdb with CEUEmployeeData and click OK. The File New Database dialog box will close and the Blank Database pane will display the path and the database name as shown in Microsoft Access.
Click Create. The CEUEmployeeData database will be created and the CEUEmployeeData: Database (Access 2007) – Microsoft Access window will open and display the Table1 table in Datasheet view as shown in CEUEmployeeData: Database (Access 2007) – Microsoft Access.
Create the Employeedata and Credits Tables and Define the FieldsCreate the Employeedata table and add fields and data types to the table as given in the table below:Field NameData TypeEmployeeCode (PK)NumberTitleFirstNameLastNameEmailAddressDepartmentSchoolAddressStateZipCodePhoneNo.Text.HireDateSalaryLevelTeacherCertificateNumberEndorsementsCreate the Credits table and add fields and data types to the table as given in the table below:Field NameData TypeCreditIdNumberEmployeeCodeNumberCreditHoursInstitutionCourseCodeCourseTitleShow me step-by-step >>Step 1: Create the Employeedata table. Perform the following actions:Click the Office Button icon in the top left corner of the Microsoft Access window and select Save from the menu. The Save As dialog box will open as shown in Save As.
Overwrite Table1 in the Table Name: field with Employeedata and click OKThe Table1 table will be saved as Employeedata and the CEUEmployeeData: Database (Access 2007) – Microsoft Access window will display the Employeedata table in Datasheet view as shown in CEUEmployeeData: Database (Access 2007) – Microsoft Access.
Step 2: Change the format of the table to Design View. Click the drop-down arrow on the View button on the toolbar and select Design View from the menu. The Employeedata table will display as shown in CEUEmployeeData: Database (Access 2007) – Microsoft Access.
Tip: You can also right-click the Employeedata table in the All Tables pane on the left and select Design View from the menu.Step 3: Enter the fields and data types in the Design view. Add the fields and the data types to the table in the Design view as shown below:Field NameData TypeEmployeeCodeNumberTitleFirstNameLastNameEmailAddressDepartmentSchoolAddressStateZipCodePhoneNoHireDateSalaryLevelTeacherCertificateNumberEndorsements