Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2003

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access 2003

Resolved · Medium Priority · Version 2003

Reply Tue 16 Nov 2010, 16:04Delegate Mairead said...

Mairead has attended:
Access Intermediate course

Access 2003

Which is the best way if a student is given 2 text files in a controlled exam and have to import them into access. They are required to create a three tables. Do they create the tables without validation rules and import and then again create the validation rules and re-import to see what import errors there are?

For upcoming training course dates see: Pricing & availability

Reply Thu 18 Nov 2010, 20:03Trainer Anthony said...

RE: Access 2003

Hi Mairead, thanks for your query. First of all importing 2 text files to create 3 tables is going to involve either splitting or duplicating some of the data during the importing process, so it might be best to split the data first and then import. Having said that, it depends a lot on situational factors and what you want the final database to be able to do. Similarly, if you are appending imported data to a table the validation rules may already be in place, whereas if the imported data is standalone and forming the basis of a new table, imposing validation rules after the fact may be the best way to go. There is no single best way to do this but the main contributing factor under exam conditions will be the time allowed! Speed may be of the essence!

Hope this helps,

Anthony

Reply Tue 23 Nov 2010, 12:00Trainer Richard said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 29 Nov 2010: Automatically marked as resolved.

Access articles

· Discover the Secrets within Your Business through Microsoft Access Training
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· How Access Can Provide The Key To Successful Stock Management
· Find Out All About Microsoft Access Report Sections
· Discover The Top Ten Changes In Access 2010

Please browse our web site to find out more about
access class ms training and other Microsoft training courses.

Access tip:

Create own ribbon tab - Access 2010

a. In Access click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Access hints and tips