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

what is the relationship between receipt and owner entities in computer sales and service company

Question: i) Explain the terms data warehousing and data mining. ii) Discuss the importance of the following security principles that a digital firm should amongst others, n

Describe the storage structure of indexed sequential files and their access method.  Ans:   Storage structure of Indexed Sequential files and their access: To achieve fast rand

What are the disadvantages of file-processing system?  Ans: The Disadvantages of File-Processing System a. Data redundancy and inconsistency - Data redundancy means not nece

Question: (a) Use the following business rules to produce the E-R diagram. You should clearly show all the minimum and maximum cardinality constraint on each side of the relati

System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha

Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

Define shadow paging. An alternative to log-based crash recovery method is shadow paging. This technique requires fewer disk accesses than do the log-based methods.

Define Specialisation and generalization in brief? Specialisation / generalization: Generalization or Specialization represents the is a relationship set, an necessary element