Create a database, Database Management System

Assignment Help:

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.


Related Discussions:- Create a database

What is database files , The database files accept the actual data and ...

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

System Analysis and design, Using the questions found at the end of Chapter...

Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

Mention the various user privileges, Mention the various user privileges ...

Mention the various user privileges All privileges directly granted to the user or role. All privileges granted to roles that have been granted to the user or role.

Candidate keys, Super keys of a relation can have extra attributes. Candida...

Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as extraneous if even

Derived horizontal fragmentation, Derived horizontal fragmentation: Some ap...

Derived horizontal fragmentation: Some applications may include a join of two or more relations. If the relations are stored at dissimilar locations, there may be a major overhead

What are the various properties of relational tables, What are the various ...

What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

What is data mining?, Question 1 Define OLTP? Explain the Differences betw...

Question 1 Define OLTP? Explain the Differences between OLTP and Data Warehouse Question 2 What is Architecture? Explain various components involved in it Question

Describe the statement in sql which allows to change, Describe the statemen...

Describe the statement in SQL which allows to change the definition of a table? In SQL Alter statement is used to allow the changes the definition of a table.

Relational database management, For this application, we will consider IBM ...

For this application, we will consider IBM DB2 catalog data (i.e., metadata) for IBM's enterprise-class servers running the z/OS (formerly OS/390 or MVS) operating system.  One of

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd