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 DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in

Draw an entity relationship diagram (ERD) for the following situation: A company has a number of employees. Each employee is identified by an Employee_Id. The company wants to st

Benefits and Limitations od Data Models?

You are required to write a report which evaluates two of the following issues in relation to your case study database: a. Security issues b. Performance issues c. Backup

Explain how you can define an object model of a system. A list of terms that shall be used by end users to describe state and behaviour of objects in system.   Different use

#quesDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pi

What are domain constraints? A domain is a set of values that might be assigned to an attribute .all values that appear in a column of a relation must be taken from the similar

Benefits of using heuristics

Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati