Create a database in access, Basic Computer Science

Assignment Help:

The following are required:

Create a project in Access. Your database must have flow and a theme.
The database must be normalized.
The content must be relevant to the database fields. As an extreme example, this means do not put address in a name field
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
Your project must include at least three tables
Your tables must make use of data validation rules
Make use of data validation text
Each table must have a primary key or an appropriate combination key
At least one foreign key is required but additional ones must be used if the database merits their use
Your project must make use of at least one input mask
Your project must include proper and working relationships between tables. Be sure the relationships are valid and referential integrity is observed
Your project must include at least three queries
Your project must include at least two "customized", working forms. At least two; if you need more, you must create them.
Your project must not make use of direct entry into tables and strictly use forms for data input
Relevant pictures to the project appropriately placed on forms
Your forms must include a form header or form footer
Your project must include at least one report based on a table and at least one report based on a query
Spelling counts
Grammar counts
Your project must include your name

Related Discussions:- Create a database in access

Data communication , (iv) Suppose that the TCP entity receives a 1.5 megaby...

(iv) Suppose that the TCP entity receives a 1.5 megabyte file from the application layer and that the IP layer is willing to carry blocks of maximum size 1500 bytes. Calculate the

Info Systems Management, Assignment 1: Project Management and Information ...

Assignment 1: Project Management and Information Security 2-3 page paper in which you: 1. Explicate in detail the importance of project management as it relate to an informatio

Types of policy, want to get detail understanding of the types of security ...

want to get detail understanding of the types of security policies including enterprise security policy, issues specific policies etc

]c language, ehat is header file

ehat is header file

Bus structure, which computer architecture use single bus structure??????? ...

which computer architecture use single bus structure??????? tells the name and little bit working

C++, whats the out put of int main(){ int n=310; funcone(n); functwo(&n); ...

whats the out put of int main(){ int n=310; funcone(n); functwo(&n); cout return 0; } void funcone(intn) n=240; } void func two(intn*) { n=120; }

Joystick, how can use joystick

how can use joystick

Cpu scheduler, Selects among the processes in memory which are ready to exe...

Selects among the processes in memory which are ready to execute & allocates the CPU to one of them CPU scheduling decisions can be taken place when a process: A. Terminates B. Swi

Software engineering, Brief Define the Phases of Waterfall Model

Brief Define the Phases of Waterfall Model

Write down dijkstra''s algorithm, QUESTION (a) Write down the Update ...

QUESTION (a) Write down the Update Step in the Dijkstra's algorithm explaining its complexity. (b) Propose a Generic Algorithm for Depth-First Search Algorithm, assuming

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages