98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Access articles
Access: Things You Probably Already Know
Fri 24th December 2010
To give you an example of just how easy it is to manipulate data in Access I will use as an example my first brush with it, a database of films available at the video rental store I was the manager of back in the late nineties.
The list of titles had four fields: the number of the film, which was also displayed on the cassette on a sticker, the title of the film, the genre and the year of release.
As the films were listed in numerical order, it would be difficult to search for a particular film as the titles were in no specific order. If someone came in and asked if we stocked a certain film it would be a nightmare scrolling through the hundreds of titles in search of that particular one. There are two easy solutions to this.
One is the Find function. To find the title you want, say Fargo, which was a popular choice back when I was running the store, select the film title field. Go to Edit/Find, or click on the Find button on the toolbar, which is in the shape of a pair of binoculars. Type in the title and press Enter. The film title will now be highlighted. Note, though, that although we have six copies of Fargo in stock, only one title is highlighted - and it is out on loan. Simply re-click the Find Icon and then click the Find Next box. This will move the highlight on to the next copy of Fargo.
Another way of finding a particular title without sifting through reams of text is to use the Sort function. Again select the field you wish to sort, which is the film title one. Next go to Records/Sort Ascending, or click the icon on the Table Datasheet toolbar that is a capital A above a capital Z with a downward arrow to the right. This will sort the data as requested and the film titles will now appear in alphabetical order and it is simply a matter of scrolling down to the ones beginning with F.
So as you can see performing basic functions within Access is not quite as daunting as it seems. You are possibly already familiar with many of the functions and icons through using Excel. In fact the instructions above for using the Find and Sort functions could be copied and pasted into an article on Excel, as the processes are identical. So don't be put off by Access's reputation; take it up and you may find that you already know a great deal of the basics.
Author is a freelance copywriter. For more information on access training london, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-1330-access-things-you-probably-already-know.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsLady Margaret School
KS5 ADMISSIONS/ADMINISTRATOR Louisa Harper Excel Advanced Very helpful, picked up lots of tips! Marquee Contracting
Payroll Administrator Amy Griffiths Excel Intermediate Very thorough and informative course, covered all areas I had doubts on and now believe I have a good understanding on how I can apply what I have learnt to my day to day job role. MBIA Services Corporation UK Branch
Administrator Nicola Stewart Word Intermediate Another really enjoyable, really informative Course from Best STL!! Highly recommend! |
PUBLICATION GUIDELINES