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
Consider entity type Employee with attributes empNumber (this is unique), empName, and the year when he/she was hired. An employee can either be a technical employee, a marketing e

Explain entity integrity and referential integrity rules within relational model. Show how these are realized in SQL? Entity Integrity Rule - No primary key value could be nu

Why were functional methods fashionable in early days? These are inspired directly by computer architecture and thus popular among computer scientist in early days. The divisio

What is Trigger? Trigger: A database trigger is procedural code which is automatically executed in response to specific events on a particular table in a database. Triggers can

Define access time. Access time is the time from when a read or write request is issued to when data transfer starts.


The Third Normal Form (3NF) Even though, transforming a relation that is not in 2NF into a number of relations that are in 2NF take out many of the anomalies, it does not neces

What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on

An object-oriented design process  1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in

Define the Immediate Update The immediate update methods may apply changes to the database on disk before the transaction arrives a successful conclusion. Though, these change