HomeworkLib
Question

Microsoft Access 2013. Possible to attach the database here ? Make a list of at least...

Microsoft Access 2013.

Possible to attach the database here ?

Make a list of at least two different queries you could create related to this event database. Remember that you can run queries on a single table, or, because these tables are joined in relationship, you can run queries based on multiple tables. One of the two queries should be a multiple-table query.

Your query list should include-type of query ( I.e simple query, exact match, parameter, cross tab, etc), the fields you would include in the query, any conditions placed on the criteria line( I.e Finish race, "YES",) and purpose of the query.
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

PROCUCT_DETAILS PRODUCTID PRODUCTNA 100 Laptop 101 cellphone 102 Television 米 we can attach database in using Ms-Access.ORDER DETAILS ORDERID PRODUCTID UNITPRICE QUANTITY DISCOUNT 10 34 56 101 100 102 $17,000.00 $25,000.00 $30,000.00 $560.00 $2,

0 0
Add a comment
Know the answer?
Add Answer to:
Microsoft Access 2013. Possible to attach the database here ? Make a list of at least...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Microsoft Access 0 database name should be the broad name of what will be inside it....

    Microsoft Access 0 database name should be the broad name of what will be inside it. If I were creating a database on the history of the Pittsburgh Steeler Coaches I would call mine SteelerCoaches.accdb, for example. A. Design one table with at least a. 6 Fields (can have more, but not more than 10) b. Correct datatypes for your fields c. Property changes appropriate to the fields. Have all Field names with more than one word have no spaces...

  • Lab Assignment – Database Implementation and Security In this lab you will create a Microsoft Access...

    Lab Assignment – Database Implementation and Security In this lab you will create a Microsoft Access database of employee information and secure the table username and password security. Steps Enter data for five employee records. Each record should have fields: Employee ID (5 digits), First Name, Last Name, Home Address, Hire Date Create a query that displays Employee ID, First Name and Last Name. Create a form that requires entering username and password to access employee table. Error message should...

  • Lab Assignment – Database Implementation and Security In this lab you will create a Microsoft Access database of employee information and secure the table username and password security. Steps Enter...

    Lab Assignment – Database Implementation and Security In this lab you will create a Microsoft Access database of employee information and secure the table username and password security. Steps Enter data for five employee records. Each record should have fields: Employee ID (5 digits), First Name, Last Name, Home Address, Hire Date Create a query that displays Employee ID, First Name and Last Name. Create a form that requires entering username and password to access employee table. Error message should...

  • Please access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to...

    Please access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to retrieve all the data field from db_pvfc12_std in table CUSTOMER_T 2.- Run a query to retrieve record --> CustomerID = 11, How many records did you get and why? 3.- Run a query to retrieve all the data field from table Order_T               Once retrieved:                              3.1.- Please name the fields showing: Primary Key, Foreign Key and other fields                              3.2.- What type of...

  • ACCESS 2019 DATABASE ASSIGNMENT 1.What data type is used for the Contact First Name field? 2.What...

    ACCESS 2019 DATABASE ASSIGNMENT 1.What data type is used for the Contact First Name field? 2.What data type is used for the Opened field? 3.What is the Field Size of the City field? 4.What is the Field Size of the State Abbrev field? 5.What is the Field Size for the Number of Employees field? 6.In Field Properties, what is the Default Value for the Number of Employees field? 7.What is the Company ID for the fifth record (“5 of 21”)...

  • Use MS Access software to build tables, as well as write, and execute queries. Submit the...

    Use MS Access software to build tables, as well as write, and execute queries. Submit the database and screenshots of all tables and queries. Step by step snapshots included. Don't want queries. Just process of creating this data step by step in Access. Create your own data. Ensure the data will test all criteria and prove all sorts worked as required. Be sure that all tables and queries have descriptive names. “Query 1” and “Step 1” are examples of poor...

  • The relational schema for the Academics database is as follows DEPARTMENT(deptnum, descrip, instname, deptname, state,...

    The relational schema for the Academics database is as follows DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) ACADEMIC(acnum, deptnum*, famname, givename, initials, title) PAPER(panum, title) FIELD(fieldnum, id, title) INTEREST(fieldnum* acnumk, descrip) Some notes on the Academics database An academic department belongs to one institution (instname) and often has many academics. An academic only works for one department. Research papers (PAPER) are often authored by several academics, and of course an academic often writes several papers (AUTHOR) A research field (FIELD) often...

  • 16) What does Access do to denote action queries differently in the Navigation pane? A) It...

    16) What does Access do to denote action queries differently in the Navigation pane? A) It displays them in bold text. B) It displays them in a larger typeface. C) It displays them in a section called Action queries. D) It displays them using specific icons. 17) Which of the following is not a rule for using an Append query? A) Data types in both tables much match (with some exceptions). B) There must be the same number of fields...

  • The relational schema for the Academics database is as follows DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode)...

    The relational schema for the Academics database is as follows DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) ACADEMIC(acnum, deptnum*, famname, givename, initials, title) PAPER(panum, title) FIELD(fieldnum, id, title) INTEREST(fieldnum* acnumk, descrip) Some notes on the Academics database An academic department belongs to one institution (instname) and often has many academics. An academic only works for one department. Research papers (PAPER) are often authored by several academics, and of course an academic often writes several papers (AUTHOR) A research field (FIELD) often...

  • Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables...

    Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables and include both one-to-many and many-to-many relationships. Be sure to include some numeric and/or date fields. Define all appropriate constraints, using the proper naming conventions (see Structure Notes below). Populate your database with at least 30 records in the main table(s), and whatever is needed in related tables. Submit the following: • a short description of the purpose of the database and what the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT