<div>
See this link for a ready made Sports database (costs less than $200):<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <a href="http://www.thegolassocompany.com/id21.htm" rel="ugc">http://www.thegolassocompany.com/id21.htm</a><br />

</div>


See this link for a ready made Sports database (costs less than $200):

              http://www.thegolassocompany.com/id21.htm [http://www.thegolassocompany.com/id21.htm]


<div>
Jim,<br />
<br />
On the Game table, how would I run a query that would show all games that an referee did? &nbsp;Bear in mind that the referee will sometimes be listed as referee1 and sometimes as referee2. &nbsp;Also, when I run the query, I want to see the referee by name, not their &quot;ID&quot;.<br />
<br />
Thanks,<br />
<br />
<br />
Joey
</div>


Jim,

On the Game table, how would I run a query that would show all games that an referee did?  Bear in mind that the referee will sometimes be listed as referee1 and sometimes as referee2.  Also, when I run the query, I want to see the referee by name, not their "ID".

Thanks,


Joey

<div>
<div class="content wysiwyg-content">
I am trying to build a database that will allow me to schedule officials for baskeball games. &nbsp;I will have multiple game sites for the same day. &nbsp;I will have one official for some games and two for others. &nbsp;There will be times that an official will do up to 6 games in one day. &nbsp;Can someone help me get started here? &nbsp;Should I just have one table, or multiple tables? &nbsp;I am not an expert in using Access, so any help in getting started would be appreciated. &nbsp;This database is for a local youth league 1st - 6th grades.<br />
<br />
<br />
<br />
Thank you in advance,<br />
<br />
<br />
<br />
Joey Bruington
</div>
</div>


I am trying to build a database that will allow me to schedule officials for baskeball games.  I will have multiple game sites for the same day.  I will have one official for some games and two for others.  There will be times that an official will do up to 6 games in one day.  Can someone help me get started here?  Should I just have one table, or multiple tables?  I am not an expert in using Access, so any help in getting started would be appreciated.  This database is for a local youth league 1st - 6th grades.



Thank you in advance,



Joey Bruington

Create Access Database to schedule Officials for Basketball

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.