Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access training course - database

Forum home » Delegate support and help forum » Microsoft Access Training and help » access training course - Database

access training course - Database

ResolvedVersion Standard

Joanna has attended:
Access Introduction course

Database

how do I set up an access database?

Creating a Microsoft Access Database

Hi Joanna

I trust that you found your MS Access course very informative today, by now I assume that you have already been taught how to create your Microsoft Access Database. However just a quick recap.

You need to open a blank MS Access database and go into design view, whilst in design view, you can enter row by row the details of each column you want in your database along with the data type and description when this is done, change views and you should have you database. It will ask you to save it first though.

Hope this helps

David

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.