DataBase - student absence database in Access

How do I set up a one teacher use, multiple class, 3 lessons of different
durations per week for 10 weeks database?

  duanehooko replied...

Start by creating more complete requirements. Then build your normalized
tables. Then build your queries, forms, and reports.

--
Duane Hookom
Microsoft Access MVP

  JMVincen replied...

I guess my problem is selecting the correct entities  to create normalised
tables. The rest is fine.

  duanehooko replied...

I would expect the student absence table to have fields like:

tblStudentAbsence
==================
StudAbsID  autonumber primary key
StudentID    related to tblStudents.StudentID
AbsenceID   related to tblAbsenceCodes.AbsenceID
AbsenceDate
AbsenceComment
--
Duane Hookom
Microsoft Access MVP

Roger Jennings on Access / Sharepoint DataBase http: / / www.quepublishing.com / articles / article.aspx?p = 1606238 I was very dismayed is it makes it pretty clear that in-house hosting of your Sharepoint server with Access Services to support browser-based Access apps is something only large companies will be able to afford, because the pricing and licensing for the Enterprise version is very, very steep. The alternative is hosted Sharepoint / Access Services, and the costs do not seem terribly high. It seems to me that the pricing is upside-down. Big enterprises do not want to deploy Access apps in the browser - - they will build their own .NET apps, browser-based or not 2010, it could vastly increase those costs for organizations with legacy hardware). The features of Access 2010 used in conjunction with Sharepoint 2010 seem to me to be most compelling for and small businesses. I do not know if I could sell clients on hosted Sharepoint / Access. I have been able to sell clients on hosted Exchange, and it is been very W. Fenton http: / / www.dfenton.com / contact via website only http: / / www.dfenton.com / DFA / Access Discussions SQL Express (1) SQL Server (1) MySQL (1) Exchange Server (1) Windows Server (1

Access 2010 for software development DataBase Hi, What do I need to use Access 2010 (or perhaps 2007) to port our 2003 application and create an executable (MDE in Access 2003)? Are there any issues with 2010? -paulw Access Discussions SQL Server (1) SharePoint (1) Albert D. Kallal (1) Office 2007 (1) Office 2003 1) Access 2007 (1) Access 2010 (1) Access 2003 (1) You can use Access 2010 to develop your MDB until it is ready to release, but you will then

seconds to load. There is a possible reason, it reads from a local MDB file (access), and it reads from some 270000 rows (result some 15-20 rows, where the highest are counted 150000, 50000, 40000, 26000, remaining are 100's). This is probably more Access that Visual Studio, though - is there a way to split it up or cancel the code takes less that 0.1 second. So the query is what slows it down. Access Discussions SQL Server (1) Linson Unlike Albert D. Kallal (1) MySQL (1) Windows Server 2003 (1) Visual Studio (1) SharePoint (1) NHibernate (1) Microsoft SQL Server (1) Hi, Besides that your code is full of SQL injection bugs because help for this task. And an appropriate index might help to avoid the full table access. By the way, grouping by a.event_id in conjunction with count(a.event_id) makes no not, each and every record needs to be loaded and compared. The JET engine behind Access is not suited to handle databases beyond stamp collection size and lacks most features of should restrict your post to the dotnet / csharp newsgroups, so those in comp.databases.ms-access who _do_ know about Jet and Ace will not see and correct your erroneous claims. Larry Linson Microsoft Office Access MVP Co-Author, "Microsoft Access Small Business Solutions", Wiley, 2010 Utter rubbish and

more confused I get. Looking forward to getting a new toy though! Cheers The Frog Access Discussions Larry Linson Microsoft Office Access MVP Co author Microsoft Access (1) James A. Fortune CDMAPoster (1) Visual Studio 2010 (1) Entity Framework (1) Microsoft Excel (1) Microsoft Word (1) Office 2010 (1 Access 2007 (1) No. There is a free Access 2007 / 2010 runtime you can download and

Microsoft-Newsgroups sollen ab Juni abgeschaltet werden DataBase Hallo, dieses ist absichtlich ein cross-posting, denn es betrifft (unter anderem) diese NGs. http: / / www.heise.de / newsticker / meldung / Microsoft-Newsgroups-werden-abgeschaltet-993861.html Ich w?rde es sehr bedauern, zuk?nftig auf die vor allem f?r die regulars hier, in das deutsch-sprachige usenet umzuziehen? F?r Access gibt es de.comp.datenbanken.ms-access f?r Word + Excel g?be es de.comp.office-pakete.ms-office ganz logisch einzelnen NGs verfolgen und daraus ggf. Argumente f?r eine Neueinrichtung / ?nderung sammeln. Gru? Irmgard Access Discussions SQL Server 2008 (1) SQL Server (1) Windows XP (1) Office XP (1) Microsoft Excel (1) Microsoft Word (1) Office 2003 (1) Silverlight (1) Hallo Imtraud, ich habe jetzt den Beitrag nicht nicht vorliegen. Das wird aber nocht rechtzeitig i Forum mitgeteilt. Gru?? Hajo MVP f??r Microsoft Excel Betriebssystem Vista Ultimate SP2 und Excel Version2007 SP2 http: / / Hajo-Excel.de / Irmgard Schwenteck