Create a new database file access

Assignment Help Basic Computer Science
Reference no: EM132515474

Practice - Access

Problem 1: Table

1. Create a new database file "Access- Employee" then perform the following:

2. Create table with name "Employee" contains the following fields:
• E-ID: Number and make it as a Primary Key
• First Name: Short Text
• Last Name: Short Text
• Salary: Number
• Birth Date: Date/Time
• Department: Short Text
• Position: Short Text

3. Insert the first record in the table

1459_table.jpg

Problem 2: Queries

Create the following Queries on employee table:

» Query that views all the information for the employee work at IT department. Save it as Query1.

» Query that views the fields (E-ID, First Name, Last Name and salary) for all employees their salary is greater than or equal 30000. Save it as Query2.
» Query that views the fields (E-ID, First Name, Last Name Department and Position) for all employees their Department is "IT" and their Position is "Manager". Save it as Query3.
» Query that views all the information for all employees whose birth date in 1970 or their position is officer. Save it as Query4.
» Query that views all the information for all employees their first name's start with letters M or A. save it as query 5.

Problem 2: Forms

» Tabular Form that views all employees' information based on employees table. Save it as your name.

1620_table1.jpg

» Justify Form based on Query4. Save it as Query4_form.

153_table2.jpg

Problem 3: Reports

» A block report based on Employees table which views all information classified by department.

Show the sum salary for each department then save it as Employee.

Reference no: EM132515474

Questions Cloud

Total inventory costs for the optimal order quantity : Compute the demand forecast for period 15 using the exponential smoothing with alpha equal - How many orders will be placed per year using the optimal order
Analyze how to develop consulting services : Analyze needed services by sector, service line, or phase to meet target and Analyze how to develop consulting services
Body language and mannerisms : Effectiveness of introduction, body, conclusion Overall organization Emphasis on two to four major points - Use of evidence to support claims Enthusiasm
World globalization in the few coming years : Do you think that China instead of the USA is capable of steering the world globalization in the few coming years ? WHY and HOW?
Create a new database file access : Create a new database file Access- Employee then perform and Create the Queries on employee table - Show the sum salary for each department
Reflective journal on professional exposure : Reflective journal on professional exposure - Write a report on some webinars you have attended with the proof of screenshots that you have attended
Write literature review about conceptualizing leadership : Identify how you view leadership and explore your perceptions of different aspects of leadership - Write literature review 3 pages about conceptualizing leaders
What is covered in relation to the police innovation : Provide a brief and concise summary of what is covered in relation to the police innovation and what is the major conclusion/finding
Determine backward finite difference for first derivative : Determine the backward finite difference for the first derivative of v with step size k = 15 at mesh point i = 4. At the same point, also calculate the exact

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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