Search results

Yes - all the inner joins are unnecessary if the desired Student Profile records required always contain valid FK references. Any Student Profile records that do not match to the other table on the FK (eg a null FK in Student Profile) are excluded in the result. Using a Left join for these may...

Try this - I do not think you need to use UNSW_Maths table - appears to be trying to retrieve course code twice. The focus is to id the students in the course, that are school leavers and failed the course. SELECT [Student Profile].UNSW_MATHS_COURSE_CODE ,Grade.GRADE_DESCR...

@LarryE - I hope the OP will learn from the help provided here. While the OP may launch into a physical design and may have created some tables and relationships, as the OP recognised, it was incomplete/ flawed and your input may assist. However, without getting into systems design and...

Based on this and your other post you are at the very beginning of your journey to learn not just about MS Access, but about relational databases design and development. First answer some of the questions raised above - what is your intent? Is this database to be used to manage a school you are...

What help do you need? You have posted a database containing tables relating to students and classes, fees and teachers, etc. A school database can be very extensive or limited depending on YOUR needs. Specify what it must do. Research to find what others have done. Concentrate on the...

You can't use a template file when using OutputTo with Excel. From the MSDN documentation:

Note - as you have said, and require, that a Proposal exists and then, when accepted, becomes a Project (and a project can only have one proposal) then you may as well say a Project-Proposal is the one table and the proposal becomes a project when its status is changed to accepted. That may be...

So a contact is associated to a company - so why have the FK to the company in the Proposal table? You can obtain/display that from the contactID FK in Proposal, joined to Contact table then to company via its FK to Company in the display of Company of the form - it would be a read-only, and...

Hi @dalski - I question what you are attempting or expecting to happen here: The "Client Company" combo's purpose is to select a company from the list of all Companies (based on a Companies table query), so that the list of contacts is restricted to those associated to the Company. Do you...

From your responses and discussion, I would agree with @June7 that 1 table for all proposal types would seem appropriate for you. Pat's EAV suggestion could also work for you however you would have to deal with a more abstracted table design and underlying coding. You still need to...

For me it is up to the individual when they sign up to a membership to specify/nominate a salutation, which is optional. Don't make assumptions. Communications with the member reflect their choices - not yours. If memberships are family-based, or some other grouping (eg. organisation...

Reinforcing the foundations: you must get your database schema right for the job you want to do, which as others above have mentioned and offered some insights. From what has been described by you I would suggest some changes / thoughts about the rules/relationships you are interested in: A...

@RFreund - preliminary observations and questions: - some typos in naming fields - hopefully not in the real table: ProposalTypeID, ProjectCountry - does the Main Proposal Table have a ProposalID PK (autonumber?) - The type tables provide further detail specific to the type. Is ProposalTypeID a...

From the picture there are 6 duplicates of each of the 2 records shown, however the data set is much wider than shown. Are the columns shown the only ones of interest in determining a duplicate? From within Excel: To identify and retain a single record from a set of duplicates in a dataset, you...

A star schema might look like below, however I do not have the subject matter expertise to be sure about the placement of data in the tables (eg AdmissionID and UNSWStudentID (I took some liberty with some names)). The dimension tables would generally contain every combination of the...

Step 1: Identify and remove duplicates: in what sense are they duplicates? As this is an extract of data / combined data from multiple queries of the uni enrolment system (possibly combined with data from UAC or external sources) then what combination of data will allow you to determine the...

Form what is being described at #14, the data is only for reporting so the OLTP normalised model is not applicable. This is essentially a data set that should be structured as a data mart - star schema or snowflake style schema are more applicable (for a RDBMS solution - after cleaning out...

The above link provided in the code is no longer active: so you need to look furth afield: eg: https://learn.microsoft.com/en-us/windows/win32/api/winuser/nf-winuser-activatekeyboardlayout...

I don’t get it: TikTok – if the rationale is to force it to be sold to American interests because the app may secretly be used to “spy” on what you are doing/saying or influencing you, then: If it is sold, are you not buying the “algorithm” that is TikTok? If you are buying the TikTok...

Your structure includes employees and other tables that are not in scope of the extension you require. The following is a preliminary structure for discussion and review. A discussion of inventory and stocktaking with sample access code/ db is available here...