CITY UNIVERSITY / Vysoká Škola Manažmentu

.:CS 416 - Database Management:.
 
Syllabus
 Assignments Schedule Theory Practice Grades
           
PRACTICE (MS Access)
   
.:Access 1

1. Start Microsoft Access, choose Blank Database.
2. Save as the bsba/cs416/your section/your last name
3. A window with 7 tabs (options) appears. 1st choice is Tables – most basic part of this DBMS (using tables you can create forms, queries, etc.)
.:Access 2 > > >
 

1. Modify the look of the forms (start with the customer). Open the form in design view. First, make the form wider, then adjust size and move individual fields. Then create a header and a footer – simply drag down the h&f bars.

.:Access 3 > > >
 

1. Click the form tab – New – Design View.
2. Click the command button – simple, gray button on the toolbox bar, draw a rectangle on the form, choose form operations, open form – next.
3. Choose form customers, next, open form and show records, next, choose text option – in the text field type Customers, click next, finish.
.:Access 4 > > >
 

1. Create a new db and name it EXERCISE.
2. Use table wizard (table – new – wizard) select business – customers. To the selected items field move: customer ID, ComopanyName, ContactFirstName, BillingAddress, StateOrProvince, PostalCode, ContactTitle, PhoneNumber, FaxNumber, LastMeetingDate, then choose the business – contacts style - last meeting date.
.:Access 5 > > >
 
1. Add lookup field for department number in the Employees table. In the design view, select the deptID field and from the data type menu choose lookup wizard. Once the dialog window appears, choose option I will type values I want, next, No of columns – 1 and in the column cells type IS01, IS02, MG01, MG02, MKT01, HR01, Next, Finish. [Note that the wizard changed lookup properties of this field: Display Control = Combo box, Row Source Type= Value List, Row Source = "IS01";"IS02";"MKT01"…]
.:Access 6 > > >
 

1. Create an update query to double the price of all products – new query, select Product Type table, OK. Right-click the neutral - gray) query area, select query type – update query (this will add the “update to” row). Select the Price field and in the update to field built event that will double the price in the Product Type table’s price field. (r.c. – build – select table, field, *2). Name the query price_up.
UPDATE [Product Type] SET [Product Type].Price = [Product Type]![Price]*2;