Course database learn Microsoft Access Step by Step

INTRODUCTION

Access is a database management system that you can use independently, or you can use it as part of the  Office Suite. A database is just a file, very similar to the word processing files and spreadsheets you’ve worked  with before. But there are a few differences. A database is used to store data – a single collection or several  sub-collections. A database can hold all kinds of data–and there’s no specific size limit. The size of the  database file is only limited by memory and hard disk space. As for what it contains, databases contain fields  and records. A record is like an entry in an address book, and the fields are the individual bits of data: name,  address, and phone number. Here are two sample databases:
Compare:
– The Customer table has six columns (or fields): Customer ID, Name, Address, City, State and Zip and  three rows (or records) of data.
– The Accounts table has five columns (or fields): Customer ID, Account Number, Account Type, Date Opened and Balance and four rows (or records) of data.
FYI:
– Files created with Access 07 are .accdb files (previous versions of Access are .mdb files).
– Access is not forward compatible, meaning that older versions of Access cannot recognize newer file  formats without converting them to the older file format. Access 2007 can open database files  created in earlier versions; however, Access 2007 can only provide the same level of functionality as  the original Access program.

LET’S GET STARTED!

Part I— Open Access and create a blank database.
1. Before you click on the “Create” button, be sure you change the name from database1.accdb to NUTRITION FIRST LAST NAME. Also, change the location that the database file will be saved from  the C: drive to your network folder. (Be sure to create a new folder for all of your database files.
Call it Access.) Then click on the Create button.
2. Next, switch  to design  view. When  you are  prompted to  save your  new table,  save it as  “FAST FOOD  XXX”  (replace XXX  with your last
name )

……

Si le lien ne fonctionne pas correctement, veuillez nous contacter (mentionner le lien dans votre message)
Microsoft Access Step by Step (6537 KO) (Cours DOC)