Create a database, Database Management System

Project: Microsoft Access

You have been asked by the ABC Tanning Salon to create a database that can be used to track the salon's customers.  You are to create a table in Access based on the following specifications.

a) Create a new blank database with the filename "youraccountname_salon.accdb".

b) Create  a new table called "Customers" with the following fields:

1004_Create a database.png

c) CustomerID is to be the primary key.  It should be an AutoNumber data type and the Format should be XX0000, where XX are your initials and each time a record is added to the table the primary key will automatically produce a CustomerID number that begins with your initials followed by a four digit number. 

d) Set the Required property to Yes for the Lastname, Firstname, PhoneNumber, DateJoined, Membertype and AccountBalance.

e) Use a Validation Rule for Gender to allow only "M" or "F" and place an appropriate message as Validation Text to explain that these are the only two values allowed.

f) Set an Input Mask for the Customer's PhoneNumber in the form (123)456-9999.

g) Set an Input Mask for the Customer's PostalCode in the form A1B 2C3.

h) Use the Format property so that the province is always displayed in uppercase.

i) MemberType should be specified using the Lookup Wizard including "Regular", "Student" and "Senior" as the membership types to be listed.

j) For AccountBalance set a currency format with 2 decimal places.

k) Set appropriate field sizes for all fields as shown above.

l) Enter one record into the completed table, using your name as the customer and appropriate values for all of the fields.

Posted Date: 2/21/2013 3:19:35 AM | Location : United States







Related Discussions:- Create a database, Assignment Help, Ask Question on Create a database, Get Answer, Expert's Help, Create a database Discussions

Write discussion on Create a database
Your posts are moderated
Related Questions
The following data are required to be stored by a family physician. Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate A family can have seve

Design Documentation  The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip

Durability : This property necessitates that once a transaction has committed, the changes made by it be never lost because of subsequent failure. Thus, a transaction is also a bas

What is Gathering information and Producing ERD Gathering information: This could be a written document that explains the system in question with reasonable quantity of detai

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp

how oracle can be used

What are the categories of SQL command? SQL commands are separated in to the following categories: 1. Data - Definitition Language 2. Data Manipulation language 3. Dat

Describe Application programming interface? Application Programming Interface - Commercial SQL implementations take one of the two primary techniques for involving SQL in a p

Design an EER schema for the following application and translate the EER schema into relational schemas (and constraints). It is possible that some requirements cannot be captured