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

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

Enterprise resource planning, ENTERPRISE RESOURCE PLANNING What ...

ENTERPRISE RESOURCE PLANNING What has football got to do with it? asks management guru Michael Hammer in his latest best seller Beyond Reengineering. The answer is almos

Binary codes, Binary Codes: We have seen earlier that digital computer...

Binary Codes: We have seen earlier that digital computers use signals that have two distinct values and there exists a direct analogy between binary signals and binary digits.

What is the difference between kernel mode and user mode fun, The differenc...

The difference between kernel mode and user mode gives a rudimentary form of security in the following manner. Convinced instructions could be executed only when the CPU is in kern

Oprator, what is member dereferencing oprator ?

what is member dereferencing oprator ?

Bandwidth, Bandwidth: Bandwidth is the second concept important for tr...

Bandwidth: Bandwidth is the second concept important for transmission. This concept can be explained with the help of the traffic network mentioned earlier. If there is a two-

Assembly language, write and run the following programs using 8086 assembly...

write and run the following programs using 8086 assembly language that interchange the upper and lower four bits of AL register.

Quantitative Methods in Business Decision Making, 4. Union City Al has dec...

4. Union City Al has decided to upgrade their tornado warning system. The city leaders have identified six potential locations for erecting a warning siren tower. They want to e

Pipelining, tellme the types of pipelining

tellme the types of pipelining

Algorithms, write algotithm and flow chart for largest of 3 numbers

write algotithm and flow chart for largest of 3 numbers

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