Data Base Notes: DB1—DB10

You have the basic knowledge obtained from the all lectures, all notes, text, all overhead

presentations, all board work presentations, and any hints. . .You must take the given information (data) for

each database project, and add, delete, and correct, if necessary, any data, fields, records, or structure.

DB1

Please create a data base named db1.




 
 
 
Create "table 1" table with the following fields:

lastname,

firstname,

salary.

Please set a primary key for lastname in table 1.

Create a simple form and a simple report.

Please create a simple query.

Enter 20 different records.

DB1a

Please create a data base named db1a.




 
 
 
Create "table 1" table with the following fields:

lastname,

firstname,

salary,

phone.

Please do not set a primary key in table 1.

Please create an Input mask for the phone field.

Create a simple form and a simple report.

Please create a simple query using a primary sort key

for the lastname field and a secondary sort key

for the firstname field.

Enter 10 records. Make some duplicate lastname records.

DB2

Please create a data base named db2.




 
 
 
Create "table 1" table with the following fields:

lastname,

firstname,

begsalary,

phone.

Create "table 2" table with the following fields:

lastname,

endsalary.

Please set a primary key for lastname in table 1.

Please create an input mask for the phone field.

Please create a relationship between the two tables.

Create a simple form and a simple report.

Please create a simple query with a calculation of

the difference between the endsalary and begsalary
.

Enter 10 records.

DB3

Please create a data base named db3.




 
 
 
Create a "table 1" table with the following fields:

lastname,

firstname,

salary,

photograph, (OLE type)

department.

Please embed/insert (OLE) a photograph file in one of the records.

Please set a primary key for lastname in table 1.

Create a simple form and a simple report.

View the photograph in the form's datasheet view.

Please create a data access page, and name it "page1.htm."

Please create a simple query.

Please create a duplicate lastname field.

Restrict lastname as a required field.

Enter 10 records.

DB3a

Please create a data base named db3a.




 
 
 
Create a "table 1" table with the following fields:

lastname,

firstname,

salary.

Please set a primary key for lastname in table 1.

Create a simple form and a simple report.

Please create a data access page, and name it "page1.htm."

Enter 10 records.

DB4

Please create a data base named db4.




 
 
 
Create "table 1" table with the following fields:

lastname,

firstname,

salary,

phone,

photograph, (OLE type)

department.

Create "table 2" table with the following fields:

lastname,

phone,

SSN.

Please correct any mistakes in any fields.

Please set a primary key for lastname in table 1.

Please create an input mask for the phone/SSN fields.

Please create a relationship between the two tables.

Create a simple form/subform and a simple report.

Please create a simple query.

Please insert a picture file into a record (OLE).

View the picture in the appropriate form record.

Please insert an image in the header of the form.

Please insert a title (The International Company)

in the header of the form. Enter 10 records.

DB4a

Please create a data base named db4a.




 
 
 
Create a "table 1" table with the following fields:

lastname,

firstname,

salary,

department.

Please set a primary key for lastname in table 1.

Create a simple form and a simple report.

Please set the property "Required" to yes for each field.

Please select salary for the validation properties.

Please set the property for a "Validation Rule" (Use >1000).

Please set the property for a "Validation Text."

Use the text "Salary must be greater than a 1000."

Please create a Combo Box (for department).

Please create an image (use employee.bmp).

Create a label (The International Company) for the form.

Use the toolbox for the combo box, image, and label.

Please create a data access page, and name it "page1.htm."

Enter 10 records.

Practice QUIZ

Please create a data base named Practice.




 
 
 
Create "pers 1" table with the following fields:

lastname,

firstname,

salary,

phone,

ssn

photograph, (OLE type)

department.

Create "pers 2" table with the following fields:

lastname,

ssn.

THESE REQUESTS DO NOT HAVE ANY SIGNIFICANT ORDER.

Correct any mistakes in the previous fields.

Please set a primary key for lastname in pers 1.

Please create an input mask for the phone/SSN fields.

Please create a relationship between the two tables.

Create a simple form/subform and a simple report.

Please create a simple query

using the LIKE and GREATER THAN commands.

Please insert a picture file into a record.

View the picture in the appropriate form record.

Please insert an image in the header of the form.

Insert a title (The International Company)

in the header of the form.

Enter 5 records in the table using the datasheet view.

DB5

Please create a data base named db5.




 
 
 
Create "table 1" table with the following fields:

orderNum,

customerNum,

paid,

invoiceAmt,

billingDate.

Create "table 2" table with the following fields:

customerNum,

customerName,

street,

city,

state,

zipcode,

OwnerName,

phone.

Please set a primary key for table 1.

Please create an input mask for the necessary fields.

Please create a relationship between the two tables.

Create a simple form/subform and a simple report.

Please insert a picture file into a record.

Please create a combo box or a list box in the form object.

Create a logo in the form, and any calculation in the query object.

Create the sum, maximum, minimum, count, and average functions.

Use the form object (footer section).

Enter 10 records.

DB6

Please create a data base named db6.




 
 
 
Make any necessary corrections.
 
Create "table 1" table with the following fields:

lastname,

firstname,

begsalary,

photograph (OLE type),

department,

phone.

Create "table 2" table with the following fields:

lastname,

endsalary.

Please set a primary key for lastname in table 1.

Please create an input mask for the phone field.

Please create a relationship between the two tables.

Create a simple form/subform and a simple report.

Please insert a picture file into a record.

Please create a combo box and a list box in the form object.

Create a logo and calculation in the form object.

Please create a simple query with a calculation of

the difference between the endsalary and begsalary.
.

Create the sum, maximum, minimum, count, average, and

standard deviation functions in an object form

(footer section).

Enter 10 records.

Practice For Final Exam

Look-Up--Final Exam

Please create a data base named look.




 
 
 
Create "Shipping Terms" table with the following fields:

shipping terms.

Enter record1 Net 10th, record2 COD,

record3 Cash Only, record4 1% in 10 Days.

Create "Product Sales" table with the following fields:

product description, Product Price, shipping terms.

Enter 10 records, but do no enter the shipping terms field.

Please do not set a primary key.

Please do not create a relationship between the two tables.

Go to the "Product Sales" table design view.

Please select the row for "shipping terms."

Click the Look Up tab in the field's properties pane.

Click the Display Control box.

Click the down arrow at the end of the Display Control box,

and choose List Box.

Click the Row Source Box.

Click the down arrow at the end of the Row Source box,

and choose shipping terms.

Click the save icon in the toolbar.

Go to the datasheet view of the Product Sales' table.

Add another record.

In the shipping terms column, click the down arrow and

choose a shipping term.

Another Look-Up

Please construct or create a Look-up database for six different states (US),
and include in the database the following fields: lastname, firstname, address, city,
state, and the zipcode.

Create a database with a required value,
and a validation rule/text.

DB7

Please create a data base named db7.




 
 
 
Create "customers" table with the following fields:

Customer ID,

First Name,

Last Name,

Address,

City,

State,

Zip,

Phone,

photograph, (OLE type)

department.

Create "products" table with the following fields:

Product ID,

Product Brand,

Product Description,

Price.

Create "transaction" table with the following fields:

Transaction ID,

Date,

Customer #,

Product #,

Employee ID.

Create "employees" table with the following fields:

Emp ID,

First Name,

Last Name,

SSN.

Please correct any mistakes in any of the fields.

Please set the primary keys for the tables.

Please create an input mask for the phone/SSN fields.

Please create the relationships among the tables.

Create a simple form/sub form and a simple report.

Please create a simple query.

Please insert a picture file into a record (OLE).

View the picture in the appropriate form record.

Please insert an image in the header of the form.

Please insert a title (The International Company)

within the header of the form. Enter 10 records.

DB8

Please create a data base named db8 with six tables.




 
 
 
Create a "Customers" table with the following fields:

CustomerID,

Contact,

FirstName,

LastName,

Address1,

Address2,

City,

State,

Zip,

Phone,

Fax,

ShipAddress,

ShipCity,

ShipState,

ShipZip,

Terms,

TaxIDNum,

Notes,

photograph, (OLE type).

Create a "States" table with the following fields:

ST,

State.

Create an "OrderDetails" table with the following fields:

OrderID

ProductID,

Quantity.

Create an "Orders" table with the following fields:

OrderID,

OrderDate,

EmpID,

CustomerID.

Create an "Employees" table with the following fields:

EmpID,

LastName,

FirstName,

Address,

City,

State,

Zip,

Education,

HireDate,

BaseSalary,

SSN,

Phone,

Email.

Create a "Products" table with the following fields:

ProductID,

ProductName,

Description,

Price.

Please correct any mistakes in any of the fields.

Please set the primary keys for the tables.

Please create an input mask for the phone/SSN fields.

Please create the relationships among the tables.

Create a simple form/sub form and a simple report.

Please create a simple query.

Please insert a picture file into a record (OLE).

View the picture in the appropriate form record.

Please insert an image in the header of the form.

Please insert a title (The International Company)

within the header of the form. Enter 10 records.

DB9

Please create a data base named relate1 with six tables.




 
 
 
Create a "Customers" table with the following fields:

Customer ID,

First Name,

Last Name,

Address,

City,

State,

Zip,

Phone,

Terms,

TaxIDNum,

Notes.

Create a "Payroll" table with the following fields:

Employee ID,

Salary.

Create an "Orders" table with the following fields:

Order Date

Customer ID,

Product ID,

Product Description,

Employee ID.

Create an "Products" table with the following fields:

Product ID,

Product Brand,

Product Description,

Price.

Create an "Employee" table with the following fields:

Employee ID,

Last Name,

First Name,

Address,

City,

State,

Zip,

Education,

HireDate,

BaseSalary,

SSN,

Phone.

Create a "Transaction" table with the following fields:

Transaction ID,

Date,

Customer ID,

Product ID,

Employee ID.

Please correct any mistakes in any of the fields.

Please set the primary keys for the tables.

Please create an input mask for the phone/SSN fields.

Please create the relationships among the tables.

Create a simple form and a simple report.

Please create a simple query.

Please insert an image in the header of the form.

Please insert a title (The International Company)

within the header of the form. Enter 10 records.

DB10

Please create a data base named db10.




 
 
 
Create "customers" table with the following fields:

Customer ID,

First Name,

Last Name,

Address,

City,

State,

Zip,

Phone.

Please correct any mistakes in any of the fields.

Please set the primary keys for the table.

Please create an input mask for the phone.

Please create a simple query and report.

Please insert an image in the header of a form.

Please insert a title in the header of this form.

Do an export of query results to Word.

Merge an Access table with a Word document.

Publish a table from Access to Word.

Publish a table from Access to Excel.

Import Excel to the Access table.

Link an Excel document to the Access Document.

Create a Data Access Page (DAP).

Enter at least 10 records in the above table.

Test Homework

ALL RIGHTS RESERVED
© Glenn Knapp, 2004