Questions tagged [ms-access-365]
6 questions
1
vote
2 answers
Enforce 1 or many relationship
In the er diagram below (not mine),
A Class can have many instructors via a standard junction table.
Is there a way of designing the Instructors/Classes tables using constraints to ensure that a Class must have at least one Instructor? I.e. 1 or…
Octothalamus
- 13
- 2
1
vote
0 answers
Can I use a Composite Key as criteria for selection in a query?
I have created a meeting minutes table and would like to use two fields as a unique ID for each meeting (field one is a meeting code (lookup from another table) for each type of meeting and field two is the meeting date - the combination would be…
mlkornegay
- 11
- 1
0
votes
1 answer
How can I import multiple .xlsx and .xls files into multiple tables in Access?
I have 100 .xslx and .xls files with different formats and I need to import them all separately into Access keeping their original file names intact.
Folder example:
C:\Users\username\Desktop\2019_data\foldername\
sample names of the many…
0
votes
1 answer
See direct (instead of indirect) info about rented book in my "actors_directors" talbe dropdown list - Access365
I'm building a database of "actors_directors" who are renting "books" from my library - a kind of exercise to learn database basics :-)
This is how my "actors_directors" table looks like. They are the customers who are renting the books from my…
michal roesler
- 125
- 7
0
votes
0 answers
SSMA cannot read meta data (missing runtime components)
What I want to do should be rather easy: Use SSMA to transfer internal Access tables and queries to SQL-Server.
On my Notebook I'm running SQL-Server 2017 and Office 365 (32 bit)
As I have 32 bit Office (company's choice ...), I installed the…
Gottfried Lesigang
- 553
- 1
- 6
- 13
0
votes
1 answer
How does one create a data base for a survey/questionnaire?
I need to create a database for a wordy questionnaire. At the end I want to be able to graph my information. Where can I do this?
user75873
- 1
- 1