Lab Instructions

Published: 2021-09-13 06:35:06
essay essay

Category: Miscellaneous

Type of paper: Essay

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Hey! We can write a custom essay for you.

All possible types of assignments. Written by academics

GET MY ESSAY
Assignment:
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 Folder
Create 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:
a. Double-click the My Files shortcut on the desktop. The My Files (U:) window will open as shown in My Files (U:).
b. Double-click the IT261 folder. The IT261 window will display as shown in IT261.
c. 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.
d. 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.
Create a Database named CEUEmployeeData
Use 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:
a. 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.
b. 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.
c. 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.
d. 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 Fields
Create the Employeedata table and add fields and data types to the table as given in the table below:
Field Name Data Type
EmployeeCode (PK) Number

Warning! This essay is not original. Get 100% unique essay within 45 seconds!

GET UNIQUE ESSAY

We can write your paper just for 11.99$

i want to copy...

This essay has been submitted by a student and contain not unique content

People also read