By Mark Whitehorn

Obtainable Access 2003 assumes that you simply commence with very little wisdom of entry or databases and takes you to the purpose the place you could create and use a multi-table database. beginning with the elemental components of a databaase - tables, kinds, queries and experiences, the authors aid you create basic examples of every utilizing the entry wizards the place applicable, and the way to hand-build them so you might in achieving greater than you could utilizing simply the wizards.  when you are pleased with making a easy database which shops its information in one desk, the authors circulation directly to a number of tables - why you would like them, and the way they are often used to create relatively potent multi-table databases. available Access 2003 is written in a hugely readable kind, with plenty of examples, tricks and strategies for construction tables, extracting facts and producing reviews.

Show description

Read or Download Accessible Access 2003 PDF

Best software: office software books

CIO Survival Guide: The Roles and Responsibilities of the Chief Information Officer

CIO Survival consultant is a management handbook for the rising function of the executive details Officer. This e-book helps and courses CIOs in buying or bettering their technical talents and management capabilities to be a whole and revered member of the administrative workforce. It contains exposition and perform of the talents and talents required to be a winning CIO.

Additional resources for Accessible Access 2003

Example text

Wildcard is much more specific (and therefore used less frequently) and substitutes for a single character. ’ will find Carmel but not Cardiff (both of which exist as cities in the ClubMembers table) because Cardiff has seven letters, not six. Access will again add inverted commas to turn the criterion you type as car??? ” This simply means ‘Find the records which are like this’. Of course, you can type the expression in full, but why not let Access do the hard work? We’ve been experimenting with this query so once you’ve finished exploring the delights of wildcards and such, there’s no need to save it though you can do so if you wish.

Run the query. Now a subset of fields is displayed for all records. Incidentally, I’d love to tell you that I was good enough to always build exactly the query I want first time, but it isn’t true for me and I suspect it isn’t for most 43 4 Queries – finding data database designers. Designing a query is often an iterative process. You do some of the design work, run the query and see what you get, alter the design a bit, run it again and so on until it is perfect. So, for example, in this case, perhaps you want to see phone numbers as well.

It is well worth playing around with a table of test data to get a feel for what you can and can’t do before working with real data. ’ The advice given there can safely be ignored for this first table but is worth following for real databases that you build in the future. Records and fields revisited A record comprises all the data you collect for one person, urn or whatever. In the address book example, everything entered in the database about Person X comprises their record – which is a single row in the table.

Download PDF sample

Rated 4.22 of 5 – based on 39 votes