Create a database in access, Basic Computer Science

Assignment Help:

The following are required:

  1. Create a project in Access.  Your database must have flow and a theme.
  2. The database must be normalized. 
  3. The content must be relevant to the database fields.  As an extreme example, this means do not put address in a name field
  4. Your tables and objects must be properly named.  For example, do not use spaces in naming objects.  Also be consistent with table names and object names
  5. Your project must include at least three tables
  6. Your tables must make use of  data validation rules
  7. Make use of data validation text
  8. Each table must have a primary key or an appropriate combination key
  9. At least one foreign key is required but additional ones must be used if the database merits their use
  10. Your project must make use of at least one input mask
  11. Your project must include proper and working relationships between tables.  Be sure the relationships are valid and referential integrity is observed
  12. Your project must include at least three queries
  13. Your project must include at least two "customized", working forms.  At least two; if you need more, you must create them.
  14. Your project must not make use of direct entry into tables and strictly use forms for data input
  15. Relevant pictures to the project appropriately placed on forms
  16. Your forms must include a form header or form footer
  17. Your project must include at least one report based on a table and at least one report based on a query
  18. Spelling counts
  19. Grammar counts
  20. Your project must include your name

Related Discussions:- Create a database in access

Cprgm, A palindrome is a string that reads the same from both the ends. Giv...

A palindrome is a string that reads the same from both the ends. Given a string S convert it to a palindrome by doing character replacement. Your task is to convert S to palindrome

Process control management, Process Control Management:   A  process  ...

Process Control Management:   A  process  is an executing program. It is considered the standard unit of work within a computer system. Every executing program is treated as a

Binary, Ask quwhat is binary estion #Minimum 100 words accepted#

Ask quwhat is binary estion #Minimum 100 words accepted#

Two-tiered architecture, Two-tiered architecture: This approach basic...

Two-tiered architecture: This approach basically introduced a database server to replace the file server. The emergence of relational database management systems and graphica

HOMEWORK 9.., AsBased on Chapter Review Problems from the book. 1 #1. Wh...

AsBased on Chapter Review Problems from the book. 1 #1. What is meant by data independence? Explain your answer. #2. Identify two benefits of separating application software fr

Computer Networking and configuaration, Ask queYou are hired as a Chief Tec...

Ask queYou are hired as a Chief Technology Officer (CTO) of a startup company, which has two branches; one Los Angeles and one in San Francisco. The company hired employees to begi

Types of operating systems, Operating Systems:  An operating system is a se...

Operating Systems:  An operating system is a set of programs that manage computer hardware resources and provide common services for application software.  There are following kind

Hypermedia, Hypermedia: When the desired webpage loads into your brows...

Hypermedia: When the desired webpage loads into your browser you will see the text comes in, the pictures arrives, the animation gets loaded and so on. You will notice that so

Logic instructions , They are used to act upon logic operations on the oper...

They are used to act upon logic operations on the operators. AND OR, NEG NOT TEST XOR AND INSTRUCTION Function: It acts upon the conjunction of the operators bit by bit. Syntax: A

Reflex agent-artificial intelligence, Reflex agent-Artificial Intelligence ...

Reflex agent-Artificial Intelligence If an agent decides and executes an action in response to a sensor input without consultation of its world, then it may be considered a ref

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