The president already knows the information he needs to store in the database because it's been recorded using a card system for some time. In this case the club president wants to be able to find quick answers to questions such as 'Who hasn't paid their fees?', 'Who are the A grade players?' and 'Who is due for their 10 year pin this year?'. To do this, begin by considering what you want your database to do. Before you open Accessīefore you launch Access, design your database on paper.

If you are using another version, check the screen to find the option which matches the one I have suggested you use. The instructions use Access 2013 but they'll work pretty much the same in any version of Access from Acccess 97 on. Here is the information a local cricket club records for its players: Since this is a sample database we'll keep it very simple. At first look Access does appear overwhelming, but, by the time you've finished this tutorial you'll be comfortable using it and ready to try more things. I'm assuming that you have never used Access before - or perhaps that you've opened it, taken a look around and closed it thinking it all looks a bit difficult. Once the data is in the database you'll learn how to get information out of it by printing a report listing all the contents and by searching the data.

You will see how to create a table to store your data and then how to enter the data.

To get you started, I'll show you how to develop a small database in Access. However, there's no better way to begin learning about Access than actually using it. Access is an extremely powerful and complex database program and when you use it to manage a very simple database it is overkill. The first time you use Access you'll be excused for thinking you're using a very big hammer to crack a very small nut. First steps with Access Learn, step-by-step to create your first Access database.

Microsoft access 2013 step by step